none
olapR query returns null object RRS feed

  • Question

  •  have been using olapR (along with Microsoft R Client, which you need in order to use olapR) to do MDX queries on a MSOLAP database.

    However, every time I execute any query it return a null object. I know these are not empty queries. Here is an example:

    library(olapR)
    
    cnnstr="Provider=MSOLAP;Password=mr0m3r0;Persist Security Info=True;User ID=sispro.local\\mromero;Data Source=cubos.sispro.gov.co;Initial Catalog=SGD_CUBOS"
    
    olapCnn=OlapConnection(cnnstr)
    
    qry <- Query(validate = TRUE)
    
    cube(qry) <- "PER - Prestación Servicios de Salud"
    columns(qry) <- c("[Measures].[Número Personas Atendidas]")
    rows(qry) <- c("[Diagnóstico Principal].[Diagnósticos].[Diagnósticos].MEMBERS") 
    
    results1=executeMD(olapCnn, qry)

    The problem is results1 is NULL. Note that explore works well and therefore I don't think this is a tabular model issue

    • Edited by mtromero Wednesday, March 1, 2017 1:17 PM repeated
    Wednesday, March 1, 2017 1:15 PM

All replies

  • Another issue: If i use execute2D instead I get the following error:

    Unknown object recieved from olapRExecuteRecordset

    which is just a consequence of the object being return is NULL



    • Edited by mtromero Wednesday, March 1, 2017 2:17 PM
    Wednesday, March 1, 2017 2:12 PM