Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 313 Oracle Analytics and AI News
- 58 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 118 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Using Essbase and Sql data source in report not giving any data
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
-
Are all LTS content levels and mesure content levels properly filled out? Normally it's a simple question of evening out dimensionalities.
0 -
@2714750 did you abandon this question? Is it still open?
0