ViewMDXSet

ViewMDXSet sets the MDX expression for an existing MDX view.

This function is valid in TM1® TurboIntegrator processes only.

Syntax

ViewMDXSet(Cube, ViewName, MDX_expression);

Argument	Description
Cube	The parent cube of the view you are creating.
ViewName	The name you want to assign to the view.
MDX_expression	A string value containing a valid MDX view expression.

Example


ViewMDXSet('Sales', 'Account', 
    "select {[plan_version].[FY 2003 Budget]} on 0,
    {[plan_business_unit].[10300]} on 1 from plan_budgetplan where
    [plan_department].[200][plan_chart_of_accounts].[41101][plan_exchange_rates].[local][plan_source].[goal][plan_time].[Jan-2003]"
    );

This example sets the MDX expression for the Account view from the Sales cube.