Skip to Content
avatar image
Former Member

MDX Function - Last Year Current - Time Dim - Daily

Hi colleagues,

I wrote the following MDX funtion in order to get the Last Year based on the current period

*function PY(%KPI1%) 
(PARALLELPERIOD([AIC_TIEMPO_SEM].LEVEL00,1,AIC_TIEMPO_SEM].CURRENTMEMBER),%KPI1%) 
*endfunction

Example:

PY([AIC_T_VERSION].[ACTUAL]);SOLVE_ORDER=10

Member formula

Notes:

AIC_TIEMPO_SEM - Time dimension - DAY granularity

AIC_T_VERSION - Category dimension

Issue:

It works perfectly with non-leap years. Any workaround to solve this mdx when leap year would be helpfull

Version:

SAP BPC 10.0 NW

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 01, 2017 at 06:04 PM

    To my mind parallelperiod will not work on day level with leap years. Number of days is different...

    Add comment
    10|10000 characters needed characters exceeded