TM1RPTVIEW

TM1RPTVIEW defines the view displayed in a Dynamic Report.

Syntax

TM1RPTVIEW(ViewID,ZeroSuppression,TM1RPTTITLE,...)

Argument	Description	Required/Optional
ViewID	A name for the view using the format `server:cube:unique_id`.	Required
ZeroSuppression	A Boolean flag to turn on or off the zero suppression property for the view. 1 = on, 0 = off	Required
TM1RPTTITLE	For each title dimension in the Dynamic Report, include a reference to a TM1RPTTITLE function as an argument to TM1RPTVIEW.	Required
FormatRange	The formatting range for the Dynamic Report. You can use a cell reference or a named range for this parameter. When you create a Dynamic Report, a named range called TM1RPTFMTRNG is created to include all formatting range cells. You can use this named range as an argument.	Required
IDColumn	The column in the Dynamic Report that contains format IDs. You can use a cell reference or a named range for this parameter. When you create a Dynamic Report, a named range called TM1RPTFMTIDCOL is created to include all formatting range cells. You can use this named range as an argument.	Required

Example

TM1RPTVIEW("SData:SalesCube:6", 0, TM1RPTTITLE("SData:actvsbud",$C$6), 
TM1RPTTITLE("SData:model",$C$7), TM1RPTTITLE("SData:account1",$C$8), 
TM1RPTFMTRNG,TM1RPTFMTIDCOL)