Time dependent Hierarchy Error Message in SAP BW on HANA 7.5 SP 05

[former_member189979]

Dear All,

I'm working on SAP BW on HANA 7.5 SP 05 and I have a reference InfoObject referencing to 0BPARTNER, which has a hierarchy.

But when I create a BEx query and use it into my Webi report, it does work fine on Text Node, but on Leaf Node. I'm facing following error message.

BW System DW3 returned state 'NO_DATA_AVAILABLE'. Message = Instantiation of calculation model failed;exception 306105: Invalid query. Failed to find 'CLGCCLMNT_SID' at node ... '0BW:BIA:CLGCV01' /[Request Info: Object Name = "SAPDW1"."0BW:BIA:CLGCV01", FM Name = TREX_DBS_AGGREGATE] Error 34,023 has occurred in the BWA/SAP HANA server Error reading the data of InfoProvider CLGCV01$X Error while reading data; navigation is possible (Error: INF )

Please find attached screen shot for the error message as well.

I will appreciate any input or assistance in this matter.

Many thanks!

Tariq Ashraf

[nora_roch]

Hi Tariq,

always double check with collective KBA

2607883 - Checking Column view and calculation scenario/ calculation model errors in BW Queries

It references many corrections and fixes related to column view and calculation scenario related error message like this one. It also list troubleshooting reports to repair temporary inconsistencies.

A specific one that might fit to your case is SAP Note:

2597978 HCPR Query fails with Error 'Failed to find 'IOBJ_KEY' at node' and Return_Code 34023

Cheers,

Nora