Need Suggestion on Dynamic Cubes

[richiearora]

Guys Looking for a Suggestion:

This is first time i want to Leverage building an Ad Hoc Solution for a Client and have Decided will use Dynamic Cubes .

Here is My Question:  We have 2 Facts and 10 Dimensions ( Large Dimensions).

Each fact is Start schema in itself with 10 Dimensions . Just as an Information 8/10 Dimensions are Shared Dimensions between Facts . 2 Dimensions doesnt imply to both facts.

So How should i approach this?

1) Do 2 Separate Dynamic Cubes for each fact ?
2) Not sure is this a Possibility, But can i do 1 Cube and Virtually bring in 2 Cubes with respective Facts and Dimensions?
3) Another questions i have is, I have a fact which is a Join between 2 facts - Like Line and Detail Fact and then combinations Keys Joins to other 9 Dimensions. How do i go about doing this? is this to be handled in Framework Manager and make a Star Grouping Schema and use this package to build a dynamic cube?
4) Is there a Limitation on Dynamic cube to use 2/3 Facts in each Dynamic cube model?

Thanks,
Richie

[br54016]

One fact per cube, then build virtual cube.  This process is documented in the Dynamic Cube documentation.
Note: Distinct count measures are not available in virtual cubes.

[cognostechie]

So how do you make a cube (virtual or physical) which will have Sales$, Sales Qty and Customer Count?

[bus_pass_man]

Create a VC using two of the dynamic cubes and then create another VC using the third of the dynamic cubes and the first VC.

[cognostechie]

Create a VC using two of the dynamic cubes and then create another VC using the third of the dynamic cubes and the first VC.

Yes, I understood that but br54016 said that distinct count measures are not possible in virtual cubes.