When you run BI Answers with any of the Essbase measures, you must apply a filter to the following:
Fiscal Calendar Name
Chart of Account (COA) Name
When you query, you use filters to connect to the correct source (Essbase cube).
See the section that describes creating and managing Presentation columns in “Oracle® Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.”
To connect OBIEE to Essbase, for security purposes you need to setup CSS token. For detailed setup steps, refer to the Oracle BI EE Administrator's Guide.