Named Set for Time Dimension

­­General Discussions
1

Can anyone suggest how I can create a named set for my time dimension (days) that automatically includes aa rolling 30 day period (i.e. today plus 30 days previous)?

2

Hello, Alan, i’m not sure if you know how MDX works for namedsets, but with your explanation i got this, what it does is taking today plus 30 days before:

Filter(
Descendants([Time].[Default].[ALL], , Leaves),
MID([Time].Default.currentmember.properties(“key”), 1, 4) = CStr(Year(now())) and
[Time].Default.currentmember.properties(“key”) >=
CStr(Year(DateAdd(“d”, -30, Now()))) + “D” + Right(“000” + CStr(DatePart(“y”, DateAdd(“d”, -30, Now()))), 3) and
[Time].Default.currentmember.properties(“key”) <=
CStr(Year(Now())) + “D” + Right(“000” + CStr(DatePart(“y”, Now())), 3)
)
image

image
image447×711 11.3 KB

Remember to change the [Time] to your Time name dimension.
Let me know if it works

2 Likes
3

Have you tried using Parallel_Period()?

1 Like
4

Hi Ali. Thank you for replying, but I don’t know what that means.

5

Hi Matheus. Thank you for your reply. When I enter that MDX into the expression editor, it fails (red box - can’t save). I’ve replaced [Time] with [Flash Time] which is my time dimension name. I did think it might be missing a closing parenthesis but that didn’t help.

6

Hello, Alan, it looks like the forums was changing the quotation marks, try this now, just change the [tempo] to your time dimension name.

Filter(
Descendants([tempo].[Default].[ALL], , Leaves),
MID([tempo].Default.currentmember.properties("key"), 1, 4) = CStr(Year(now())) and
[tempo].Default.currentmember.properties("key") >=
CStr(Year(DateAdd("d", -30, Now()))) + "D" + Right("000" + CStr(DatePart("y", DateAdd("d", -30, Now()))), 3) and
[tempo].Default.currentmember.properties("key") <=
CStr(Year(Now())) + "D" + Right("000" + CStr(DatePart("y", Now())), 3)
)
1 Like
7

Hi Matheus. Perfect! Thank you :slight_smile:

2 Likes