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
Explain is there any default username & pwd for bo designer & supervisor?
What is report template in b.o?
How to schedule the report in b.o?
What is the dense rank?
what is xcelsius architecture?
what are the day to day activities of BO administrator ?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What are all difference between business objects 6.5 and xi r2?
What is difference between custom hierarchy and report based hierarchy?
Which versions are used in the bo dashboard work?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What is top business?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Difference between zabo and webi?