15 Presentation Elements

Presentation elements are typically those elements that are exposed in the Presentation layer, or in other words, the elements that appear in the left-hand pane of the Administration Tool.

This chapter contains the following topics:

Section 15.1, "Presentation Catalog"
Section 15.2, "Presentation Schema"
Section 15.3, "Presentation Table"
Section 15.4, "Presentation Column"
Section 15.5, "Presentation Hierarchy"
Section 15.6, "Presentation Level"

15.1 Presentation Catalog

The presentation catalog element corresponds to the subject area object in the Presentation layer.

The presentation catalog tag includes the following attributes:

Table 15-1 Presentation Catalog Tag Attributes

Attribute Name	Description
isExportKeys	If set to true, indicates that logical keys for this subject area are exposed to other applications.
isAutoAggr	This attribute is not used.
hasDispName	Indicates whether this subject area has a custom display name.
dispName	The value of the custom display name, if one exists for this subject area.
hasDispDescription	Indicates whether this subject area has a custom description.
dispDescription	The value of the custom description, if one exists for this subject area.

The presentation catalog tag includes the following child elements:

Table 15-2 Presentation Catalog Child Elements

Element Name	Description
RefBusinessModel	References the business model for this subject area.
DefaultFactCol	References the implicit fact column for this subject area, if one has been set. This column is used to specify a default join path between dimension tables when there are several possible alternatives or contexts. The implicit fact column is contained in a sub-element called `RefLogicalColumn`.
Aliases	Lists any aliases that have been defined for this subject area. Aliases are created when presentation objects are renamed to ensure that any references to the old names still work in logical SQL queries. Each alias is contained in a sub-element called `Alias`, with one attribute called `name`.
Tables	References the presentation tables that belong to this subject area. Each presentation table is contained in a sub-element called `RefPresentationTable`.

Syntax

<PresentationCatalog …
     isExportKeys=""
     hasDispName=""
     dispName=""
     hasDispDescription=""
     dispDescription"">
   <RefBusinessModel …/>
   <DefaultFactCol>
     <RefLogicalColumn …/>
   </DefaultFactCol>
   <Aliases …/>
   <Tables>
     <RefPresentationTable …/>
   </Tables>
</PresentationCatalog>

Example

<PresentationCatalog name="Paint" id="4004:457" uid="413"
     hasDispName="false"
     hasDispDescription="false"
     isExportKeys="true"
     isAutoAggr="true">
   <Description /> 
   <RefBusinessModel id="2000:17" qualifiedName="&quot;Paint&quot;" /> 
   <Aliases /> 
   <Tables>
     <RefPresentationTable id="4008:459" qualifiedName="&quot;Paint&quot;..
     &quot;Markets&quot;" />
     <RefPresentationTable id="4008:460" qualifiedName="&quot;Paint&quot;..
     &quot;Products&quot;" />
     <RefPresentationTable id="4008:461" qualifiedName="&quot;Paint&quot;..
     &quot;Periods&quot;" />
     <RefPresentationTable id="4008:462" qualifiedName="&quot;Paint&quot;..
     &quot;Sales Measures&quot;" />
     <RefPresentationTable id="4008:463" qualifiedName="&quot;Paint&quot;..
     &quot;Share Measures&quot;" />
     <RefPresentationTable id="4008:464" qualifiedName="&quot;Paint&quot;..
     &quot;Forecast Measures&quot;" />
   </Tables>
</PresentationCatalog>

15.2 Presentation Schema

The presentation schema element is not used.

15.3 Presentation Table

The presentation table element corresponds to the presentation table object in the Presentation layer.

The presentation table tag includes the following attributes:

Table 15-3 Presentation Table Tag Attributes

Attribute Name	Description
hasDispName	Indicates whether this presentation table has a custom display name.
dispName	The value of the custom display name, if one exists for this presentation table.
hasDispDescription	Indicates whether this presentation table has a custom description.
dispDescription	The value of the custom description, if one exists for this presentation table.

The presentation table tag includes the following child elements:

Table 15-4 Presentation Table Child Elements

Element Name Description

Element Name	Description
Aliases	Lists any aliases that have been defined for this presentation table. Aliases are created when presentation objects are renamed to ensure that any references to the old names still work in logical SQL queries. Each alias is contained in a sub-element called `Alias`, with one attribute called `name`.
Columns	References the presentation columns that belong to this presentation table. Each presentation column is contained in a sub-element called `RefPresentationColumn`.

Aliases

Lists any aliases that have been defined for this presentation table. Aliases are created when presentation objects are renamed to ensure that any references to the old names still work in logical SQL queries.

Each alias is contained in a sub-element called Alias, with one attribute called name.

Columns

References the presentation columns that belong to this presentation table.

Each presentation column is contained in a sub-element called RefPresentationColumn.

Syntax

<PresentationTable …
     hasDispName=""
     dispName=""
     hasDispDescription=""
     dispDescription=""/>
   <Aliases>
     <Alias name=""/>
     <Alias name=""/>
   </Aliases>
   <Columns>
     <RefPresentationColumn …/>
   </Columns>
