TopLevelCategory Property (Explorer)

Returns the name of the dimension for the collection.

Syntax

collection.TopLevelCategory

Applies To

Columns

Layers

Rows

Discussion

Use this property to determine the name of the dimension that the selected categories belong to in a report. By returning the dimension name, you can identify data on a specific portion of a business, such as products, dates, or markets.

This property applies to Explorer reports only.

Type

String

Access

Read

Example

This example issues a message box telling the user which dimensions the rows and columns of the open Explorer report are from.

Sub Main()
   Dim objPPRep As Object
   Dim objRows As Object
   Dim objCols As Object
   Set objPPRep = GetObject (,"CognosPowerPlay.Report")
   Set objRows = objPPRep.Rows
   Set objCols = objPPRep.Columns
   MsgBox "Rows are from dimension: " _
      &objRows.TopLevelCategory 
   MsgBox "Columns are from dimension: " _
      &objCols.TopLevelCategory
   Set objRows = Nothing
   Set objCols = Nothing
   Set objPPRep = Nothing
End Sub

Related Topics