Skip to Content

This will help you connect your BI4 Dashboard directly against ECC box in real-time (no SAP Hana required)


1) ECC 6.0 Enhancement Package 5

2) Configured for transient providers (using an ECC InfoSet)

3) SQBWPROP – InfoProvider must be set for BI Release

4) BI4 SP4 (includes feature pack 3)

First I created a BEx Query against the ECC InfoSet


I set the flag for Allow External Access to this Query


Then I set up an OLAP connection in the Central Management Console.

I chose to connect to the Query I created against the ECC InfoSet in the CMC.

Now log on to BI4 Dashboard


From the Query Browser, select Add Query


Select BEx and then click Next


Select the OLAP Connection created against the ECC and click NEXT


From the Query panel drag over the Fiscal Year and Gross Amount


After Preview Query Result click Next

At Usage Options click OK


Now you can follow the Dashboard creation steps; you can bind to the Query now instead of the spreadsheet


To report this post you need to login first.


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

  1. Former Member

    Hi Tammy Powlas,

    This post is really helpful to us.

    Can you please clarify one doubt for me?

    After adding a Bex query , will the data not be displayed in Dashboard(Excel sheet) below.( I am referring to second picture from the bottom).



    1. Tammy Powlas Post author

      Hello Santosh,

      If you bind to the BEx Query you will not see it in the spreadsheet.

      There are times where you may need to the spreadsheet for selectors that are not available via the BEx Query.


      1. Former Member

        Thanks for the responce.

        Is there any work around for this issue?

        In my case, it is compulsory for me to display the data in Excel because we have calculation to be done in excel.



        1. Tammy Powlas Post author

          I am not familiar with a work around – perhaps post your question in the discussion forum to see if others in the community have a possible solution?

        2. Bhanu Gupta


          We end up running the BEx query and copy pasting into the excel…not automated, but gets the work done when we need additional excel based calculations.



  2. Former Member

    Hi Tammy,

    Infoset you mentioned refers to BW InfoSet or some entity from ECC.

    I want to create a dashboard with ECC as data source. This post certainly helps me however would like to know how you created the BEx query on ECC.

    Does that require BW setup as well?



  3. Former Member

    Hi Tammy,

    Just a quick question on #2) Configured for transient providers (using an ECC InfoSet).  My understanding on your post is to ECC –> BW –> BEx Query –> Dashboard?  Am I right?  Where to configure #2, is it on ECC or BW?

    Thank you in advance,


  4. Former Member

    Hi Tammy,

    very informative document..

    When I create the BICS connection, in the preview query result, it is taking long time to give output, have any idea with whats wrong.

    1. Tammy Powlas Post author

      Yes, they can be slow; that is why in one of the SAP presentations they recommend running RSRT to measure performance before running it in a BI tool.


Leave a Reply