Skip to Content

How to select a period and see the previous period with AFO BPC 11.0. Analysis for office

Hello, I´m working with sap BPC 11 Embeded, I have built a query which I want to see some accounts per period.

I would like to see the accounts of a determined period and also, the accounts of the previous period.

What would be the correct way to build this query with analysis for microsft office (AFO)?

How could I build with AFO a query in which I can select a period and show me the accounts for that period and the previous period?

Thank you very much

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 15 at 01:30 PM

    Hi Francisco,

    the usual way to model this in queries is to use a variable, e.g. based on characteristic 0FISCPER, and to use an offset of -1; where to use it - whether in the filter or in restricted key figures - depends on your query design.

    Example (with restricted key figures):

    Account Value( $ACT_PER - 1) Value ($ACT_PER) 
    4711    ...                  ...
    4712    ...                  ...

    where $ACT_PER is a variable based on characteristic 0FISCPER

    Regards,

    Gregor

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Gregor, in my case I'm not using 0FISCPER, which is numeric and behaves as you say. The problem I have is that my time characteristic is a CHAR, and an offset with a characteristic of type CHAR does not work. For that reason I would like to know how to solve this problem in AFO. Regards.Francisco.
  • Apr 16 at 03:06 PM

    Hi Francisco,

    calculation with variables only works for BW time characteristics and characteristics of technical type NUMC. If you want to use your own characteristic a solution might be to use two variables, one of type exit where you pick the user input of the first variable and set the value you need into the second variable.

    Regards,

    Gregor

    Add comment
    10|10000 characters needed characters exceeded