Assigning Members

You assign members, functions, substitution variables, and lists to retrieve data for your reports.

You can select members to be displayed in your report, or you can use functions to select dimension members dynamically. You can insert a separate row or column in a grid for each selected member, or you can place all of the selected members in one row or column. If the selected members need different formatting (for example, font, border, etc.). they must be placed in separate rows or columns.


Reports utilize a relational metadata cache to speed up member queries and member selection operations such as searches and formula bar type-ahead. The cache is generated and populated for each report designer and end-user the first time a report is accessed during their session. The cache remains in place throughout the user's current session and is cleared when a user signs out of the Cloud EPM business process (For example, Narrative Reporting, Planning, and so on) where Reports are being used and accessed.

If a cube's dimensions and members are updated while a Reports user is in an active session, the metadata cache will not be updated to reflect dimension and member changes. A user will need to sign out and sign back into their Cloud EPM Business process to refresh the metadata cache to reflect any changes made.