Solved

Unrelated Dimensions

Posted on 2008-06-26
6
409 Views
Last Modified: 2016-02-13
Hello,

I have the following scenario in MS SSAS 2005:

- One Measure Group called transitions;
- One Measure Group called actions;

The transitions have actions associated. They share all the dimensions except:
- Transition has the workflow dimension associated;
- Action has the action detail dimension associated.

I tried the many-to-many relation between the two measure groups, but the result was always the total number of actions. It didn't filtered the number of actions by the respective transitions.

My objective is to filter the number of actions by the transition, given a workflow restrition (the workflow dimension is only associated to the transition measure group).

I really need some help :\
0
Comment
Question by:xkto
  • 2
6 Comments
 
LVL 15

Expert Comment

by:dosth
ID: 21873801
can you post your query?
0
 

Author Comment

by:xkto
ID: 21874771
Hello

It's not a query, I want to model this in the dimension usage (MS Analysis Services 2005).

Thank You

0
 
LVL 8

Accepted Solution

by:
srnar earned 500 total points
ID: 21882511
xkto: dosth think the query with repeating values - if you see repeating values you have some data based on query - either you see the query or you can catch it via profiler.

Otherwise the m2m is realy working - we are using it the same way like in adventure works. See pic
many2many.jpg
0
 
LVL 8

Expert Comment

by:srnar
ID: 21882528
...and in your query you are using an unrelated dimension - as you described...
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
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…
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 SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

863 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

20 Experts available now in Live!

Get 1:1 Help Now