Print Page - Will one DC support multipal Fact

Title: Will one DC support multipal Fact_Table?
Post by: Eag. E on 21 Nov 2019 10:09:22 PM

As our Fact Table is big, we have separated the fact table into sevral smaller ones, such as FT_SALES_2018, FT_SALES_2019 ... They are all same in DDL structure, but I found CA DC only support star schema, looks like can not have several Fact Table

Thanks

Title: Re: Will one DC support multipal Fact_Table?
Post by: bus_pass_man on 22 Nov 2019 03:37:29 AM

Look up about virtual cubes.

Each cube can only support one fact table but virtual cubes allow you to have a multi-fact cube.

http://www.redbooks.ibm.com/abstracts/sg248064.html?Open

Title: Re: Will one DC support multipal Fact_Table?
Post by: Eag. E on 23 Nov 2019 08:25:00 PM

Thanks so much, it helps a lot, by the way, I saw the book was in 2015, is there any new version of this book? Or the DC has stopped developing

Title: Re: Will one DC support multipal Fact_Table?
Post by: bus_pass_man on 24 Nov 2019 05:23:23 AM

I have not seen any new edition of the Redbook nor have I seen much, if any, changes in the UI of cube designer or of dynamic cube behaviour.

Neither of those are particularly pertinent to your immediate problem, which is how to deal with multiple fact tables.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dynamic Cubes => Topic started by: Eag. E on 21 Nov 2019 10:09:22 PM