If you are unable to create a new account, please email support@bspsoftware.com

 

can we different cubes for different context in single model

Started by yogeswari, 06 Nov 2017 09:19:23 AM

Previous topic - Next topic

yogeswari

Hi,

I need to POC (create dashboard) on Dynamic Cubes.  I am very new to this topic.  I had not worked in cubes so far.  This is first time.
I had explored the basics and started doing.  While doing I had doubts like:  I am using GOSALESDW package.

1)There are many dimensions and fact tables in the package.  There are many context.  For example
a)Employee Position Fact,
b)Employee Expense Fact,
c)Employee Recuritment Fact

Now I had created for  4 dimensions eg(Employee, Employee Position, Employee Expense, Employee Recuritment)
Now I need to join these 4 dimensions to 1 fact.

Eg: Suppose
For these, Employee_Key, Employee_Position_Key, Employee_Expense_Key are taken from Employee Position Fact
and
Employee_Recruitment_Key taken from Employee Recuritment Fact

Then is these 2 facts come into and is it correct way of doing?  I don't have much experience in modeling too.

2nd question is:
can we create more than one cube for each context in 1 model?
eg: one cube (Employee, Employee Position, Employee Expense) -->provided using same fact table
      second cube (Employee Recuritment, Employee Ranking, Employee termination) -->provided using same fact table

Is it right approach? If so, how to combine all the cubes in a single dashboard?

Please provide your suggestions and best way to do cubes in cube designer.


Thanks in advance.


bus_pass_man

Each cube is based on one fact table.   You can create cubes which use multi-facts via virtual cubes.

"If you want to allow the package users to query against multiple cubes, use virtual cubes.

"With virtual cubes, you can build a cube that shares dimensions between cubes and build
reports that use facts from multiple cubes. An example is to have a virtual cube that includes
a cube with actual values and a cube with target or budget values."

Down load the redbook (it's free!!) and have fun.

http://www.redbooks.ibm.com/redbooks/pdfs/sg248064.pdf