ViewExtractSkipZeroesSet function for IBM Planning Analytics (TM1)
ViewExtractSkipZeroesSet skips or includes zeros when exporting a view using ASCIIOutput. Use in the Prolog tab.
In the video, learn how to use ViewExtractSkipZeroesSet to export the view, By Year, from the Product Scorecard cube to exclude zeros then show the result when zeros are included.
Where can the ViewExtractSkipZeroesSet function be used?
TurboIntegrator
Which TM1 Server version is the ViewExtractSkipZeroesSet function available for?
Version 11 and 12
What is the syntax for ViewExtractSkipZeroesSet?
ViewExtractSkipZeroesSet(CubeName, ViewName, Flag)
- CubeName = Name of the cube
- ViewName = Name of the view from the cube
- Flag = Boolean flag. 1 to skip strings on consolidated values or 0 to include.
Relevant Functions
- AsciiDelete: Deletes an ASCII file
- AsciiOutputOpen: Appends or overwrites content in a specified existing file that you would use in conjunction with functions that write to a file like AsciiOutput and TextOutput.
- AsciiOutput: writes data to a file to a directory the TM1 Server can access, using data sources from a cube, an ODBC source or no data sources.
- DatasourceAsciiDecimalSeperator: Sets the decimal separator
- DatasourceAsciiDelimiter: Sets the delimiter
- DatasourceASCIIHeaderRecords: sets the header records for a text file.
- DatasourceAsciiQuoteCharacter: Sets the quote character
- DatasourceASCIIThousandSeparator: sets the thousand separator for a text file.
- DatasourceCubeview: sets the cube view in the data source.
- DatasourceDimensionSubset: sets the dimension subset in the data source.
- DatasourceNameForClient: sets the name of the data source from the client’s perspective when creating or editing the process.
- DatasourceNameForServer: sets the name of the data source.
- DatasourcePassword: sets the password used for the data source
- DatasourceQuery: sets query for the data source
- DatasourceType: sets the type used for the data source
- DatasourceUsername: sets the name used to connect to the data source
- DatasourceODBOCatalog: sets the name of the ODBO database collection that you want to connect.
- DatasourceODBOConnectionString: sets the connection parameters required to connect to the OLAP server.
- DatasourceODBOCubeName: sets the cube name you want to connect to from the OLAP Server.
- DatasourceODBOHierarchyName: This function is used for OLAP products like SAP BW and sets the name of the hierarchy from a dimension.
- DatasourceODBOLocation: sets the name of the OLAP server’s location.
- DatasourceODBOProvider: sets the name of the ODBO provider installed on your server.
- DatasourceODBOSAPClientID: sets the client ID that connects to the SAP Server.
- DatasourceODBOSAPClientLanguage: sets the language specification from the SAP Server.
- DisableMTQViewConstruct = Disables multi-threaded query processing in a process that uses a cube view as the datasource
- EnableMTQViewConstruct = Enables multi-threaded query processing in a process that uses a cube view as the datasource
- NumberToString: convert a number to a string
- NumberToStringEx: Convert a numeric value into a string based on a specific numeric format string
- PublishView = Converts a private subset to public
- SetInputCharacterSet: Specify the encoding used in the data source.
- SetOutputCharacterSet: specifies the character set when writing to a text file using TextOutput.
- SetOutputEscapeDoubleQuote: Retains or removes double quotes when outputting element names or data values to a text file
- STR: convert a number to a string
- TextOutput: Writes and generates a text file in the specified path
- ViewColumnDimensionSet = Sets the dimension in a column position for a cube view
- ViewColumnSuppressZeroesSet = Hide or display columns containing zero values in a cube view
- ViewConstruct = Pre-calculates a view and stores the view in memory for faster access
- ViewCreate = ViewCreate creates an empty view for a cube
- ViewCreateByMDX = Creates a cube view with an MDX expression
- ViewDestroy = Deletes cube view
- ViewExists = Checks whether a view exists
- ViewExtractFilterByTitlesSet: Skip or include elements in the title axis when exporting a view using ASCIIOutput.
- ViewExtractSkipCalcsSet: Skip or include consolidated values when exporting a view using ASCIIOutput.
- ViewExtractSkipConsolidatedStringsSet: Skip or include strings on consolidated values when exporting a view using ASCIIOutput.
- ViewExtractSkipRuleValuesSet: Skip or include ruled values when exporting a view using ASCIIOutput.
- ViewExtractSkipZeroesSet: Skip or include zeros when exporting a view using ASCIIOutput.
- ViewMDXGet = Retrieves the MDX expression for a cube view
- ViewMDXSet = Sets the MDX expression for a cube view
- ViewRowDimensionSet = Sets the row for a cube view
- ViewRowSuppressZeroesSet = Hides or displays rows containing zero values in a cube view
- ViewSubsetAssign = Assigns a named subset in a view
- ViewSuppressZeroesSet = Hides or displays all rows and columns containing zero values in a cube view
- ViewTitleDimensionSet = Set a dimension to the title position for a cube view
- ViewTitleElementSet = Sets an element to a dimension in the title position for a cube view
- ViewZeroOut = Zeroes out all data to a cube view