ROLAP not working - how to design the cube/DSV for ROLAP?

ROLAP not working - how to design the cube/DSV for ROLAP?

I'm trying to configure storage mode ROLAP for a partition in an existing SSAS cube. The cube is a little messy in that the measure group is defined by a named query (as opposed to a table) and the dimensions are defined in several different data source views (DSV).

This is the error message I get when querying the cube with mdx:

Executing the query ... Server: The operation has been cancelled. Errors in the high-level relational engine. The 'dbo_dim_account' table that is required for a join cannot be reached based on the relationships in the data source view. Execution complete 

Note that MOLAP storage mode with proactive caching works fine. This problem occurs only when storage mode is ROLAP or HOLAP.

Also, I have tried to add the tables of all dimensions to the DSV of the cube in question but that doesn't seem to help.

Any ideas?

why would a SQLCLR proc run slower than the same code client side


Inline documentation for SSIS packages
Not an expert here, but you could try importing the AS DB in Visual Studio.NET - "Import Analysis Services database" in the New Project...

Class is not found in SQL assembly
How do I view the SSIS packages in SQL Server Management Studio?
Once in there, you can see the table schemas for the Data Source View (which is where the relational tables are defined that the cubes are extracted from).

SQL 2005 express with 2008 express compatibility
Next, look to make sure the "dbo_dim_account" table is there and that your fact table is related to it..
How to run SQL Server Management Studio without loading Add-Ins
It may be that a dimension and fact have to be in the same DSV for the relation to work?.
How to show the execution time before query result will display
Also, maybe the SSAS flight recorder or Application log would have more issues?.
SignByCert and the maximum size of sign

88 out of 100 based on 88 user ratings 688 reviews