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
- 10054 Views
- Exilant, Siebel, I also Faced
- E-Mail Answers
Answer Posted / swati
In case, your requirement doesn't allow you to create the
new objects at Designer level or use hard coded SQLs, then
you can try to create a prompt in the second dataprovider
named as 'Prev. Year'. When refreshing the report you can
pass the values for current and prev yrs both.
If you do not have a predefined filter for prev yr then you
can use your objects to create the similar conditions as
there are in the filter.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between absolute and relative div positioning?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Can we configure two instances of CMS pointing to two different CMS system databases?
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
Which versions are used in the bo dashboard work?
What are the steps to do to use alerts in bo?
Explain about a task that really tested your analytical abilities?
How were the reports scheduled and how to resolve unexecuted documents?
What is top business?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
in sap bi we have wad, then why we go for sap bo
any difficulitis have you phase while creating bo reports and how did u solve it
how to prepare the documentation in business objects and where to get the requirement?
Explain in detail about type 2(scd),
