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)

Prerequisites:

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

/wp-content/uploads/2012/09/1fig1_137723.png

I set the flag for Allow External Access to this Query

/wp-content/uploads/2012/09/1fig_137724.png

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


/wp-content/uploads/2012/09/2fig_137725.png

From the Query Browser, select Add Query

/wp-content/uploads/2012/09/3fig_137727.png

Select BEx and then click Next

/wp-content/uploads/2012/09/4fig_137726.png

Select the OLAP Connection created against the ECC and click NEXT

/wp-content/uploads/2012/09/5fig_137728.png

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

/wp-content/uploads/2012/09/6fig_137729.png

After Preview Query Result click Next

At Usage Options click OK

/wp-content/uploads/2012/09/7fig_137730.png

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

/wp-content/uploads/2012/09/8fig_137731.png.

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