SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Multiple Fact tables in a cube?

Reply
New Contributor
Posts: 2

Multiple Fact tables in a cube?

All the documentation I read seems to indicate that a cube can be built from only a single fact table.

How are people dealing with scenarios that need to cross multiple fact tables?  e.g. If my actuals are in one fact table and my forecasts are in another fact table.  If I build two cubes, how can I report across the two cubes?

It seems like an Information Map can only include a single cube, is this correct?

Arif

SAS Employee
Posts: 38

Multiple Fact tables in a cube?

Here is an answer from development: 

Correct, an information map can currently only wrap a single OLAP cube.  As for the multiple fact tables, a user would have to create a single fact table with the summarization of actual and forecast in one table.  They can achieve that result using the data step.  Then they can build the cube they want, and then use that in the map. 

New Contributor
Posts: 2

Multiple Fact tables in a cube?

I wish the world was such a simple place where you could create a single fact table with everything in one table.  Usually this is not desirable because of different granularities between the fact tables. As well it is quite common that the fact tables share some dimensions but not all - in this case how can you combine everything into one fact table.

I hope someone in SAS is aware of how limiting and restrictive this is for real use cases.

Arif

SAS Employee
Posts: 38

Multiple Fact tables in a cube?

Thanks for the response.  Having use cases and details about them really helps us in scoping for future development.  We have captured your comments in our requirements management system, and we will investigate extending this feature set for the future. 

Regular Contributor
Posts: 163

Re: Multiple Fact tables in a cube?

nar, thanks for having look into this. at least in my opinion, I think that drill-across and drill-down mechanisms are essential technologies for any BI; at least for  80% of reporting needs.

Regular Contributor
Posts: 163

Multiple Fact tables in a cube?

wrifster,

we are in the same boat. 'Drill-across' is a piece that's still missing in SAS BI, you have to work around it and when talking about an OLAP cube, a detail table, or flat file, where you have both facts would be the only way. However, it is true that this causes issues because of the 'mixed' granularities.

Ask a Question
Discussion stats
  • 5 replies
  • 2143 views
  • 2 likes
  • 3 in conversation