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
- 12211 Views
- Exilant, Siebel, I also Faced
- E-Mail Answers
Answer Posted / swati
In case, your requirement doesn't allow you to create the
new objects at Designer level or use hard coded SQLs, then
you can try to create a prompt in the second dataprovider
named as 'Prev. Year'. When refreshing the report you can
pass the values for current and prev yrs both.
If you do not have a predefined filter for prev yr then you
can use your objects to create the similar conditions as
there are in the filter.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is there any other repository domains rather than universe, security, document?
What is difference between custom hierarchy and report based hierarchy?
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)?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain the data types present in bo and what happens if we implement view in the designer and report?
What are the join problems comes appart from loop,chasm & fan Traps
What is thumbnail?
Give some information on report bursting?
Explain in detail about type 1?
In banking domain how many Fact tables,Dimension table are present?
What is a bo repository?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What is the difference between slice and dice and cross tab report?
When to use local filter and when to use global filter?
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
