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
- 10979 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 about a task that really tested your analytical abilities?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What sort of existing documents should business analysts refer to when starting on a new project?
What task is 98% of the required work of a business analyst?
what is the difference b/w the refresh and buffered data?
How to restrict password to a user while sending a document in .pdf format
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
In banking domain how many Fact tables,Dimension table are present?
How to generate the report from excel sheet?
Is there any other repository domains rather than universe, security, document?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain what is the difference between slice and dice and cross tab report?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What is object stores?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
