Skip to Content

Merging OLAP and Relational Sources in SAP Design Studio 1.6

Hi All,

I am developing a dashboard using SAP Design Studio 1.6SP2 where I have two data sources - universe and BEx.

Universe Data:

BEx Data:

I would like to show the output in Design Studio as below:

Could anyone please suggest how this is achievable?

Thanks

Poojitha

capture.jpg (11.9 kB)
capture.jpg (11.3 kB)
capture.jpg (14.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 27, 2017 at 10:48 PM

    Poojitha,

    You should be able to create a multi source universe which merges both the BEx Query and the Oracle database tables. Here are some links to get you started. As Tammy has suggested, you should review this with your Data Architect or whoever on your team is responsible for building universes:

    How to Create Universes Using BEx Queries as Data Sources with SAP BusinessObjects Information Design Tool 4.1

    YouTube Video: SAP BO4.1 - Creating Universe using IDT on BW Cube

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 27, 2017 at 09:45 PM

    You should do this on the backend; Design Studio doesn't have this capability. For speed and performance also, I recommend you do this on the backend.

    Add comment
    10|10000 characters needed characters exceeded

    • For this to work in Design Studio, the data needs to be combined on the backend; perhaps you could share details of your data model and post this in the Semantic Layer space? Just my take only