Solved

Creating a group from a dimension

Posted on 2009-04-10
7
367 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

744 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now