Skip to Content

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.

To report this post you need to login first.

14 Comments

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

  1. Santy N

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

    Thanks

    Santosh.

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

      Tammy

      (0) 
      1. Santy N

        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.

        Thanks

        Santosh.

        (0) 
        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?

          (0) 
        2. Bhanu Gupta

          Santosh,

          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.

          Regards,

          Bhanu

          (0) 
  2. Tejas Tamhane

    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?

    Regards,

    Tejas

    (0) 
  3. Geraldine Anselmo

    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,

    Gerald

    (0) 
  4. Prisca Joseph

    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.

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

      (0) 

Leave a Reply