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
- 11941 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
What are the steps to do to use alerts in bo?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What sort of existing documents should business analysts refer to when starting on a new project?
What is package in BO
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Can we Save (save as) WEBI Doc as DESKI?
How to execute the plsql procedure from the report by clicking with mouse?
how to create metric universe ?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
how to prepare the documentation in business objects and where to get the requirement?
Explain is there any other repository domains rather than universe, security, document?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
What are the data types present in bo? What happens if we implement view in the designer and report?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain the difference between detect alias and detect context?
