UNAMEONDIMENSION
The UNAMEONDIMENSION Report Writer command in Essbase underlines the row member names in a row whenever a member from the same dimension as the specified member changes.
Syntax
{ UNAMEONDIMENSION mbrName }
Parameters
Notes
With the ROW command, you can display members from several dimensions in columns on the side of the report. At least one member changes from one of these dimensions for each row of the report. A single report can have several UNAMEONDIMENSION commands to underline row member names, based on different dimensions which change. When combined with UNAMEONDIMENSION and PAGEONDIMENSION, UNAMEONDIMENSION is processed first, followed by SKIPONDIMENSION and PAGEONDIMENSION in order.
Example
The following report script example is based on Demo Basic.
<PAGE (Market, Accounts)
Chicago Sales
<COLUMN (Scenario)
Actual
<ROW (Year, Product)
{ UNAMEONDIMENSION Year }
<ICHILDREN Year
<ICHILDREN Audio
!
The above report script example produces the following report:
=============== ================
Chicago Sales Actual
Qtr1 Stereo 2,591
Compact_Disc 3,150
Audio 5,741
================ ================
Qtr2 Stereo 2,476
Compact_Disc 3,021
Audio 5,497
================ ================
Qtr3 Stereo 2,567
Compact_Disc 3,032
Audio 5,599
================ ================
Qtr4 Stereo 3,035
Compact_Disc 3,974
Audio 7,009
================ ================
Year Stereo 10,669
Compact_Disc 13,177
Audio 23,846