I have created a named set that is made up of multiple other sets. These represent dates: (Current Day, Prior Day, Prior Month and Prior Year). I would like for each set member to have the names above instead of the member names associated
with the actual members. So, instead of member captions of '2/2/2010', '2/1/2010', etc, I'd like the set to return the captions as 'Curr Day", "Prior Day", "Prior Month", "Prior year").
I know that normally, you can't rename members, but I am hoping I can rename the captions on the individual sets that make up my 'rollup set'. Here's how the sets look:
dynamic set [Today] as
filter([Process Date].[Process Dates].[Process Date],
[Process Date].[Process Dates].properties("Is Current Date")="Y"),caption='Curr Day'
dynamic set [Yesterday] as
dynamic set [Prior ME] as
dynamic set [Prior YE] as
dynamic set [Period Comparison Dates] as
[Prior YE] +
[Prior ME] +
[Current Process Date]
This works great but the member names are the actual dates, not the "Period comparison" labels I'd like to have. As you can see, I
View Complete Post