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
- 12199 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
What is Indexing? how did u implement indexing?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
What would you consider as your biggest achievement and why?
Explain how we drill up week to month?
8. How much supervision have you typically received in your previous job?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
What is the difference between slice and dice and cross tab report?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
how to create metric universe ?
U r project in which stage in implementation?
what is document design in boxi,have u participate in that
Explain what are the steps to be taken to schedule the report?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
