How to decide on semantic keys ?

51 Views

Hi All,

We are facing one weird issue while loading data to one of the cubes. Please provide your inputs to resolve it.

Quantity needs to be fetched for Installation numbers using lookups in the end routine while loading the data from DSO to cube.

For each Installation number we are getting around 25 quantities.

If I am running a full load, 4 of the quantity fields are getting missed for one particular installation number

If I am using semantic keys (Installation number and some other fields), sometimes 2 and sometimes 1 quantity is getting missed which differs based on the semantic keys used.

If I run a full load with just that particular Installation number, all the data is getting loaded perfectly.

So our assumption is that the code is working properly, just that we need to change some settings for the full loads.

I have tried changing the package size and semantic keys but the data is not getting loaded correctly.

Please let us know your thoughts.

Thanks

Abhishek