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

2714750

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.

[Deleted User]

Are all LTS content levels and mesure content levels properly filled out? Normally it's a simple question of evening out dimensionalities.

[Deleted User]

@2714750 did you abandon this question? Is it still open?