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 is meant by ZABO and FC(full-client)?

2 Answers  

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

2 Answers   Accenture, Rolta, TCS,

Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?

7 Answers   Accenture, Wipro,

Explain about derived tables?

2 Answers   Cap Gemini,

Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

0 Answers  

Can we create universe with no cache??

1 Answers  

please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.

1 Answers   Exilant, Wipro,

What is the use of Surrogate key in BO?

8 Answers   IBM,

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

0 Answers  

I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?

3 Answers   Wipro,

What is detailed Object

1 Answers   IBM,

why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.

7 Answers   Satyam,