Hello!!
I'm hoping for some more help!!

I have two fact tables in one as2005 cube. Fact table A is a summarized and
filtered version of Fact Table B. Fact table A has charges, Fact table B has
all the transactions that "go against" the charges like payments,transfers,
etc. My dimensions are conformed, meaning the two fact tables share most of
the same dimensions. My fact tables only have a few fields that are in
common with one another like (case_id, invoice_number). I want to drill
across one fact table to another, how could I do that in the cube?
Thank you!!!!!!!

Hmmm... You might look at how Adventure Works DW models this. Depending on
how you need to do analysis, this might be modeled as a two measure groups,
or a combination of fact dimensionsions and a measure group.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"malka" <malka (AT) discussions (DOT) microsoft.com> wrote

Thank you very much for the reply.
Well, I created two Fact-dimensions, and still I am lost. I'm also foggy on
the measure group functionality. This is really confusing. I'll try to get
the Adventure Works DW to see how it is done there. I hope I can find the
Adventure Works DW on the microsoft site somewhere.
BTW, I have seen several of your web cast events and I must say you are one
of my favorites!! So, it's an honor to have you reply to my post! Thank you
so much.
Please revisit this post, because I'm bound to encounter more issues trying
to understand how to do this (this is a CRITICAL FEATURE FOR my clients) and
will post further questions in this thread.
If you com across any webcast events or documentation that provides
directions on how to accomplish this, please, please, please send it my way.
Deepest Thanks

"Dave Wickert [MSFT]" wrote:

Okay, now I'm really lost!! I loaded the adventure works DW. I'm looking at
the Dimension Usage and Actions and I don't see where they are drill across
from one fact table measurement to another. I see they have created
Fact_Dimensions for attributes that are not additive that reside in the fact
table, but this is not what I want.
I want to be able to bring up charges (that is in Fact_A) and drill across
to all the transactions that hit that charge (that is in Fact_B).
PLEASE, PLEASE HELP!!!!!!!!!!

"malka" wrote:

Okay folks, I FIGUERED OUT HOW TO DO THIS!!!!!!! YIPEE!!!!!!!!

SO, if any of you want to know, just leave a post!!!!!!!!!!!!!!

"malka" wrote:

Well, i wanna know how you did it, an action?...


Pablo Mugica



"malka" <malka (AT) discussions (DOT) microsoft.com> wrote