September 3, 2009 at 7:38 am
Hello,
I've a classical time dimension.
And I like to aggregate month
Currently when I put:
in Criteria : Year 2007 and 2008
in Column : Month
in Detail : Price
I have:
Month Price
January 10,00
February 20,00
...
November 110,00
December 120,00
January 130,00
February 140,00
...
November 230,00
December 240,00
What I want is:
Month Price
January 140,00
February 160,00
...
November 240,00
December 260,00
Thank you for your help
September 3, 2009 at 8:06 am
The key that you are using for your month dimension represents both the month and the year even though the name column you are using shows only the month. You need to use a dimension that only encodes the month. When I set up my staging data, I sometimes have both coded (and I like to generate my keys for date data). For example, I might have
Date,Year,YMKey,YMName,MonthKey,MonthName
"1/1/2009", 2009, 200901,"01/2009",1,"January"
Following this example, your dimension is using the YMKey (200901) when it should be using just the MonthKey (1).
I hope that helps.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
September 16, 2009 at 6:05 pm
Hi,
I guess you want to display a price per month.
Try this one. Open you SSAS solution, click your cube, and click your Price measure, and view the properties page. Change the value of AggregateFunction to FirstChild or LastChild.
If you have more than one price for each product in each month, you better use LastChild because it will display Price on the last day of each month
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply