Dear all,

I need to set up OLAP cubes for sales analysis. In the
source database, there are two fact tables: Inventory
Balance and Sales Summary Table. The report analysis will
be based on these two fact tables.

How can I to combine these tables into one cubes and the
key will be the Item Code.

Please feel free to give your comment.

Create a view first that will include all your measure then use this view as
the fact table.


"Anderson" <andersonw (AT) system-pro-solutions (DOT) com> wrote

If you already have Cubes for Inventory Balance and Sales Summary with some
identical dimensions (should be shared dimension), you can consider to use
virtual cube.

"Anderson" <andersonw (AT) system-pro-solutions (DOT) com> wrote