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


Please Help Members By Posting Answers For Below Questions

Explain is there any default username & pwd for bo designer & supervisor?

596


What is report template in b.o?

588


How to schedule the report in b.o?

564


What is the dense rank?

677


what is xcelsius architecture?

3743






what are the day to day activities of BO administrator ?

1980


Explain what sort of existing documents should business analysts refer to when starting on a new project?

605


What are all difference between business objects 6.5 and xi r2?

602


What is difference between custom hierarchy and report based hierarchy?

550


Which versions are used in the bo dashboard work?

603


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2607


What is top business?

567


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

3847


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1691


Difference between zabo and webi?

638