March 25, 2007 at 4:55 pm
Hello, I have a problem with modelling some dimensions in SSAS 2005. I have a time dimension. In this I try to build the following hierarchy: Year --> Quarter --> Month --> DayThis is pretty easy and works. But then I tried to create relationsships between the attributes in Visual Studio. So I put the year attribute under the Quarter attribute, the quarter attribute under the month attribute and set the relationship to many. But when I (full) process the dimension again and check it in dimension browser the hierarchy is not correct shown. Less Quarters were shown for the year and the month didn't work in way it should, too. I have this problem with some more dimensions, but I wanted to break it down in an easy to tell scenario for the newsgroup. The server has SP2. The time dimension itself consists of one table with a column for each attribute.The problem is that it is said, that anything is much slower when no attribute relationships are defined and in the project real documentation they even say, that mdx time based calculations would not work properly without defined attribute relationsships. Did anybody else see this behaviour? What do I do wrong? Stefan
SK
April 2, 2007 at 9:06 am
We do not use the Attribure Relationships because we have 2 hierarchies in the Time dimension.
If we do the members are messed up nad the behavior is different from what we want.
April 2, 2007 at 9:47 am
Hi,
it works. You just have to use seperate Attributes for your hierarchy paths. Make sure that your keys are unique like this
year: 2007,2008 ...
month: 200701, 200702...200801 instead of 01, 02..12 .
week: 2007_W1, 2007_W2 ...
day: 20070101, 20070102 ...
Then you can define different user hierarchies and they are still ok:
year --> month --> day
year --> week --> day
There is a good article about dimension design on this website:
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/olapdbpssas2005.mspx
Best regards,
Stefan
SK
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply