Skip to Content
author's profile photo Former Member
0
Former Member

Offset calculation on 0FISCPER

Posted on Feb 02, 2005 at 06:34 PM 174 Views

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Tom Francis
    Tom Francis
    Posted on Feb 02, 2005 at 09:28 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Feb 03, 2005 at 10:54 AM

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.