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
- 12198 Views
- Exilant, Siebel, I also Faced
- E-Mail Answers
Answer Posted / manisha
Create 2 objetcs at Univ Level ,
Current fiscal year =
to_char( sysdate,'YYYY')
Previous Fiscal Year =
to_number(to_char( sysdate,'YYYY'))-1
Now in the DP for the current fiscal yr, pull Current
fiscal year , measures will be automatically be computed as
per the current fiscal yr.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain what task is 98% of the required work of a business analyst?
What would you consider as your biggest achievement and why?
What are the join problems comes appart from loop,chasm & fan Traps
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What is thumbnail?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain how many universes can be created in a project?
in sap bi we have wad, then why we go for sap bo
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
U r project in which stage in implementation?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Is there any other repository domains rather than universe, security, document?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
