BookmarkSubscribeRSS Feed
wrifster
Calcite | Level 5

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

5 REPLIES 5
nar_sas
SAS Employee

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. 

wrifster
Calcite | Level 5

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

nar_sas
SAS Employee

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. 

jplarios
Quartz | Level 8

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.

jplarios
Quartz | Level 8

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 3975 views
  • 2 likes
  • 3 in conversation