I am in need of assistance from anyone who may have sucessfully deployed a Dynamic Cube with calculated members, specifically for the time dimension.
I created the expression (seen below) to create a Rolling 12 Month time period for my reports. Unfortunately I do not see the result values within Cube Designer once I refresh the members ( unsure if that is expected)
Also, after publishing the cube, I do not see the calculated member within the package under it's specified parent member...so i am a little confused as to whether or not I have constructed the expression correctly, and also how it is supposed to appear in Report Studio???
Below is the expression i am using:
lastPeriods( 12, item ( filter(
descendants( filter ( members( Year ),
roleValue('_businessKey',
currentMember( Close Date ))
= roleValue('_businessKey', 2013)
) , Month )
, roleValue('_businessKey', currentMember( Close Date ))
= roleValue('_businessKey', November )
) ,0) )
Any help will be greatly appreciated!
Hey Did you get the solution ?
I am also not able to see calculated member in cube.