Business Analytics - Defining dimension hierarchies

June

Hi,

I am trying to set up a sales cube which includes a customer dimension. At the upper level of this dimension, I need to have customer category - which is defined as a dimension in Navision. Customer name should appear as a second level of the dimension. I tried to link my customer table and alternatively my fact table ( item ledger entry) to the default dimension table but it doesnt work. I get an error message when configurator is run.

Grateful if anyone could help me with this.

Thanks,

June

kine

Part from Known Installation Issues.doc:

7) Dimension Hierarchies only support two levels of nesting
Creating a dimension based on three or more levels of tables will fail. You can still reference three or more tables, but the depth of the schema can only be two. This means that related tables must relate directly to the base table.

[/code]

June

Thanks for sharing that.

IF the depth of the schema should be 2, then shouldn't it work when i relate my fact table to the default dimension table directly (through the source no). Is it possible to filter on the specific dimension i want to relate to in the default dimension table at this stage.

thanks,

June