cancel
Showing results for 
Search instead for 
Did you mean: 

Cost Centers not visible in BEx queries but exists in DSO(Planning Mode).

former_member327199
Participant
0 Kudos

Hi Experts,

Am using BEx query as source in APD to load data into DSO which is created in planning mode. DSO has 0costcenter as one of the infoobjects. When I load data for controlling area 'FACS' it loads data and is displayed in BEx query results created on DSO. But when you create another APD to load records of controlling area 'NQSC' it loads data into DSO and are visible but when I run BEx query on that DSO it returns 0 records. I have been breaking my head since two days but no luck. am I missing any update step. Please note that FACS and NQSC are two different hierarchies nodes on 0cost centre with FACS and NQS controlling area.

Any help will be much appreciated.

Thanks

Sandeep

Accepted Solutions (0)

Answers (1)

Answers (1)

nora_roch
Employee
Employee
0 Kudos

Hi Sandeep,

not sure if there is an issue during the APD processing or with the data in the target DSO.

For the APD processing, maybe the APD with DataSource Query troubleshooting tips in the SAP Community Wiki can help.

If you think the data is fine (green request etc) in the DSO and the query for some reason does not find it for specific hierarchy nodes, please, check the hierarchy consistency with the hierarchy troubleshooting reports.

For a general query analysis, use the SAP Note: 1591837 How to analyze query results.

Cheers,

Nora

former_member327199
Participant
0 Kudos

Thanks Nora for your response. When I create new DSO similar structure as the one with issues without Copying it as template it loads and displays data without any issue.

Thanks once again for your reponse.

Sandeep