Description Usage Arguments Examples
Returns mdx as a string to use in the function tm1_get_mdx_view
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | 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 )
|
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 |
1 2 3 4 5 6 7 8 9 | ## 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)
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.