Time variables BEx

[Former Member]

Hi experts

I'm usinig some FI standard data models (AP, Controlling, etc).

The cubes have the following time characteristics:

Fiscal Year (0FISCYEAR)

Fiscal Year variante (0FISCVARNT)

Posting Period (0FISCPER3)

Fiscal Year / Period (0FISCPER)

1)

I have requirement to report actual Cost Center values per month. The requirement is to create 12 columns for monthly actuals, and a column for YTD actuals and year actuals.

But selection must be made by selecting perios/year interval rather then just selecting year. Do in this scenario i can have a selection that comprises months in 2 years.

So i need to create a variable for period / fiscal year that only allows the insertion of a interval of 12 periods. In order to have the following

If user selects in SC 004.2011 to 003.2012 its ok. if user selects in SC 004.2011 to 004.2012 we have an error.

Q1: Is it possible to create a variable like this using exit? Has anyone ever had a similar requirement?

Still in this example, for YTD and year values, i need to create a variable that considers the year of the superior limit of the interval

example:

Current month is 2012. we execute the report using SC 003.2011 to 002.2012.

If i look at YTD actuals I get cumulated months from 001.2012 up to 002.2012, and I get year values for year 2012

Current month is 2012. we execute the report using SC 001.2011 to 012.2011.

If i look at YTD actuals I get cumulated months from 001.2011 up to 002.2011, and I get year values for year 2012

Q2: Is it possible to create a variable like this using exit? Has anyone ever done something similar?

2)

The other requirement i have is to build something similar to what i described above, but instead of having monthly actuals i would have quarter actuals

I don't have quarter time characteristic in the cube, so I'm a bit lost.

Will i be able to create quarter variable for 0FISCPER? And if so, how would i execute my report? I assum i wouldn't be able to select quarters, but periods, and then quarters would be determined by some kind of exit.

Can anyone help?

Many thanks

Joana

[anshu_lilhori]

Hi,  Please check out the below blog it will give you insight on your requirement.  http://scn.sap.com/people/durgesh.gandewar/blog/2012/02/14/financial-reporting-in-bi-over-various-ti...  Hope this helps.  Regards, AL

[Former Member]

Hi AL

I've read the link you mentioned, but it doens't quite answer my questions.

It mentioned the YTD variables, but it seems that we need to define if we want to display the previous year YTD or the current one..

My requirement is to restrict YTD KF by the considering the last period of my selection criteria interval. it can be current year or last year or any year that is part of selection criterial (upper limit of the interval).. I wanted to know if its possible to defined such variable in a exit (i don't understand much about ABAP, thats why i have so many questions)

Also, i didn't find anything that clarified my 2 other questions:

1) is it possible to create a variable that doens't allow the users to create a selection interval greater then 12 months? So basically to create a exit variable that makes this restriction.

2) how can report on quarters based on 0FISCPER? If i was able to do a variable that "creates" the quarters, would i be able to use quarter as selection criteria?