cancel
Showing results for 
Search instead for 
Did you mean: 

Issue when using Navigation attributes for filtering in BEX

Former Member
0 Kudos

Hello,

We are encountering an issue when applying filter on Navigation attributes in BEx query built on top of a BW HANA Virtual Provider.

The interface is as below :

HANA Calculation View -> SAP BW 7.4 Virtual InfoCube -> Multiprovider -> BEx Query.

We have directly mapped the base Infoobject from HANA View to BW Virtual Provider and using this in BEx query free characteristics. We also have used the navigational attribute of this Infoobject in our Report variable screen as well as an Auth relevant object.

Eg if ZMATERIAL is the base infoobject and ZMATERIAL__ZXYZ navigational attribute is used in the report variable screen and as Authorization variable.

This is causing the query to fail.

The query also fails if I apply any filter values on any Navigational attribute with error message  :

"Termination message sent ERROR DBMAN (305): Error reading the data of InfoProvider"


Using the navigational attribute with authorization variable fails with below :


"Termination message sent ERROR DBMAN (099): Invalid query;Failed to find attribute ZMATERIAL__ZXYZ [...]"


Appreciate any inputs on this issue and how this can be fixed.


Thanks,

Tintu

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Issue got resolved after implementing notes 2047737 & 2107307. Thanks very much for the inputs.

Loed
Active Contributor
0 Kudos

Hi Tintu,

You may close this thread by clicking the CORRECT ANSWER and HELPFUL ANSWER..

Regards,

Loed

Former Member
0 Kudos

Hi,

See note 1971646


BR,

Former Member
0 Kudos

Hi Andrey,

Thank you for your input.

Based on the OSS note , it says to import BW7.4 SP7. We are already on BW7.4 SP7

We get error "Termination message sent ERROR DBMAN (099): Invalid query;Failed to find attribute

ZMATERIAL__ZXYZ"  whenever we try to apply filters on any of the navigational attribute.

Thanks,

Tintu