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 )

Answer Posted / apurba

Thanks Anil, for your response. But I need to calculate
measures on the basis of dimensions which can't be done in
report level.

As per my requirement data needs to be calculated for two
different years.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how we drill up week to month?

639


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1537


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

602


Explain in detail about type 2(scd),

596


What we need to discuss with designer before starting the universe designing.

1822






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...

1725


Explain how to schedule the report in b.o?

566


Explain what is aggregate table and aggregate fact table ... Any examples of both?

609


What is Indexing? how did u implement indexing?

1820


U r project in which stage in implementation?

1950


Explain about alerts in bos, under what situation we need to use alerts?

558


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

1972


what is universe null

1991


Explain difference between zabo and webi?

654


What is the difference between condition & filter?

607