You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How To: Confirm If Dimension Member is Present in Essbase Database

29
Views
0
Comments

Summary:

This tip demonstrates a simple way to confirm if a dimension member is present in Essbase database.

Content (please ensure you mask any confidential information):

Here is a simple way to confirm if your EPM Cloud application's Relational and Essbase databases are in sync. Create a Smart View ad-hoc by connecting to your Essbase database. Below screenshot depicts how to confirm if Account Sep/23 is present in FCCS application's Consol database (aka cube).

The cell colour indicates if member is present in Essbase or not.

Another tip. If member is created in the dimension, but consolidation operator in the database is not set ("Not used for Cube" in case of Simplified Dimension Editor). Then member will not be shown in ad-hoc.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!