Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 454
  • Last Modified:

Unrelated Dimensions

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
xkto
Asked:
xkto
  • 2
1 Solution
 
dosthCommented:
can you post your query?
0
 
xktoAuthor Commented:
Hello

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

Thank You

0
 
srnarCommented:
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
 
srnarCommented:
...and in your query you are using an unrelated dimension - as you described...
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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