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 / bibin
edit sql in dataprovider ,
Date >= add_months(date),-12
and then check "do not generate sql before running" option.
regds
bibin
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the dense rank?
what are the day to day activities of BO administrator ?
Give some information on report bursting?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain 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)?
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
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
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
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?
What is the difference between absolute and relative div positioning?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Which versions are used in the bo dashboard work?
How were the reports scheduled and how to resolve unexecuted documents?
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)?
How to restrict password to a user while sending a document in .pdf format