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
- 11015 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
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain what are the steps to do to use alerts in bo?
what are the day to day activities of BO administrator ?
What Is The Difference Between Oltp And Olap?
How to execute the plsql procedure from the report by clicking with mouse?
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?
What is the difference in creating filters in designer and business objects?
how to prepare the documentation in business objects and where to get the requirement?
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
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
what is document design in boxi,have u participate in that
Explain what is the difference between business requirement document and use case document.
How to open a universe with out using the Designer ??
What is thumbnail?
Explain about a tricky situation for which you found a very simple solution?
