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
- 12578 Views
- Exilant, Siebel, I also Faced
- E-Mail Answers
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
What is aggregate table and aggregate fact table ... Any examples of both?
explain in detail about type 3?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
How would you format some text using css to be verdana and bold?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
how many reports have u created ? explain a few.
What are the data types present in bo? What happens if we implement view in the designer and report?
What sort of existing documents should business analysts refer to when starting on a new project?
Explain about a tricky situation for which you found a very simple solution?
What is the difference between business requirement document and use case document.
Explain about a time when you discovered a more efficient way to do a work task?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Explain what is aggregate table and aggregate fact table ... Any examples of both?
what is document design in boxi,have u participate in that
