Offset calculation on 0FISCPER

[Former Member]

Dear all,

I manually have to calculate the offset of the infoobject 0FISCPER, like it is done in the regular query defintion.

I already retrieved the value from my infoobject and the corresponding offset, but now I'm looking for a smart way to calculate the result of

0FISCPER - offset.

Example:

0FISCPER = 2004004

OFFSET = -12

Result = 2003004 (and not 2003992)

Is there a function module which can do this, or do I have to code it manually?

Thanks,

Andi

[yi]

It is not easy to google, but after some time looking in the system I have found class CL_RS_TIME_SERVICE, which is not bad at all.

CL_RS_TIME_SERVICE=>SHIFT_FISCPER

Pls assign points if still relevant.

[tom_francis2]

Did you try using standard functionality?

When you define a VARIABLE or use a standard variable (eg. current fiscal period), you can right click on this and use the option: specify offset. If you type in -12 you have the new fiscal period.

It might take you some typing work, but I'm sure it will solve your problem.

kr,

Tom

[Former Member]

I want to use my scenario in a "home-made-RSDICHAPRO-environment", where we want to use logical partitioning on the cubes.

I want to determine from a variable (could be either an entry field in the selection popup or an automatically determined variable in the restricted key-figure definition (with or without offset)) which cubes I have to access, in order to retrieve all data which was selected.

I check this variable again a defined table (but more complex like the standard RSDICHAPRO)to fill automatically my 0INFOPROV info-object.

So I need to check whether an offset was used (and to which 0FISCPER is this offset referring to) in order to fill my 0INFOPROV correctly....

Andreas