SAP BI 4.x - List of metadata universe unx

[former_member591790]

Hi, I need to know the complete list of all the metadata that can be obtained via sdk, the metadata of business layer (sql of objects, name of objects, type of objects, etc ..) and the metadata of foundation layer (name of tables, fields, etc ..) .
On the document "SAP BusinessObjects RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Layer" in the paragraph "Getting the Details of a Universe (Semantic Layer)" there is an example of the available metadata, but they are not all, right? Thank you.

<universe>
    <id>5808</id>
    <cuid>AUW2qRdU0IdPkyhlpZWrxvo</cuid> 
    <name>Warehouse.unx</name>
    <type>unx</type>
    <folderId>5807</folderId>
    <maxRowsRetrieved>5000</maxRowsRetrieved>
    <maxRetrievalTime>600</maxRetrievalTime>
    <outline aggregated="false">
        <folder>
            <id>_IBo8OLIhEeCk0Ylv-tlF2Q</id>
            <name>Customer</name>
            <item dataType="Numeric" type="Dimension" hasLov="false">
                <id>_IBo8ObIhEeCk0Ylv-tlF2Q</id>
                <name>Customer Id</name>
                <path>Customer|folder\Customer Id|dimension</path>
            </item>
            <item dataType="String" type="Dimension" hasLov="false">
                <id>_IBo8OrIhEeCk0Ylv-tlF2Q</id>
                <name>Customer</name>
                <path>Customer|folder\Customer|dimension</path>
 	      </item>
            <folder>
                <id>_IBo8LbIhEeCk0Ylv-tlF2Q</id>
                <name>Geography</name>
                <item dataType="Numeric" type="Dimension" hasLov="false">
                    <id>_IBo8MrIhEeCk0Ylv-tlF2Q</id>
                    <name>Continent Id</name>
                    <path>Customer|folder\Geography|folder\Continent Id|dimension</path>
                </item>
                <item dataType="String" type="Dimension" hasLov="false">
                    <id>_IBo8M7IhEeCk0Ylv-tlF2Q</id>
                    <name>Continent</name>
                    <path>Customer|folder\Geography|folder\Continent|dimension</path>
                </item>

[denis_konovalov]

I have fixed your tag, please select more careful next time

[DellSC]

You need to use the Semantic Layer SDK with java to get this information. See the samples that Ayman points to above.

I have done some pretty extensive work with this SDK. If you have questions as you get into the code, post them to the Community as new questions using the " SAP BusinessObjects - Semantic Layer - SDK" tag and I should be able to help you.

-Dell

[former_member591790]

Thank you Dell!

[former_member591790]

Hi Dell, I can't take the time for this issue. It's a bit complicated for me.

Could you tell me what are the metadata of a universe that can be read via the SDK?

In the document "SAP BusinessObjects RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Layer" I found these metadata:

name universe
type universe
maxRowsRetrieved
maxRetrievalTime
name folder universe
name item
folder path item
item dataType
item type

There are others? For example the sql of items in the universe or the list of tables and their columns.

Thanks for the support

[DellSC]

You don't mention the specific version of BOBJ that you're using - the RESTful SDKs have evolved through the service packs of 4.2 and 4.3, so you need to find the documentation that's specific to the version and SAP that you have installed. To do that, go to the BOBJ help site at https://help.sap.com/viewer/product/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/. In the top part of the screen, there's a version drop-down next to the word "Platform". Use that to specify the version you're working with. Scroll down to find "Development". In that section you're looking for something like "SAP BusinessObjects RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Layer". It may be on this main page or you may have to click on the "View All" button for the Development section. If you can't find it there, change to the version just prior to the version you're looking at.

Once you've opened the Help document, scroll down on the left and open the "Managing Universes with the BI Semantic Layer RESTful Web Service SDK" hierarchy. You'll find info about some of the things you're looking for there. Unfortunately, at least in 4.2 SP9 and earlier, it doesn't look like you can access the Data Foundation or the specifics of the objects in the Business Layer from there. You need to use the java Semantic Layer SDK to get that information.

-Dell

[former_member591790]

You are right, sorry. We have SAP 4.2 sp7.

Ok, I follow your instructions, thank you very much