Forum Discussion

ssmith-nova's avatar
ssmith-nova
Contributor
4 days ago

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

2 Replies

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    3 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
      11 hours ago

      Would you have an example setting up the dictionary handy?