filtered time hierarchy in tree prompt

[antih]

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.

Code Select Expand

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.

Code Select Expand

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.

[antih]

Any ideas on this topic :(?

[CognosPaul]

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)