Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Creating a group from a dimension

Posted on 2009-04-10
Medium Priority
421 Views
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
Question by:TechMonster
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 8

Expert Comment

ID: 24123247
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

Author Comment

ID: 24129995
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

LVL 8

Accepted Solution

srnar earned 2000 total points
ID: 24136738
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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
###### Suggested Courses
Course of the Month6 days, 11 hours left to enroll