Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12232 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
How to execute the plsql procedure from the report by clicking with mouse?
When to use local filter and when to use global filter?
What is the difference between datawarehousing and businessintelligence?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
How to open a universe with out using the Designer ??
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
How can you first report in Business Objects by using broadcast agent?
what is xcelsius architecture?
Which versions are used in the bo dashboard work?
What is difference between custom hierarchy and report based hierarchy?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
8. How much supervision have you typically received in your previous job?
Can you please send me the migration related issues .
Explain difference between zabo and webi?
Difference between b.o 5.1 and 6.1b?
