August 2, 2013 at 10:06 am
Hi, I wonder if you can help
I have created a Dynamic Named Set on the cube's Time dimension that returns the last six months
Create Dynamic Set CurrentCube.[Last 6 Months]
As {Tail([Time].[Fiscal Time].[Month].members,6)},
Display_Folder = 'Named Sets';
This works well unless I want to move the members returned down the timeline
For example creating a view in the BIDS browser with Month (from my Time dimension hierarchy) on the rows and the set as a Filter Expression works fine as the measure selected is returned for each of the previous six months from the default member on the Time dimension
If I try to move the 'six months view' back one month the query fails
I've tried adding a second time attribute using just Months, but without success
Any ideas would be gratefully received
Thanks
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply