Hi,

I'm having trouble with a specific MDX query, I have to join Measures
from two different fact tables (On two different cubes) that don't
share the same dimensions (Although they do have common dimensions)
I've tried using calculated members to collect the data but it seems
that when I slice and construct the axes the calculated members
calculate on the current query structure.

Is there a way to combine two different data sets like in SQL UNION or
have two Select statements in one MDX Query? Sorry, i'm very new to MDX
if this is a dumb question...

Thanks,

Ryno Smit

Ok,

Perhaps what I'm trying to do is very unclear, so here is a better
description of what exactly I want to do with my data..

I have a fact cell called [Candidate Votes]

Then I have dimensions containing Wards, Parties and Candidates

What i want to do is get the topcount of 2 candidates per ward and then
I need to calculate a total of votes per ward so I can calculate the
percentage that winning candidate got...

The data should resemble something like

Ward Candidate Party Votes per Candidate
Votes Per Ward
0001 J. Doe Sparty 2345
8195

Could you clarify whether there is a single cube (presumably with the
measure: [Candidate Votes]), or there are 2 different cubes, as implied
by the thread title?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

There is a single virtual cube comprised of four different cubes, each
with more or less the same dimensions.

What's needs to happen is the following...

I have to:
a. Filter on a dimension called Electoral Event (Using where clause)
b. Capture the topcount of 2 highest voted candidates (Per Ward), from
three different dimension members and combine them into a tuple
c. Calculate the sum of votes per ward for all candidates

I have managed to do a & b but because b sits on the Row axis and
obviously [Candidate Votes] on columns, I'm unable to create a
calculated member in MDX to get me the total votes per ward. The cube
cannot be altered.

Concerning joining data from different cubes I have managed, but now I
have this problem above. Having two calculated members that work at
different level within the query & they cannot run in conjunction,
because my Sum calc member sum's the votes for the two topcount
candidates per ward, instead of all candidates...

Ok, thanks for your responses Deepak Puri, but I have resolved the
issue.

The problem was with the construction of the calculation member for
summing the total votes per candidate...