Nav4.01-BA cubes questions about setting up dimensions.

joh_ver

This deals with the configurator creating the datamart and processing the cubes (Nav 4.01 NL)

1. How can I setup a dimension which has a relation with the fact table based on 2 fields (e.g. doc. type and doc. no.). If I create 2 lines in the 'related tables' window, the cube is created wrong.

2. I have a dimension based on 3 levels:
value entry --> item --> inventory posting group
The cubes processes with correct data (I checked in the analysis services). But in the BA client it says: 'cannot find dimension member ([dim].inventory posting group) in a name-binding function'
Also the configurator decided to create an extra level in the dimension: Item_Group ???

Thanks!,
Johan.

kine

May be that your problem is this (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.

Maci

Please, where can I find the "Know Installation Issues.doc"?

Thanks

kine

I have it from support engineer when I was solving some problems through service incident. I am not able to locate it on Partersource right now...