DimensionLine Method

Returns a DimensionLine object for the current Report object.

Syntax

Report.DimensionLine

Applies To

Report Object

Discussion

Use this method to find out where you are in the data as the dimension line shows the category used to filter the data from each dimension in the cube. For Explorer reports, the dimension line changes when you drill down or up, or when you filter out unnecessary information. For Reporter reports, the dimension line only changes when you use automation to filter out unnecessary information.

Use the DimensionLine object to get each individual dimension before setting up filters.

Return Type

Object

Example

This example changes two of the current categories for the DimensionLine object in the current report.

Sub Main()
   Dim objPPRep as Object
   Set objPPRep = GetObject ("C:\Cubes and Reports\Sample1.ppx")
   objPPRep.DimensionLine.Item("Years").Change("1997")
   objPPRep.DimensionLine.Item("Products").Change _
      ("Go Sport Line")
   objPPRep.Save
   Set objPPRep = Nothing
End Sub

Related Topics