Answer / manisha

Create 2 objetcs at Univ Level ,
Current fiscal year =
to_char( sysdate,'YYYY')
Previous Fiscal Year =
to_number(to_char( sysdate,'YYYY'))-1

Now in the DP for the current fiscal yr, pull Current
fiscal year , measures will be automatically be computed as
per the current fiscal yr.

Answer / gowthami

Create two objects in universe YEAR and YEAR-1
DP1:
Select panel: Other objects + Year +Year-1
Filter Panel: Year=prompt

DP2:
Select panel: Other objects + Year
Filter Panel: DP2.Year=(Use 'select object from another query') DP1.Year-1

Explanation:
DP1:
Assume that year=2014
Filter Panel: Year=(prompt) 2014
Select panel: Other objects + 2014(Year) +2013 (Year-1)


DP2:
Filter Panel: (DP2.Year) 2013 = 2013 (DP1.Year-1)
Select panel: Other objects + (Year) 2013

Since we take the year-1 from data provider 1 the DP2 will always give you the previous year data.

Thanks
Gowthami

Answer / bibin

edit sql in dataprovider ,

Date >= add_months(date),-12

and then check "do not generate sql before running" option.

regds

bibin

Answer / swati

In case, your requirement doesn't allow you to create the
new objects at Designer level or use hard coded SQLs, then
you can try to create a prompt in the second dataprovider
named as 'Prev. Year'. When refreshing the report you can
pass the values for current and prev yrs both.

If you do not have a predefined filter for prev yr then you
can use your objects to create the similar conditions as
there are in the filter.

Answer / 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?

Answer / apurba

Thanks Anil, for your response. But I need to calculate
measures on the basis of dimensions which can't be done in
report level.

As per my requirement data needs to be calculated for two
different years.

What are the Input and Output Context Operators.

4 Answers   Bosch, iNautix,

What is the link option in the reporting Environment?

3 Answers  

how we improve the performance of report and universe?

4 Answers   Accenture, IBM,

. In production reports, some dimensions are missing. how do you load these dimensions in production

2 Answers   TCS,

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 )

6 Answers   Exilant, Siebel,

explain merge dimensions with real time in DWH?

1 Answers   IBM,

What is the difference between Sychronisatio and join?

2 Answers   Mind Tree,

How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?

1 Answers   WinAlliance,

what is drill down?

5 Answers   TCS,

if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..

1 Answers   TCS,

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

0 Answers   HCL,

How to change the order of prompts in universe?

3 Answers