Interested to Buy Any Domain ? << Click Here >> for more details...
I have two data providers with common dimension and
measures. The only difference between two data providers is
in condition 'Fiscal Year'.One data provider calculates for
current year and other one calculates for previous year. So
in prompts if I am passing 2008 as current year then the two
data providers should be able to calculate for current year
and previous year individually.
So Can anybody tell me how to do calculation in data providers.
( I am using BO WebI report )
- 6 Answers
- 12220 Views
- Exilant, Siebel, I also Faced
- E-Mail Answers
Answer Posted / bibin
edit sql in dataprovider ,
Date >= add_months(date),-12
and then check "do not generate sql before running" option.
regds
bibin
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
What Is Snow Flake Schema?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
In banking domain how many Fact tables,Dimension table are present?
What is Indexing? how did u implement indexing?
Explain is there any default username & pwd for bo designer & supervisor?
Which versions are used in the bo dashboard work?
what is universe null
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
what is xcelsius architecture?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain about a time when you discovered a more efficient way to do a work task?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
