Calculated Members for Time Dimension within Dynamic Cubes???

[torre2011]

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:

Code Select Expand

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!

[abhishek dharga]

Hey Did you get the solution ?
I am also not able to see calculated member in cube.