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
- 11939 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
Explain what is the difference between slice and dice and cross tab report?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain what task is 98% of the required work of a business analyst?
Difference between b.o 5.1 and 6.1b?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain difference between zabo and webi?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How to create Index to the table in the universe designer and how it improves the Query performence
What is top business?
how to create metric universe ?
Explain is there any default username & pwd for bo designer & supervisor?
