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
- 10997 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
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Which versions are used in the bo dashboard work?
What are the steps to be taken to schedule the report?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain what task is 98% of the required work of a business analyst?
What is the difference between condition & filter?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
how to create reports on screech?
Give some information on report bursting?
how many reports have u created ? explain a few.
Explain how we drill up week to month?
When to use local filter and when to use global filter?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
