I have got the following MDX statement in icCube (based on the standard Sales model):
with
set [time-set] as hierarchize({[Time].[Calendar].[All Periods],[Time].[Calendar].[Year].members,[Time].[Calendar].[Year].[2009].children},post)
member [issue] as [amount], caption = "drill down on 2008"
select [issue] on 0
, [time-set] on 1
from sales
This gives the following result:
When clicked on 2008:
I assume the IDE is a bit mixed up since I have used the POST command. Is there a workaround to get it working as expected?
Short answer.
Sorry, the current version of iccube's pivot table is not supporting the post flag.