Feb 20, 2018 at 01:24 PM

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

378 Views

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