1. Scripting Reference for Oracle Essbase
  2. Report Writer
  3. Report Writer Syntax
  4. Referencing Static Members

Referencing Static Members

You can enter static (non-changing) Essbase member names, such as Sales and COGS, directly into report scripts. For static member names, use staticMbrDefinition syntax, as described below.

Command

A staticMbrDefinition specifies the member to select.

Syntax

mbrName [ mbrName ]

mbrName

Dimension or member name of member to specify. When specifying multiple member names, separate them with spaces. Enclose member names in double quotes if they contain spaces or consist of numbers. For example: "Cost of Goods Sold" or "100-10"

Description

A static member definition specifies a database outline member in a report specification. This definition does not automatically reflect changes to the database outline. If you change a member name in the database outline, you must manually update each report script associated with that outline.

Example

Year

Selects the member Year.

Sales "Cost_of_Goods_Sold"

Selects the members Sales and Cost_of_Goods_Sold.