The info object has been deleted from the InfoProvider or set to invisible

[Former Member]

Dear Experts,

I have created one new report with few variables. While I am opening the same query in the BEX analyzer the query is not opening and showing the given below error message.

But, I have checked this info object in the relevant info cube and it is available.

Can you please suggest me to resolve this issue.

Error Message:

InfoObject 0CM_HIEID is used in the BEx Query Designer in element 535G8FBFE54SUQEPE0QYWNX39 (ELTTYP =).In the meantime it has been deleted from the InfoProvider or set to invisible.

Thanks,

Suresh.

[Former Member · Accepted solution]

HI suresh,

Please follow the Procedure part of the long text of error message:

Message no. BRAIN407

Diagnosis

InfoObject XXXX is used in the BEx Query Designer in element YYY. In the meantime it has been deleted from the InfoProvider or set to invisible.

System Response

The query cannot be executed.

Procedure

Change the query definition in the BEx Query Designer. The system proposes an appropriate solution to how the InfoObject can be removed from the query. You must ensure that the query is still defined meaningfully.

Chech if the InfoObject 0CM_HIEID is set to invisible in the InfoProvider.

Best regards, Andras

[RamanKorrapati]

Hi,

Where your facing this issue?

Your report have any hierarchy related info object?

Can you try to regenerate your report thru RSRT and check it.

Thanks

[Former Member]

Hi Ram,

Thanks for the quick reply.

Yes one hierarchy info object is available in the query. RSRT is not working properly.

Thanks,

Suresh.

[RamanKorrapati]

Hi,

Have you selected hierarchy(if needed)  at info object--->hierarchy -->select hierarchy at info object properties pane?

Thanks

[Former Member]

Hi Ram,

The info object: 0CM_HIEID is the Hierarchy ID onlly.

Thanks,

Suresh.

[RamanKorrapati]

Hi,

Have you used 0CM_HIED in query rows/columns/filters?

Can you remove it and recheck it.

Later readd it if needed?

Thanks