• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 457
  • Last Modified:

Unrelated Dimensions


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 :\
  • 2
1 Solution
can you post your query?
xktoAuthor Commented:

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

Thank You

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
...and in your query you are using an unrelated dimension - as you described...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now