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 / anil

Instead using two dataproviders for present and previous
year, why don't you use a formula previous(year dimension)
and calculate in report with single data provider?

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1527


Explain what are the measure objects?

641


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1746


8. How much supervision have you typically received in your previous job?

1926


How were the reports scheduled and how to resolve unexecuted documents?

2324






Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

699


What Is The Difference Between Oltp And Olap?

752


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

786


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

647


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

679


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2489


What are the steps to do to use alerts in bo?

705


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4611


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3936


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

703