TM1 Function for TI, ViewExtractFilterByTitlesSet

Skip or include elements in the title axis when exporting a view using ASCIIOutput.

What is the ViewExtractFilterByTitlesSet function?

ViewExtractFilterByTitlesSet skips or includes elements in the title axis when exporting a view using ASCIIOutput. Use in the Prolog tab.

Where can the ViewExtractFilterByTitlesSet function be used?


What is the syntax for ViewExtractFilterByTitlesSet?

ViewExtractFilterByTitlesSet(CubeName, ViewName, FilterByTitles, Temporary)​;

​CubeName = Name of the cube​

ViewName = Name of the view from the cube​

FilterByTitles = Boolean flag. 1 to skip title elements not shown or 0 to include.​

Temporary = Boolean flag to set if the settings are temporary or not. 1 = temporary, 0 = not temporary.

A demonstration on how to use ViewExtractFilterByTitlesSet

Export the Summary view from the Product Scorecard cube and exclude title elements.