Author Topic: Need Suggestion on Dynamic Cubes  (Read 239 times)

Offline richiearora

  • Senior Member
  • ****
  • Join Date: Jun 2010
  • Posts: 70
  • Forum Citizenship: +0/-1
Need Suggestion on Dynamic Cubes
« on: 18 Dec 2017 09:24:50 am »
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?


Offline br54016

  • Full Member
  • ***
  • Join Date: Jul 2014
  • Posts: 11
  • Forum Citizenship: +0/-0
Re: Need Suggestion on Dynamic Cubes
« Reply #1 on: 04 Jan 2018 04:20:13 pm »
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.