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

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

694


Explain the difference between union and group?

631


Did you face any problems while creating reports? Name? Solutions?

3260


In banking domain how many Fact tables,Dimension table are present?

8380


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)?

577






Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

552


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1583


Explain what are the steps to do to use alerts in bo?

615


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

602


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

4448


What is top business?

567


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3925


What is the difference between absolute and relative div positioning?

583


What is the difference between slice and dice and cross tab report?

606


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

558