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:
MonthPrice
January10,00
February20,00
...
November110,00
December120,00
January130,00
February140,00
...
November230,00
December240,00
What I want is:
MonthPrice
January140,00
February160,00
...
November240,00
December260,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