previous and calendar yr data in same report

[Former Member]

Hi all,

We have Revenue and profits for previous year, Quarterly of calendar yr, Monthly of each quarter of calendar yr in BEX query.
Calendar year is the variable in Bex query. Previous year is calculated in BEx with exit variable (Calendar yr with offset 1).
We have the Char structure with above chars in Bex query and using some formulas also. Bex query will display KFs data for each above chars.

We know Char structure in BEx will show with only one object in WEBI. it is fine...

We already have the Calendar year, Quarter, Cal Month objects except previous yr object. so instead of using that char structure object, I want to create WEBI report by using all individual objects.

My question is how we can get previous yr? and previous year data? and is it possible to display previous year and Calendar yr,Q,monthly in single report ?how?

Could any one please help me,

[former_member226862]

Prem PV - to answer your original question "My question is how we can get previous yr? and previous year data? and is it possible to display previous year and calander yr,Q,monthly in single report ?how?".

Yes, you can display all those values in single report ether via BEx structure or by defining RKF for current calendar year, previous calendar year, quarter data, monthly data. My recommendation to you is to firts develop and test BEx query that provides data you are looking for, then develop WEBI report that uses BEx query you just developed.

[UmaArjunan]

Hi Former Member,

I too have the same kind of requirement . Based on the input date or year , i should display price datal for the current year and the previous year in the same bex report.

Did you come up with any solution ? Please let us know.

Thanks,

ABAP - BI dev

[Former Member]

Hi Prem PV,

I hope I understood correctly and the following will be useful.

Yes, you just have to create a variable like year(currentDate()) named _CurrentYear and year(currentDate())-1 named _PreviousYear, If it's base on current year or max([CalendarYear]) named _MaxYear and [_MaxYear]-1 named _MinYear if periode choice is given.

then in the report have =[Revenue] where ([CalendarYear]=[_PreviousYear] in report) (or [_MaxYear]).

Do the same for previous year, and profits.

Hope it helped you

[Former Member]

Hi, Thank you for your reply.

it is based on 'calander year' prompt (BEx variable), not the current date/year. So if we enter calander year in prompt (for example: 2011) it will display only 2011 data. So if we create the variable to get previous year(2010) at report level then how it will give 2010 data with that variable? as we have only 2011 data in report..

As mentioned above we can get data (ex: 2010 and 2011) in BEx as we are calculating 'Previous yr' in BEx query designer level, but this is one of the object using in characteristic structure. It is big structure so I don't want to use that 'structure' object in WEBI as it will display list of objects using in that structure.

[Former Member]

Can any one help here please. How to get the previous year (Ex: 2010) data based on calander year (Ex 2011) entered in prompt.

[Former Member]

Hi Prem ,

if you have Year Object in Ubiverse , pls create prompt in universe level like below.

Year  Between @YearPrompt-1 and @YearPrompt .

Its brings both year into report .

then in report level Previous Year = Min (Year).

Hopes it will helps you.

[Former Member]

can any one please help here. How we can achieve previous year(Ex: 2010) based on calander year (Ex: 2011). And if we manage that value (2010) with variable at report lavel then how we can get the 2010 data? It is possible only if we have that Previos year object in BEx query level????

We are using BI 4.0 and creating the report with BICS.

Appreciate your quick help....