I have a dimension table which has 617319 rows(Other dimension tables are smaller) and the fact table has around 2000 rows
This dimension table has around 30+ columns. I need to retrieve around 15 columns from this dimension table along with the measures.
When I add this dimension table columns to the mdx query, the query takes a long time and we get an error - Memory error: Allocation failure : Not enough storage is available to process this command.
DimUser - 617319 rows
DimCustomer - 462 rows - around 30+ columns
DimSite - 48 rows
factLogin - 931 rows
factLogin has relationship with DimSite
factLogin has relationship with DimUser
DimCustomer has relationship with DimSite
View Complete Post