Solved

Creating a group from a dimension

Posted on 2009-04-10
7
391 Views
Last Modified: 2016-02-13
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
Comment
Question by:TechMonster
  • 2
7 Comments
 
LVL 8

Expert Comment

by:srnar
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

by:TechMonster
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

by:
srnar earned 500 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question