Question:
I loaded data for the SD_C03 cube from flat files (Sales Order, Delivery and Billing) and when I run the query the Net Price is displayed blank. When I go back and check the data in the files I do see values for Net Price for each comp_code. I thought of investigating this issue and started the below process:
First I deleted cube data and then:
I have loaded VAITM data into SD_C03 cube and try to view the data in the cube (Right click on Cube --> Manage --> Contents
In BW - When I query for Comp_Code, Net Price - comp code is not displayed but net price is displayed. Later on I loaded VAHDR data and then looked for the same Comp_Code and Net price - this time Where ever there is comp_code, the Net Price was blank and when Net Price has some value Comp_Code is blank. Strage!
Pl. help me understand why this behavior.
Does authentication cause this kind of problem? Same time when I query comp_code, some key figure in another cube there is no problem.
-- alisetty
Answer:
Are your company codes numerice? If so maybe you are loading them with or without the zeros...
_________________
What does not kill you makes you stronger...
(Unless you are bleeding profusely)
Answer:
I do have values for comp code and net price for each row