[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 424
  • Last Modified:

Creating a group from a dimension

using SQL 2005 Analyst Services to build cubes...

my issue involves creating a group category.  
I have a dimension which list different States,,Co, AZ, ect.
I also have categories listed in the table as,,West, East, North,,,Happy state, Sad State,
ect....States can have more than one category or group...

How do I create a group in my dimsension or setup my dimsension in order that it will allow me
to display the sites in different categories at the same time.  

thanks
0
TechMonster
Asked:
TechMonster
  • 2
1 Solution
 
srnarCommented:
You can put both dimensios - states and categories - in one query and of course - you can see their crossjoin.

Honestly, what exactly do you want to achieve? If you put both states and categories into one dimension (e.g as 2 levels in a hierarchy) you have to be sure that there is exactly 1:N relationship.
0
 
TechMonsterAuthor Commented:
My dimension is made from a named query which combines the states and categories into that one table.   I am not sure I understand the crossjoin part.  
The goal is to be able to select the states by category but there seems to be some sort of error in the way i am doing it...

Thanks.
0
 
srnarCommented:
I would say the there is M:N relation between categories (there are facts in category C1, in states S1 and S2 and opposite for state S1 are facts in C1 and also in C2 category). If so you cannot solve it with one dimension as stated above.

You can have two dimensions - when you put more dimensions on one axis in a query you do so called crossjoin. You can see whole data correctly.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now