Cascading Date for Filter

Hi,

I have a Date Dimension with these attributes:

Datekey

FullDate (eg. 1/1/2007, 1/1/2008)

Year,

Month (eg. Feb 2006, March 2006, April 2006)

If i put the Year on the filter and select 2005, I want the Month filter to show only months with 2005 as the year.

Is it possible?

cherriesh

Hi,

It somewhat depends what tool you are using to query your cube, which tool/s are you using?

Matt

|||my cube is connected to ms excel 2007|||

Hi,

I don't think it can do what you are asking, an alternative is to create another attribute which just has the month in it, so no matter what year it is the month can be shown.

I have seen this kind of thing implemented successfully, Panorama has been able to do this for years. ProClarity, I've seen it work, but when we got a later release it stop working. And a few custom made applicantions.

HTH

Matt

|||

Hi,

I don't think it can do what you are asking, an alternative is to create another attribute which just has the month in it, so no matter what year it is the month can be shown.

So you mean in my Date Dimension, the month attribute there should only be like February, March etc instead of February 2007, March 2007 etc?

cherriesh

|||

Hi,

Yeah. e.g.

Year= 2006

Measure

Month

Jan 20

Feb 30

March 40

april 50

May 60

..

Year= 2007

Measure

Month

Jan 90

Feb 80

March 75

april 60

May 40

..

This way the month is independent of the year, if you don't slice by year you will get ALL year values for that month. So Jan will be 2005+2006+2007... values.

Year= ALL

Measure

Month

Jan 110

Feb 110

March 115

april 110

May 100

If you have a copy of the adventure works database, the "month of year" attribute is the one you want to create. They only really use Month+Year in the hierarchies and have year, month, day .. as a seperate attributes.

HTH

Matt