I am building my first cube and have come across a dilemma that I can't seem
to workout (it may not even be possible). Hopefully I can express what I am
trying to do.

I have two measures (fraud index and failure index). The values are either
1,2, or 3 and these two measure are in the same table. I have a dimension
table that basically has the index id - 1,2, or 3 - and the index desc -
high, med, low.

I have created a cube and an index dimension but when I add the dimension to
the cube, it splits it up into two different dimensions - fraud and failure -
probably because my one dimension table is referencing two different fact
fields? what i am ultimately trying to do is compare the fraud index
against the failure index. for example, i am dragging the fraud index onto
the data area and want to do the same with the failure index. the problem
is i have to use either the fraud or failure dimension to filter. how could
i create one dimension "index" that could be used for both? Or is it not
possible to drag two measures onto the data area to compare?

Hello Jason,

I understand that you'd like to use a single dimension such as index to
filter cube to display 2 measures failure and frand indexes at the same
time. If it is not correct, please let me know.

As for as I know, this is not feasible because a dimension key could only
be relatd to one field in the fact table. For example, you could reference
index dimension to failure index by using the following dimension table

3 high
2 medium
1 low

3/2/1 is for failure index

However, it is not possible to use this dimension to fraud index at the
same time unless the failure index is exact same or scaler to fraud index.

If you want to use the same dimension for the both indexes, you have to
create a new fact column based on these 2 indexes, for example:

fraud index; failure index; new index
1 1 1
1 2 2
1 3 3
2 1 4
2 2 5
2 3 6
3 1 7
3 2 8
3 3 9

You could define new index 1-3 as low, 4-6 as medimum, and 7-9 as high in
dimension.Then you could use this new index dimension to filter the both
index mesaure.

When you put a common index high as filter, you want to show both fraud
index and failure index are 3 (high)? If so, you may use nex index value 9
to get the result.

If my understanding is not correct or you have further questions, please
feel free to let's know. Thank you!
Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks for the response. I was able to resolve this by adding seperate fact
groups for fraud and failure. This allowed me to display both measures in
the cube at the same time

"Peter Yang [MSFT]" wrote:

Hello Jason,

Nice to hear you sovled the issue. I understand that you add another fact
table use it in a different measure group to work around the issue. This
shall be an option if using one fact have some limitation as I mentioned.
Your experience on this issue will certainly benefit the community. Thank
you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====