Forum Discussion

SaurinPatel's avatar
SaurinPatel
New Contributor III
2 years ago

CubeView Parameters

Is it possible to use Cubeview Parameters in XFGetCell ?

 

Saurin

  • JackLacava's avatar
    JackLacava
    Honored Contributor

    XFGetCell is an Excel function that goes to OneStream and retrieves a number. It doesn't know anything about CubeViews.

    What you probably want is XFGetDashboardParameterValue. From the page "Retrieve Function" in Design and Reference Guide: 
    This function is available to Excel Add-in and Spreadsheet. If that function is used within an XLSX file that is using a function like XFGetCell or XFSetCell (or similar) where these are referencing a custom parameter value (e.g. ParamEntity) that is on the Dashboard that references this Spreadsheet from within it as a Component. The practice to get this Custom Parameter value is to use XFGetDashboardParameterValue to fetch the text from that Parameter or its default value and place it in a cell on the Spreadsheet (e.g. B1). Then the cell that is using a retrieve function such as XFGetCell would reference this other cell (i.e. B1).

    XFGetDashboardParameterValue("myParamName", "Text For Default Value")

    • SaurinPatel's avatar
      SaurinPatel
      New Contributor III

      JackLacava I am new OneStream user so I might be wrong here but yesterday I tried using Cubeview parameter in XFGetCell function and it did work. I have XFGetCell function which point to my parameter page and where I was able to use |!CurFC!| and pull data. 

      Saurin Patel

      TransUnion

       

      • sudarshan's avatar
        sudarshan
        New Contributor III

        Hi Saurin,

        Can you share the syntax of how you were able to do this?