Solved

Creating a group from a dimension

Posted on 2009-04-10
7
403 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
[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
  • Learn & ask questions
  • 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Suggested Solutions

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

739 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