PublishView function for IBM Planning Analytics (TM1)

Where can the PublishView function be used?

Which TM1 Server version is the PublishView function available for?

What is the syntax for PublishView?

• 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