Skip to Content
Author's profile photo Former Member
Former Member
December 31, 2015 2 minute read

How to identify the Bex Query Technical Names in Dashboard

Scenario:

we have many SAP Dashboards which was built on BW BEx Query’s Using OLAP Connection.

it is very difficult to Identity the BEx Query Technical Name, This feature is not included in official release. How to Identity ??

Create an OLAP connection:

A1.png

Open your Dashboard Tool & Go to Query Browser –> Click on Add Query

A2.png

Select Data Source –> BEx

A3.png

Select your OLAP Connection

A4.png

Select your BEx Query

A5.png

Select Your Fields

A6.png

BEx Query Technical Name not available, if I have more that one Query which have same description How I can Identify which Query is used in Dashboard.

A8.png

Solution:

As per SAP, this future will be available in Version 4.2 SP3.

The attachment (testing_binary.zip) contains the fix .

    1) Unzip files in attachment “testing_binary.zip”

copy them to C:\Program Files (x86)\SAP BusinessObjects\Xcelsius 4.0\assets\queryComponent

(backup original files first)

    2)  Re-launch Dashboards

    3) Open your xlf file, see if you can find the technical name in

tooltip.

    4) Note As per SAP, these files should work with BI4.1 Dashboards SP05 and

above, I tested with 4.1 SP02, it works.

A9.png

you can find the technical name in tool-tip.

A7.png

Note: Attached files I received from SAP as a interim solution.

Thanks,

Jameel Ahmed Shaikh

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Febrillian Pemisindo
      Febrillian Pemisindo

      Hi Jameel,

      Thanks for sharing. Always a pain for searching for the bw query technical name in dashboard. Glad to hear that the solution will available in the new version by default.

      Anyway, i didn't see any attached file. Did you forgot to attach?

      Thank you in advance.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Febrillan,

      I didn't forgot , unfortunately the file type (.ZIP) is not supporting to attach.

      let me know if you have any solution to attach here.

      THx.

      Jameel

      Author's profile photo Febrillian Pemisindo
      Febrillian Pemisindo

      i see. i haven't make any post before, so i don't know that zip is not supported.

      maybe you can upload to google drive and post the link here?

      Author's profile photo Xiwen Liao
      Xiwen Liao

      Hi,

      According to note  2261141 - In SAP Dashboards, BEx technical name is not displayed on Query Browser and Query Panel,this issue has also been fixed on some latest version of BI 4.1.

      So it is not recommended to use the zip file which is just a interim solution.

      Instead, upgrading to the version as above will be a better solution.


      Regards,
      Xiwen