Skip to Content
Author's profile photo Kodanda Pani KV

BEx Query Execution Error

When i was working with BEx Query designer i got errors while opening the BEx queries.

Initially As for client requirement i added all char in free char panel user will drill down based on their requirement after testing the queries they suggested unwanted objects. Then i removed unwanted objects form targets (Info Cube and DSO)

While opening the queries through BEx Analyzer respective info cube we are getting some errors

Characteristics not available in Info provider

Then run the same query in RSRT going to ABAP debug mode.

After saving the query in BEx Query designer level getting errors.

Means initially removed these objects form Target level (Info cube and DSO)

Now see unwanted objects is have capital letters means these are all objects unwanted objects

After removing all objects from BEx query designer level its working fine.

After running the same query in RSRT and BEx Analyzer it is working and now query executed.



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Aparajit Banik
      Aparajit Banik

      Good one kodanda,
      If you have some more scenarios please do post with screenshots. Really helpful!

      Author's profile photo Former Member
      Former Member

      This is really good one..short way to easily identify the removed objects in info provider at query designer.

      Hope it doesn't change the the description of other info objects in query designer.

      I might be missed some points here..can you plz help me to understand? While executing in RSRT with debugging mode will it throw an error? or when exactly this magic happening at query designer while saving the query or running in RSRT debugging mode ?


      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks for asking.

      i developed the query in DEV system but they (users) are not using nationality info object at report level then i delete the nationality directly in PRD system in cube not in query level.

      after i run the query RSRT it by default going to debug mode then i removed form the query designer after that its working fine.

      i faced the issue about error i wrote the blog.