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 )
Answer Posted / anil
Instead using two dataproviders for present and previous
year, why don't you use a formula previous(year dimension)
and calculate in report with single data provider?
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain what are the steps to be taken to schedule the report?
How to open a universe with out using the Designer ??
U r project in which stage in implementation?
Which versions are used in the bo dashboard work?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
What is the difference between slice and dice and cross tab report?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
What Is The Difference Between Oltp And Olap?
How were the reports scheduled and how to resolve unexecuted documents?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain about a tricky situation for which you found a very simple solution?
Explain about a task that really tested your analytical abilities?
Explain what would you consider as your biggest achievement and why?
What is the functional & architectural differences between business objects and web intelligence reports?