Skip to Content

Connect BI4 Dashboard to ECC (Real Time?) Read on

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


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