Type (Property)

Applies To:

Application object, Bullet object, (Live) BarChart object, (Live) BlockChart object, EventScript object,. EmbeddedBrowser object, (Live) FunnelChart object, HyperLink object, Join object, JoinsOptions object, (Live) LineChart object, (Live) PieChart object, PivotSection object ,(Live) RadarChart object, (CubeQuery) QuerySection object, QuerySection, ReportSection object, Section object, Speedometer object, Shape object, Slider object, Thermometer object, Toolbar object, Topic object, TrafficLight object

Description:

Returns the type value of these objects:

Section Objects—Represents the type of section. (Chart, Pivot, Query, etc.)
Join—Refers to the type of join. (Left, right, Outer, etc.)
Toolbar—Rpresents the type of toolbar. (Standard, format, etc.)
Topic—Represents type of topic. (Standard, Meta, etc.)
Shape—Represents the type of drawing object or control in an Dashboard section. (Line, Rectangle, etc.)
Joins Options —Represents the type of join option. (All Topics, Auto Join, etc.)
EventScript—Represents a read-only value of the enumeration BqScriptableEvents
allows for better performance when checking event types if this is required.

External Content– This property represents the type of shape for an Embedded Browser object or HyperLink object.

Note:

Do not use Toolbars[“Standard”].Type, Toolbars[“Formatting”].Type, Toolbars[“Sections”].Type, and Toolbars[“Navigation”].Type in Interactive Reporting documents to be deployed in the EPM Workspace.

Action:

Read-only

Constants:

Application object —BqAppType

bqAppTypeDesktopClient
bqAppTypePlugInClient
bqAppTypeScheduler
bqAppTypeThinClient

Section Objects —BqSectionType

bqChart
bqCubeQuery
bqDataModel
bqDashboard
bqOLAPQuery
bqPivot
bqQuery
bqReport
bqResults
bqTable

Join—BqJoinType

bqDataModelJoinsOptionAllTopics
bqDataModelJoinsOptionAutoJoin
bqDataModelJoinsOptionDefJoin
bqDataModelJoinsOptionMinTopics
bqDataModelJoinsOptionRefTopics

bqJoinLeft
bqJoinOuter
bqJoinRight
bqJoinSimpleEqual
bqJoinSimpleGreaterThan
bqJoinSimpleGreaterThanOREqual
bqJoinSimpleLessThan
bqJoinSimpleLessThanOrEqual
bqJoinSimpleNotEqual

Join Options—

Toolbar —BqToolbars

bqToolbarFormat
bqToolbarNavigation
bqToolbarSections
bqToolbarStandard

Topic—BqTopicType

bqTopicTypeMeta
bqTopicTypeNone
bqTopicTypeQueryObject
bqTopicTypeResults
bqTopicTypeStoredProcedure

Shape—BqShapeType

bqBullet
bqButton
bqCheckBox
bqDropBox
bqEmbeddedSection
bqEmbeddedBrowser
bqEmbeddedSection
bqHorizontalLine
bqHyperLink
bqLine
beListBox
bqLiveBarChart
bqLiveBlockChart
bqLiveFunnelChart
bqLiveLineChart
bqLivePieChart
bqLiveRadarChart
bqOval
bqPicture
bqRadioButton
bqRectangle
bqRoundRectangle
bqSlider
bqSpeedometer
bqTextBox
bqTextLabel
bqThermometer
bqTrafficLight
bqVerticalLine

JoinsOptions—BqDataModelJoinsOptions

bqDataModelJoinsOptionAllTopics
bqDataModelJoinsOptionAutoJoin
bqDataModelJoinsOptionDefJoin
bqDataModelJoinsOptionMinTopics
bqDataModelJoinsOptionRefTopics

EventScript object—BqScriptableEvents

bqScriptableEventsOnActivate
bqScriptableEventsOnCalculate
bqbqScriptableEventsOnCellDoubleClick
bqScriptableEventsOnChange
bqScriptableEventsOnClick
bqScriptableEventsOnClientClick
bqScriptableEventsOnClientEnter
bqScriptableEventsOnClientExit
bqScriptableEventsOnClientSelection
bqScriptableEventsOnDeactivate
bqScriptableEventsOnDoubleClick
bqScriptableEventsOnEnter
bqScriptableEventsOnExit
bqScriptableEventsOnPostProcess
bqScriptableEventsOnPreProcess
bqScriptableEventsOnRowDoubleClick
bqScriptableEventsOnSelection
bqScriptableEventsOnShutdown
bqScriptableEventsOnStartup

Example:

This example shows how to use the Type (Property) to determine which properties apply to a specific object. In this example, checking the Type (Property) of the Section objects allows the script to process every query in a document.

var SecCount = ActiveDocument.Sections.Count
for (j = 1; j <= SecCount ; j++)
     {
      if (ActiveDocument.Sections[j].Type == bqQuery)
            ActiveDocument.Sections[j].Process()
     }