I am trying to make a calculation in PAW dynamic, so it always calculates the previous - current month value.
I thought that by updating the cube MDX in the "With Member" part of the code, it would make the periods dynamic.
I basically created a cube view, with previous and current period in the columns and created a calculation for prev period - current period.
However, when I change the mdx to make the period dynamic, the mdx complies ok but the calculation just disappears. Is it not possible to do this?
For illustration, he "With Member" part of the mdx before the change was as follows:
Code: Select all
WITH MEMBER [Period].[Period].[Prev - Curr Period] AS [Period].[Period].[P09]-[Period].[Period].[P10], SOLVE_ORDER = 1, FORMAT_STRING = '#,##0;(#,##0)' SELECT NON EMPTY
Code: Select all
WITH MEMBER [Period].[Period].[Prev - Curr Period] AS STRTOMEMBER("[Period].[Period]." + STRTOMEMBER( "[Period].[" + [System Variables].([System Variables Lines].[Latest Actual Period],[Data Type].[String]) + "]").PROPERTIES("Previous Period"))-STRTOMEMBER( "[Period].[" + [System Variables].([System Variables Lines].[Latest Actual Period],[Data Type].[String]) + "]"), SOLVE_ORDER = 1, FORMAT_STRING = '#,##0;(#,##0)' SELECT NON EMPTY
are there limitations I should be aware of and can anyone reference what they are please.
Maren