Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Using Essbase and Sql data source in report not giving any data

Received Response
2
Views
2
Comments
2714750
2714750 Rank 2 - Community Beginner
edited Aug 13, 2024 6:11PM in Oracle Analytics Cloud and Server

Hi,

I've an Essbase source where hierarchy on Account is present and another SQL fact where Account_number column is present.

now if I build separate report with columns from SQL fact and check for an Acc No. record is coming. Similarly separate report with columns from Essbase source only is also working.

But when any field from Essbase source is pulled in report with SQL source, those new fields come as blank though no error thrown.

In rpd I created a BMM table with 2 datasources- Essbase and SQL and did content mapping there -

for Essbase source - the columns coming from sql source are unmapped and

for Sql source - the columns coming from Essbase source are unmapped.

Please help to find out the issue and resolve.

Regards.

Answers