Forum Discussion

ssmith-nova's avatar
ssmith-nova
Contributor
27 days ago
Solved

FDXExecuteCubeView with Consol filter

Hi All,

How would I go about passing a Consol member as part of the POV to a  FDXExecuteCubeView call? I want to pull one extract that is in Local currency and another that is in USD.  Can I do that with this call, or do I need to set up 2 cube views, one set to Local and another set to YTD?

Thanks,

Scott

Data Integration
  • sameburn's avatar
    sameburn
    22 days ago
    Dim csv As String = "Key1=Value1,Key2=Value2"
Dim nvfb As New NameValueFormatBuilder(csv)

     

3 Replies

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    26 days ago
    1. create your cube view using a Parameter in the Cons member on general POV
    2. execute FDXExecuteCubeView twice, each time setting the parameter to a different value - you do that by including it in the "nvbParams" dictionary that is passed to the function, each time with a different Value.
    • ssmith-nova's avatar
      ssmith-nova
      Contributor
      23 days ago

      Would you have an example setting up the dictionary handy?

      • sameburn's avatar
        sameburn
        Icon for OneStream Employee rankOneStream Employee
        22 days ago
        Dim csv As String = "Key1=Value1,Key2=Value2"
Dim nvfb As New NameValueFormatBuilder(csv)