Retrieving Dynamic Calc Members

Dynamic Calc are database members that are excluded from the batch calculation process, thus shortening the regular database calculation time.

The Essbase application designer tags Dynamic Calc members in the database outline so that Essbase knows not to calculate those members until a data retrieval requests them. Dynamically calculating database members benefits Essbase Server in these ways:

Reduced disk usage
Reduced database restructuring time
Reduced time to back up the database

Database values thatEssbase calculates dynamically take slightly longer to retrieve in Spreadsheet Add-in because calculations must be performed before retrieving data into the worksheet.

To retrieve Dynamic Calc members and dynamically calculate the database, select Essbase, and then Retrieve.

Notes:

To identify members tagged as Dynamic Calc members in the spreadsheet, you can define a visual cue, or style (see Changing Member Name Fonts and Colors), for them.

Note:

Other styles that you set may override a style for Dynamic Calc members. For example, if a parent member is a Dynamic Calc member, and if you set styles for parent and dynamic calculations, the style for the parent member overrides the style for the Dynamic Calc member. You must remove the style for parent members to see the style for Dynamic Calc members.

Activate Navigate Without Data (see Navigating Through Worksheets Without Retrieving Data) while you are formatting a worksheet containing Dynamic Calc members so that Essbase does not dynamically calculate the database while you are creating the spreadsheet report.
Dynamic Calc members may return incorrect values when a member formula references another Dynamic Calc member.
For example, a member formula of a Dynamic Calc member A contains a function, @CONCATENATE. The result of that function is another Dynamic Calc member B. When the query only contains member A, the result may be incorrect because member B is not a direct reference in the formula of member A. The name string for member B itself is dynamically constructed.
In this case, you should include Dynamic Calc members A and B in one query.