</PresentationTable>

Example

<PresentationTable name="Time"
     parentName="&quot;Sample App Reduced&quot;.&quot;&quot;"
     parentId="4004:2137"
     parentUid="73609"
     id="4008:2139"
     uid="73611"
     hasDispName="false"
     hasDispDescription="false">
   <Description>
     <![CDATA[ Time dimension attributes and time calculations objects ]]> 
   </Description>
   <Aliases>
     <Alias name="D0 Time" /> 
   </Aliases>
   <Columns>
     <RefPresentationColumn uid="72783" id="4010:1681" qualifiedName=
     "&quot;Sample App Reduced&quot;..&quot;Time&quot;.&quot;Day Date&quot;" /> 
     <RefPresentationColumn uid="72791" id="4010:1682" qualifiedName=
     "&quot;Sample App Reduced&quot;..&quot;Time&quot;.&quot;Week&quot;" /> 
     <RefPresentationColumn uid="72787" id="4010:1683" qualifiedName=
     "&quot;Sample App Reduced&quot;..&quot;Time&quot;.&quot;Month&quot;" /> 
     <RefPresentationColumn uid="72789" id="4010:1684" qualifiedName=
     "&quot;Sample App Reduced&quot;..&quot;Time&quot;.&quot;Quarter&quot;" /> 
     <RefPresentationColumn uid="72793" id="4010:1685" qualifiedName=
     "&quot;Sample App Reduced&quot;..&quot;Time&quot;.&quot;Year&quot;" /> 
   </Columns>
</PresentationTable>

15.4 Presentation Column

The presentation column element corresponds to the presentation column object in the Presentation layer.

The presentation column tag includes the following attributes:

Table 15-5 Presentation Column Tag Attributes

Attribute Name	Description
overrideLogicalName	Indicates whether the presentation column has been configured to always use the logical column name. This option corresponds to Use Logical Column Name in the Administration Tool. A `false` value for this attribute indicates that this option has been selected.
hasDispName	Indicates whether this presentation column has a custom display name.
dispName	The value of the custom display name, if one exists for this presentation column.
hasDispDescription	Indicates whether this presentation column has a custom description.
dispDescription	The value of the custom description, if one exists for this presentation column.

The presentation column tag includes the following child elements:

Table 15-6 Presentation Column Child Elements

Attribute Name Description

Attribute Name	Description
RefLogicalColumn	References the logical column upon which this presentation column is based.
Aliases	Lists any aliases that have been defined for this presentation column. Aliases are created when presentation objects are renamed to ensure that any references to the old names still work in logical SQL queries. Each alias is contained in a sub-element called `Alias`, with one attribute called `name`.

RefLogicalColumn

References the logical column upon which this presentation column is based.

Aliases

Lists any aliases that have been defined for this presentation column. Aliases are created when presentation objects are renamed to ensure that any references to the old names still work in logical SQL queries.

Each alias is contained in a sub-element called Alias, with one attribute called name.

Syntax

<PresentationColumn …
     overideLogicalName=""
     hasDispName=""
     dispName=""
     hasDispDescription=""
     dispDescription=""/>
   <RefLogicalColumn …/>
   <Aliases>
     <Alias name=""/>
     <Alias name=""/>
   </Aliases>
</PresentationColumn>

Example

<PresentationColumn name="Customer Name"
     parentName="&quot;Sample App Reduced&quot;..&quot;Customers&quot;"
     parentId="4008:2140"
     parentUid="73615"
     id="4010:1686"
     uid="72845"
     hasDispName="false"
     hasDispDescription="false"
     overrideLogicalName="true">
   <Description>
     <![CDATA[ Help : Customer Name stores the first name followed by the last
     name.]]> 
   </Description>
   <RefLogicalColumn uid="782" id="2006:24" qualifiedName="&quot;Sample 
   Sales&quot;.&quot;D1 Customer&quot;.&quot;C1 Cust Name&quot;" /> 
   <Aliases>
     <Alias name="L2 Customer Name" /> 
   </Aliases>
</PresentationColumn>

15.5 Presentation Hierarchy

The presentation hierarchy element corresponds to the presentation hierarchy object in the Presentation layer.

The presentation hierarchy tag includes the following attributes:

Table 15-7 Presentation Hierarchy Tag Attributes

Attribute Name	Description
hasDispName	Indicates whether this presentation hierarchy has a custom display name.
dispName	The value of the custom display name, if one exists for this presentation hierarchy.
hasDispDescription	Indicates whether this presentation hierarchy has a custom description.
dispDescription	The value of the custom description, if one exists for this presentation hierarchy.

The presentation hierarchy tag includes the following child elements:

Table 15-8 Presentation Hierarchy Child Elements

