tm1_create_view: TM1 Create View from mdx

In muhammedalionder/tm1r: The Integration Between 'IBM COGNOS TM1' and R

Description

Creates cube view with mdx

Usage

tm1_create_view(tm1_connection, cube, view, mdx)

Arguments

tm1_connection	tm1 connection object returned by the function tm1_connection
cube	Name of cube
view	Name of view to be created
mdx	MDX of view as a string

Examples

## Not run: 
mdx <- "SELECT
  NON EMPTY
   {[month].[Jan],[month].[Feb],[month].[Mar]}
  ON COLUMNS,
  NON EMPTY
     {[account1].[Price],[account1].[Units]}
  ON ROWS
 FROM [SalesCube]
 WHERE
  (
   [actvsbud].[actvsbud].[Actual],
   [region].[region].[Argentina],
   [model].[model].[S Series 1.8 L Sedan]
  )"
tm1_create_view(
  tm1_connection("localhost", "8881", "admin", "apple"),
  "SalesCube", "test", mdx)

con_obj <- tm1_connection("localhost", "8881", "admin", "apple")
tm1_create_view(con_obj, "SalesCube", "test", mdx)

## End(Not run)

muhammedalionder/tm1r documentation built on May 10, 2019, 1:19 a.m.