Using a cube view as a data source

You can define a cube view as a data source.

To do so, see Create a cube process to define the data source, then follow the procedures described in "Importing a Text File".

You can also create a cube view using MDX expressions and use the MDX-based view as a TurboIntegrator data source. The following shows the column ordering to apply in a MDX-based view:

member1, member1_prop1, member1_prop2, ..., member1_propN, member2, member2_prop1, ..., memberN_propN, cell_prop1, cell_prop2, ..., cell_propN, cell_value

Note: The definition uses the _prop notation to reference MDX dimension or cell properties, which are explicitly requested in the MDX query string.

The ViewCreateByMDX, ViewMDXSet, and ViewMDXGet TurboIntegrator functions are available to work with MDX views. For information on these functions, refer to the TM1 Reference documentation.