Element Name	Description
Levels	References the presentation levels for this presentation hierarchy. Each presentation level is contained in a sub-element called RefPresentationLevel.
Aliases	Lists any aliases that have been defined for this presentation hierarchy. Aliases are created when presentation objects are renamed to ensure that any references to the old names still work in logical SQL queries. Each alias is contained in a sub-element called `Alias`, with one attribute called `name`.
DisplayColumns	For parent-child hierarchies only. This element references the columns designated to be used for display for this parent-child hierarchy. Each display column is contained in a sub-element called `RefPresentationColumn`.
Dimension	References the logical dimension upon which this presentation hierarchy is based. The dimension is contained in a sub-element called `RefDimension`.

Syntax

<PresentationHierarchy …
     hasDisplayName=""
     displayName=""
     hasDispDescription=""
     dispDescription=""/>
   <Levels>
     <RefPresentationLevel …/>
   </Levels>
   <Aliases>
     <Alias name=""/>
     <Alias name=""/>
   </Aliases>
   <DisplayColumns>
     <RefPresentationColumn …/>
   </DisplayColumns>
   <Dimension>
     <RefDimension …/>
   </Dimension>
</PresentationHierarchy>

Example

<PresentationHierarchy name="Product"
     parentName="&quot;Sample App Reduced&quot;..&quot;Product&quot;"
     parentId="4008:39335"
     parentUid="2160738998"
     id="4028:39336"
     uid="2160738999"
     hasDispName="false"
     hasDispDescription="false">
   <Description /> 
   <Levels>
     <RefPresentationLevel uid="2160739000" id="4030:39337" qualifiedName=
     "&quot;Sample App Reduced&quot;..&quot;Product&quot;.&quot;Product&quot;.
     &quot;Total&quot;" /> 
     <RefPresentationLevel uid="2160739001" id="4030:39338" qualifiedName=
     "&quot;Sample App Reduced&quot;..&quot;Product&quot;.&quot;Product&quot;.
     &quot;Brand&quot;" /> 
     <RefPresentationLevel uid="2160739002" id="4030:39339" qualifiedName=
     "&quot;Sample App Reduced&quot;..&quot;Product&quot;.&quot;Product&quot;.
     &quot;LOB&quot;" /> 
     <RefPresentationLevel uid="2160739003" id="4030:39340" qualifiedName=
     "&quot;Sample App Reduced&quot;..&quot;Product&quot;.&quot;Product&quot;.
     &quot;Type&quot;" /> 
     <RefPresentationLevel uid="2160739004" id="4030:39341" qualifiedName=
     "&quot;Sample App Reduced&quot;..&quot;Product&quot;.&quot;Product&quot;.
     &quot;Detail Product&quot;" /> 
   </Levels>
   <Aliases>
     <Alias name="H4 Product" /> 
   </Aliases>
   <Dimension>
     <RefDimension uid="1674" id="2019:18" qualifiedName=
     "&quot;Sample Sales&quot;.&quot;H4 Product&quot;"/> 
   </Dimension>
</PresentationHierarchy>

15.6 Presentation Level

The presentation level element corresponds to the presentation level object in the Presentation layer.

The presentation level tag includes the following attributes:

Table 15-9 Presentation Level Tag Attributes

Attribute Name	Description
hasDispName	Indicates whether this presentation level has a custom display name.
dispName	The value of the custom display name, if one exists for this presentation level.
hasDispDescription	Indicates whether this presentation level has a custom description.
dispDescription	The value of the custom description, if one exists for this presentation level.

The presentation level tag includes the following child elements:

Table 15-10 Presentation Level Child Elements

Element Name	Description
RefLogicalLevel	References the logical level upon which this presentation level is based.
DrillTo	This option is reserved for a future release and is not currently used.
DisplayColumns	References the columns that have been designated to be used for display for this presentation level (on drill-down). Each column is contained in a sub-element called `RefPresentationColumn`.
Aliases	Lists any aliases that have been defined for this presentation level. Aliases are created when presentation objects are renamed to ensure that any references to the old names still work in logical SQL queries. Each alias is contained in a sub-element called `Alias`, with one attribute called `name`.

Syntax

<PresentationLevel …
     hasDisplayName=""
     displayName=""
     hasDispDescription=""
     dispDescription=""/>
   <RefLogicalLevel …/>
   <DrillTo>
     <RefPresentationLevel …/>
     <RefPresentationLevel …/>
   </DrillTo>
   <DisplayColumns>
     <RefPresentationColumn …/>
     <RefPresentationColumn …/>
   </DisplayColumns>
   <Aliases>
     <Alias name=""/>
     <Alias name=""/>
   </Aliases>
</PresentationLevel>

Example

<PresentationLevel name="Total"
     parentName="&quot;Sample App Reduced&quot;..&quot;Product&quot;.
     &quot;Product&quot;" parentId="4028:39336" parentUid="2160738999"      id="4030:39337" uid="2160739000"
     hasDispName="false"
     hasDispDescription="false">
   <Description></Description>
   <RefLogicalLevel uid="1683" id="2025:558" qualifiedName="&quot;Sample 
   Sales&quot;.&quot;H4 Product&quot;.&quot;Total&quot;"/>
</PresentationLevel>