Unknown Member Error In Data Model When Running BI Publisher On Top Of Essbase
Last updated on JUNE 22, 2016
Applies to:BI Publisher (formerly XML Publisher) - Version 184.108.40.206.6 to 220.127.116.11.0 [Release 11.1]
Information in this document applies to any platform.
Running BI Publisher (18.104.22.168.10) on top of Essbase (22.214.171.124.100) and needs to view a report in BI Publisher that gets data from the Essbase cube.
In order to match this need, one created a data model in Bi Publisher as:
- Created a parameter
- The data set (sql query) is using this parameter in its where clause
Upon entering the query in step 2, one receives the following error:
One has only received this specific error when using Essbase as data source (no such problem with other source).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms