SQL Server Analysis Services
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
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