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

Skip to Content

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

May 5, 2012 | 1,794 Views |

Tammy Powlas

bi4 feature pack 3 sapmentor semantic layer ecc

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

Click Next

Now select the Data Foundation

Click OK

Click Finish

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

Now you will create a query to test your universe

Execute Query

To report this post you need to login first.

12 Comments

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

Former Member January 17, 2014 at 1:42 pm

Tks, Tks Tks!! 🙂

like (0)
1. Henry Banks January 17, 2014 at 2:23 pm
  
  thx!
  
  like (0)
Former Member March 17, 2014 at 4:26 pm

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.

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?

like (0)
1. Tammy Powlas Post authorMarch 17, 2014 at 4:35 pm
  
  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.
  
  like (0)
  1. Former Member March 17, 2014 at 4:40 pm
    
    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?
    
    like (0)
    1. Tammy Powlas Post authorMarch 17, 2014 at 4:43 pm
      
      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
      
      like (0)
      1. Tammy Powlas Post authorMarch 17, 2014 at 4:50 pm
        
        Pages 204-210 describe creating a universe against the BAPI and has details
        
        like (0)
2. Former Member August 7, 2014 at 2:47 pm
  
  Jonathan – Did you ever find a solution for this? I’m trying to do something similar but pass in @BOEUSER.
  
  Thanks,
  
  Matt
  
  like (0)
Former Member March 21, 2014 at 9:05 pm

Still missing

IDT – supporting ERP-Tables (ABAP – tables) : View Idea

like (0)
Former Member August 8, 2016 at 1:24 pm

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.

like (0)
1. Tammy Powlas Post authorAugust 8, 2016 at 1:26 pm
  
  Please create a new discussion thread on this issue and share which version of the tools you are using.
  
  like (0)
2. Henry Banks August 8, 2016 at 1:50 pm
  
  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
  
  like (0)