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
- 10494 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 xcelsius architecture?
What is a fantrap in business objects?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
how to create reports on screech?
Explain the data types present in bo and what happens if we implement view in the designer and report?
what are the day to day activities of BO administrator ?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain is there any default username & pwd for bo designer & supervisor?
Explain when we use aggregate awareness function in designer?
What sort of existing documents should business analysts refer to when starting on a new project?
explain in detail about type 3?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Can anybody tell me what are the tuning problems?
What is top business?
