Skip to Content

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

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. 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.

    (0) 
    1. Shaik Jameel Ahmed 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

      (0) 
  2. 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

    (0) 

Leave a Reply