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 / gowthami
Create two objects in universe YEAR and YEAR-1
DP1:
Select panel: Other objects + Year +Year-1
Filter Panel: Year=prompt
DP2:
Select panel: Other objects + Year
Filter Panel: DP2.Year=(Use 'select object from another query') DP1.Year-1
Explanation:
DP1:
Assume that year=2014
Filter Panel: Year=(prompt) 2014
Select panel: Other objects + 2014(Year) +2013 (Year-1)
DP2:
Filter Panel: (DP2.Year) 2013 = 2013 (DP1.Year-1)
Select panel: Other objects + (Year) 2013
Since we take the year-1 from data provider 1 the DP2 will always give you the previous year data.
Thanks
Gowthami
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can more than 1 metric be applied on an analytic in business objects?
Did you face any problems while creating reports? Name? Solutions?
is it possible to export the webi reports to crystal reports?with out using businessview?
How can you first report in Business Objects by using broadcast agent?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
how to create metric universe ?
Explain what are the steps to be taken to schedule the report?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
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,
In banking domain how many Fact tables,Dimension table are present?
Explain in detail about type 2(scd),
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is a fantrap in business objects?
When we use aggregate awareness function in designer?
What is aggregate table and aggregate fact table ... Any examples of both?