I'm trying to build some requested relative date logic in a SSAS 2005 cube. I can build the named sets, and they work fine. When I drag them out as a column in my tool (Cognos, if it's relevant) it lists the actual members of the named set.
I would like to give those members some sort of artificial parent, so that when I add it, I get the parent. If I drill into it, I get the actual members.
Hopefully this makes sense. I'm very new to SSAS, so I may be messing up my terminology.
View Complete Post