April 1, 2014 at 3:18 pm
Hi - I am trying to create a hiearchy from a Dim Table linked to the SQL DB and I'm having difficulty. I am using Visual Studio 2008 and Analysis Services server 2005. My SQL Server DB is in 2005.
I have a simple dimension with County, State and Region. The hierarchy is pretty straight forward. County Code is the primary key and is the leaf level (lowest level of detail), and I want County to role up to State and then State to roll up to Region.
I am not a programmer of SSAS so I would like to do this through the UI. I have tried so many permutations of what I thought would be fairly straight forward, I am out of ideas. I've tried many different attribute relationships, created new hierarchies, tried custom rollup property, etc.
If someone can run me through the steps I tried or have new ideas, I would greatly appreciate it. Please provide as detail steps as possible.
Thanks,
Paul
April 2, 2014 at 6:42 am
I was able to solve the issue by creating a relationship between county and state, and county and region. I was able to go through trial and error until I got it to work. Had to create a new hiearchy with the relationships and it works well.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply