This content has been marked as final. Show 3 replies
Regarding your query mentioned below, how to map a rowsource data for 4 dimensions only wherein there are 5 dimensions in cube. This can be achieved from the cube.xml file. You would first need to export out the cube definition.xml file and add the RowSourceMapping for all the 5 dimension.
Over here, you can map the dimension to the membercolumn and namespace.
Incase where there are no membercolum mapping, it can be mapped to the dimension itself.
After doing this you need to import the cube back again and publish it. All this would need to be achieved using the isadmin commands.
Partially mapped measures should always be used in a formula. I think IOP generates a warning if I recall. The reason being IOP cannot and doesnt want to load in all the wild card members for the missing dimension.
Partially mapped RS are expensive.
Your other choices are to load at a fixed (say root) member in the missing dimension and then do a rolldown.
You can also think of using "lookup" function.
I have a similar issue. I also tried to map one RS with the cube which is having 3 dimensions A- Bom B- Supplier C- Calendar .
The RS is mapped to Cube with B & C and we are giving Wild flag for A (Though its expensive).
Correct me if my understanding is right : When we create Application RS ...The data that is getting loaded in RS is for the combination of B & C , it is taking only one combination of B & C for one row. Though we wanted to bring all the other values for same combination for our lookup reference in measures , IOP RS is rejecting all other data with the same combination mentioning as "Duplicate Record" .
I used RS indices also but that also didn't work for us.
To get complete data we created custom RS and it worked fine (We got all data in RS) but then we lost the ability to update the Inline reports based on it in IOP.
Please Suggest if this can be handled some other way.