tm1r (version 1.1.8)

tm1_create_mdx: TM1 Generate mdx for a cube view

Description

Returns mdx as a string to use in the function tm1_get_mdx_view

Usage

tm1_create_mdx(cube,
                             rowdim1, rowsub1, rowel1,
                             rowdim2, rowsub2, rowel2,
                             rowdim3, rowsub3, rowel3,
                             coldim1, colsub1, colel1,
                             coldim2, colsub2, colel2,
                             titledim1, titleel1,
                             titledim2, titleel2,
                             titledim3, titleel3,
                             titledim4, titleel4,
                             titledim5, titleel5,
                             titledim6, titleel6,
                             titledim7, titleel7,
                             titledim8, titleel8,
                             titledim9, titleel9,
                             titledim10, titleel10,
                             rowsuppress, colsuppress )

Arguments

cube

Name of the cube

rowdim1

Name of dimension in 1st row

rowsub1

Subset of dimension in 1st row

rowel1

Element of dimension in 1st row. If multiple, seperated by "|". This should be passed if subset is not provided

rowdim2

Name of dimension in 2nd row

rowsub2

Subset of dimension in 2nd row

rowel2

Element of dimension in 2nd row. If multiple, seperated by "|". This should be passed if subset is not provided

rowdim3

Name of dimension in 3rd row

rowsub3

Subset of dimension in 3rd row

rowel3

Element of dimension in 3rd row. If multiple, seperated by "|". This should be passed if subset is not provided

coldim1

Name of dimension in 1st col

colsub1

Subset of dimension in 1st col

colel1

Element of dimension in 1st col. If multiple, seperated by "|". This should be passed if subset is not provided

coldim2

Name of dimension in 2nd col

colsub2

Subset of dimension in 2nd col

colel2

Element of dimension in 2nd col. If multiple, seperated by "|". This should be passed if subset is not provided

titledim1

Name of dimension in title

titleel1

Element of dimension in corresponding titledim

titledim2

Name of dimension in title

titleel2

Element of dimension in corresponding titledim

titledim3

Name of dimension in title

titleel3

Element of dimension in corresponding titledim

titledim4

Name of dimension in title

titleel4

Element of dimension in corresponding titledim

titledim5

Name of dimension in title

titleel5

Element of dimension in corresponding titledim

titledim6

Name of dimension in title

titleel6

Element of dimension in corresponding titledim

titledim7

Name of dimension in title

titleel7

Element of dimension in corresponding titledim

titledim8

Name of dimension in title

titleel8

Element of dimension in corresponding titledim

titledim9

Name of dimension in title

titleel9

Element of dimension in corresponding titledim

titledim10

Name of dimension in title

titleel10

Element of dimension in corresponding titledim

rowsuppress

TRUE if zeroes are suppressed on rows

colsuppress

TRUE if zeroes are suppressed on columns

Examples

# NOT RUN {
tm1_create_mdx( "SalesCube", rowdim1="account1", rowel1 = "Sales", coldim1="month", colel1="Jan",
titledim1 = "actvsbud", titleel1 = "Actual",
titledim2 = "region", titleel2 = "Argentina",
titledim3 = "model", titleel3 = "S Series 1.8 L Sedan",
rowsuppress=TRUE, colsuppress = FALSE)
# }
# NOT RUN {
# }