I am working on a CUBE built from a SQL Server 2008 environment.
I have a FACT table with these columns:
And few other columns. Fact table is build from join query written in a view.
I am having trouble on building dimensions.
If I have dimensions for Month, ServerName, Region, Year, Time - Cube Process failed.
For dimensions, every view will have UserId as the key column.
For example :
What could be the reason?
How to have Multidimensions for my Fact table.
As the FactTable should be in StarSchema Relation. UserId column will build the relation for DImension Tables to the Fact Table.
So i kept the UserId column to all the Dimension Table.
This breaks the Table Distinct Output. Though User Id is unique, Month is not unique ..