Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Named sets on time dimension Expand / Collapse
Author
Message
Posted Friday, August 2, 2013 10:06 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 5, 2013 4:21 AM
Points: 74, Visits: 90
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



All the best,

Duncan

Post #1480493
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse