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
- 10492 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
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
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What is thumbnail?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Difference between zabo and webi?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What task is 98% of the required work of a business analyst?
Which versions are used in the bo dashboard work?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
what is the difference b/w the refresh and buffered data?
Explain what are the measure objects?
what is universe null
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What is a fantrap in business objects?
Explain what are the steps to be taken to schedule the report?
