Hello,
i have a little problem with my current approch to show only the Hierarchy-Nodes of the standard Time hierarchy of transformer which have data for a defined measure.
filter([Daimler_Sales_Absatzstufen].[Time].[Time].[Year],
tuple([Deliveries],currentMember([Daimler_Sales_Absatzstufen].[Time].[Time])) is not null)
The problem lays in the current year. I have data until April 2012. Therefore the Treeprompt should only show the Hierarchy until this month.
Time
2010
Q1
2012/Jan
2012/Feb
...
Q2
...
2012
Q1
2012/Jan
2012/Feb
2012/Mar
Q2
2012/Apr
If I rearrange the expression on the Month level, I get the Members until 2012/April.
filter([Daimler_Sales_Absatzstufen].[Time].[Time].[Month],
tuple([Deliveries],currentMember([Daimler_Sales_Absatzstufen].[Time].[Time])) is not null)
The problem is that i want them to be shown as an Tree prompt with atleast the Year and Quarter level above (like in the example above).
It would be great, if someone could give me hint on that problem ;).
Thanks.
Any ideas on this topic :(?
Is this still relevant? I recently had a similar request. The easiest way to handle this is by doing a detail filter (wow I feel dirty just saying that) with [Deliveries] is not null. Then every request to the database will include that filter in the edge. So the first run will be filter([Year Level], [Deliveries] is not null) then on every subsequent request (like expanding 2012) will be something like filter(children([2012]),[Deliveries] is not null)