
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
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 a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
23 | |
19 | |
9 | |
8 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 |