Skip to Content
author's profile photo Former Member
Former Member

Creating unv from "metadata exchange" (OLAP)

Is it possible to create universe using option "metadate exchange" in universe design tool (ver. 14.0.2.364) from OLAP AW created in AWM (ver. 11.2.0.3)? Oracle DB version is 11.2.0.2.

I already try to do it, but when i choose option "Create universe from" + "Oracl OLAP 9i/10g/11g", using connection based on "Oracle client 11" i dont see any cubes created.

Can you give any clue how to fix it? How to connect from universe design tool to Oracle OLAP 11g?

Thanks for any advise.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 02, 2012 at 06:38 PM

    In previous version - XIR3.1 we supported the Common Warehouse Model OLAP (CWM OLAP) for generating the universe from XML. BI4. universe design tool, should be the same.

    Try this information collected from the universe designer guide.

    Creating a universe from an XML metadata source

    To generate a universe from an XML metadata source

    1. 1. Select File > Metadata Exchange. The Metadata Exchange panel appears.
    2. 2. Select a metadata format from the Create a universe from drop down

    list box. Click OK. The Universe Builder wizard starts. Click Next. The

    XML file source page appears.

    1. 3. Click the Browse button and select an XML source file. This is the file

    that you want to use to generate the universe. Click Next. The Select

    database page appears.

    1. 4. Click the source database. Click Next. The universe elements page
    2. appears. The available database tables and columns are listed in the left
    3. pane.
    4. 5. Select one or more tables and columns and click the right arrow to

    populate the right pane. The tables and columns in the right pane are

    those that appear in the generated universe. You can use the arrow

    buttons to add and remove tables from the universe pane as necessary.

    Click Next. A connection and universe properties page appears. It lists

    the connections available to Designer. These are described in the section

    Choosing connection and universe options

    1. 6. Click a connection in the connections list. This is the connection to the

    data source that the universe uses to retrieve data. Type a universe name.

    Select or clear options check boxes. Click the Advanced button to set

    trace log file and XML source file options. Click Next. The universe

    generation summary page appears. It lists a summary of the options that

    you have selected during the wizard. Click Finish. The generated universe

    appears in the universe and structure panes of Designer.

    Choosing connection and universe options

    You have the following options on the connection and universe build page

    of the metadata universe builder wizard:

    Build universe settings

    Select a connection Listed connections are connections available to Designer. This is the connection to the target RDBMS.

    Universe name The name of the universe that will be generated.

    Save universe

    Automatically When selected, the universe is saved on creation.

    Replace existing

    Universe When selected, if a universe with the same name exists, and Save universe automatically is selected, the new universe replaces the existing universe.

    Advanced settings

    General tab

    Traces Path to the trace folder. This is the folder that holds the log files when universes are generated. You can browse to and select a folder.

    File locations tab Default XML Source File Folder Path to the default folder that stores the XML files used to create universes. You can browse to and select a folder.

    File locations tab

    Parameter File Path to the default folder that stores the parameter files. These are files created when a universe is created. These files store and reference the selected metadata so that it can be reused for creating or updating other universes. The parameter file does not store the selected metadata. it is a filter that directs the bridge to the selected metadata through the original XML file. You can browse to and select a folder.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 02, 2012 at 04:38 PM

    Hi

    I do not see Oracle OLAP listed in the supported platform document of BI4.0 so I assume is not supported.

    See on the SMP the document

    SAP BusinessObjects BI 4.0 Feature Pack 3 Product Availability Matrix (PAM)

    Regards

    F.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.