Using R in icCube MDX+, how to pass and retreive an array?

user_2882924 0
Viewed 50

you can use R functions in icCube as demoed on https://www.iccube.com/support/documentation/mdx_integration/r_integration.php

I need to invoke a more complex custom R script that does a calculation on a matrix that I want to provide. The result should be a vector.

Example: - Matrix: projects with measures: total weeks, hours/week - Vector: (in same order as projects): start week

Is that possible, and how is the syntax to do this from MDX?

iccube mdx r
1 Answers

Something like this, R_RandomgVector is generating a vector of random values of the size defined by the parameter. The member TEST is just returning the lenght of the returned vector. I guess v_ can be a matrix, transformed in the R function and return a vector as here

WITH
    NATIVE FUNCTION R_RandomVector(Value v_) AS
        /* R    

          round(runif(v_,0,1), 2)    
        */
    MEMBER TEST as R_RandomVector(100)->length()
SELECT
  TEST on 0
FROM [Sales]

and with a matrix

WITH
    NATIVE FUNCTION R_RandomVector(Value v_) AS
        /* R

          t( v_ %*% runif( nrow(v_) ,0,1) )

        */
    MEMBER TEST as R_RandomVector( Matrix([Product].[Product].[Article],[Product].[Product].[Article], [Measures].[Count])  )
SELECT
  TEST on 0
FROM [Sales]
user_7637900
Related