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
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.
So how do you make a cube (virtual or physical) which will have Sales$, Sales Qty and Customer Count?
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.
Quote from: bus_pass_man on 20 Aug 2018 03:53:12 PM
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.