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:

    cnnstr="Provider=MSOLAP;Password=mr0m3r0;Persist Security Info=True;User ID=sispro.local\\mromero;Data;Initial Catalog=SGD_CUBOS"
    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