Skip to Content
avatar image
Former Member

What are the difficulties we face while creating a Universe.

Hi i am new to Business objects, i want in detail what are the difficulties we face while creating a universe and how you resolved it.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Jan 30 at 03:00 PM

    Hello,

    There are no difficulties building the universe as long as you have a clear understand of database concept. Once you have a good knowledge of database structure than you can use our Information design tool (IDT) or Universe design tool (UDT)

    to extract, define, and manipulate metadata from relational and OLAP sources. Normally, you need to be able to understand the SQL expression very well. You have to be able to understand how the data security works for each team and individual. You need to know how join woks, Alias, Loops, Contexts, Index, Aggregated Awareness, etc. As well as middleware concept (JDBC, ODBC, etc). You need to be able to understand the difference between OLAP (Cube) and relational sources. Normally, DBA can fit in to build a good universe. My strong recommendation is for you to take as many training\practice as possible before start building any official universe. If it’s possible work with someone who has built universe before. There is also many YouTube you can use.

    Thanks,

    Sonet

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 30 at 01:04 PM

    HI, I have taken training in SAP BO 4.2 and currently working in sap BO weekend support, i know how to create the universes with different data sources & using OLAP CONNECTIONS.

    i want to know some difficulties we face while creating universe . please help me in this.

    Add comment
    10|10000 characters needed characters exceeded

    • OLAP universe is bit straightforward.Classes and objects will create automatically in OLAP universe.

      You can start looking on below points for relation universes. If you will search on google you will get multiple blogs.

      1)use of context vs alias and when?

      2) how to resolve loops?

      3) how to set aggregated awareness.?

      4) How to create derived /views and pros/cons ?

      5) explore different function available in universe and how to use them in creating custom objects?

      6) row level security setup and benfit.

  • Jan 30 at 09:28 PM

    Also there are official product tutorials Official Product Tutorials for Information Design Tool

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 30 at 11:03 AM

    if you are knew in Business Object space then i would suggest to start with IDT help guide and search blogs in the google for individual topics.There are many blogs are available on each topic.

    https://help.sap.com/doc/businessobject_product_guides_sbo42_en_sbo42_info_design_tool_en_pdf/4.2/en-US/sbo42_info_design_tool_en.pdf

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 22 at 06:49 PM

    Hi

    While working with Universe Designer the common difficulty is about the joins that we set between the tables and the cardinalities. Apart from that other difficulties which are like the connection parameters issue. We need to be careful while setting up the parameters. More to that, while we have multiple data providers for creating universe in Information Design Tool (IDT) then there comes the complex nature of Universe Design and further which effects on the report level.

    We need to check with the join path errors in the universe level like Loops and Traps. It would be a good advice if we do major query modification at the database level rather doing in the universe or report level.

    Other minor difficulties that we see in universe level can be adding of new objects and then defining the objects.

    Overall if you are new to universe designer then try with single data source and after getting command then try with multiple data provider.

    Regards....

    Add comment
    10|10000 characters needed characters exceeded