ViewCreateByMDX function for IBM Planning Analytics (TM1)

Where can the ViewCreateByMDX function be used?

Which TM1 Server version is the ViewCreateByMDX function available for?

What is the syntax for ViewCreateByMDX?

• CubeName = Cube Name​
• ViewName = View Name​
• MDX_Expression = a string value that has the MDX expression​
• AsTemporary = Optional binary flag to set the view as temporary. If nothing is set, the view will be permanent by default.

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