Skip to Content
Author's profile photo Tammy Powlas

Steps to Creating a Universe against SAP ECC (BI4 Feature Pack 3) Part 2

Part 1 of the document showed creating the project, relational connection and the data foundation.  This is a continuation of that document.

Create a new Business Layer

/wp-content/uploads/2012/05/1fig_98913.jpg

/wp-content/uploads/2012/05/2fig_98914.jpg

Click Next

/wp-content/uploads/2012/05/3fig_98942.jpg

Now select the Data Foundation

/wp-content/uploads/2012/05/4fig_98944.jpg

/wp-content/uploads/2012/05/5fig_98945.jpg

Click OK

/wp-content/uploads/2012/05/6fig_98946.jpg

Click Finish

/wp-content/uploads/2012/05/7fig_98947.jpg

This is where you will want to create/update more user-friendly descriptions of the fields.

/wp-content/uploads/2012/05/8fig_98948.jpg

Now you will create a query to test your universe

/wp-content/uploads/2012/05/9fig_98949.jpg

/wp-content/uploads/2012/05/10fig_98950.jpg

Execute Query

/wp-content/uploads/2012/05/11fig_98951.jpg

Assigned tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Tks, Tks Tks!! 🙂

      Author's profile photo Henry Banks
      Henry Banks

      thx!

      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      Thank you for posting this tutorial. I have a question regarding how the list of values are populated for the import values that are mandatory in the SFLIGHT bapi. Here is a screenshot I get in the Data Foundation step. BAPI_SFLIGHT_IMPORT.png

      I am not sure how to provide a list of values so that these can become prompts. I do get data in the business layer if i create a query and I hard code these values to FromCountry = DE FromCity = Frankfurt ToCountry = DE ToCity Berlin. When trying to provide a custom list of values I tried to provide Select COUNTRY From SGEOCITY table in ECC that is part of SFLIGHT but IDT does not recognize the table with my connection. Any tips on this or would I be better served in learning more about IDT as it applies to ECC?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Jon - I am not a BAPI expert (sadly) and now I see what you are doing.  I recommend posting this as a separate new discussion to get more expert help so others can see.  I will try to think about this but for faster response I recommend creating a new discussion thread.

      Author's profile photo Former Member
      Former Member

      Thanks for your response. I will create a new discussion. Just curious when you created your objects did you see that dialog when trying to view the data of the BAPI? I am wondering if this may be an issue with my authorization in ECC or if my lack of knowledge of the IDT is my issue. When you provided the query filter in your test query did you just know the values to hard code or did you get a list to choose from?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      I am sure I saw the dialog and knew the values ( I didn't get the list)

      I also used Integrating SAP BusinessObjects BI with SAP NetWeaver (3rd Edition) - SAP PRESS Bookstore SAP Press book to help with the steps

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Pages 204-210 describe creating a universe against the BAPI and has details

      Author's profile photo Former Member
      Former Member

      Jonathan - Did you ever find a solution for this?  I'm trying to do something similar but pass in @BOEUSER. 

      Thanks,

      Matt

      Author's profile photo Former Member
      Former Member
      Author's profile photo Mostafa Soliman
      Mostafa Soliman

      i created an universe based the above steps and working correctly and i create webi report based it and it work correctly local but when save this report on bi lanchbad and trying refresh it i recieved the below error.

      Capture.PNG

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Please create a new discussion thread on this issue and share which version of the tools you are using.

      Author's profile photo Henry Banks
      Henry Banks

      https://launchpad.support.sap.com/#/notes/1756769/E

      Hi, you are missing the sapjco .jar middleware somewhere on your server-side - see Note 1756769

      regards,

      H