How To: Confirm If Dimension Member is Present in Essbase Database
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.