PublishView function for IBM Planning Analytics (TM1)

Where can the PublishView function be used?

TurboIntegrator

Which TM1 Server version is the PublishView function available for?

Version 11 and 12

What is the syntax for PublishView?

PublishView(CubeName, ViewName, PublishPrivateSubsets, OverwriteExistingView)

• CubeName = Name of the parent cube of the view to be published.​
• ViewName = Name of the view to be published.​
• PublishPrivateSubsets = Boolean value to publish or not view private subsets.​
  • A view cannot be published if any of its subsets are private. If the function is used with this parameter set to 0 and there is a private subset on the view, TM1 will return an error​
  • If any subset on the view has a user-defined consolidation (private roll-up), it is not possible to publish the view, therefore the TM1 will return an error, no matter the parameter value​
• OverwriteExistingView = Boolean value determining if the private view should overwrite an existing view with the same name when published. If the value is set to 0 and there is a public view with the same name as the view to be published, TM1 will return an error.

Relevant Functions

• 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
• PublishView = Converts a private subset to public
• 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