Skip to main content
S
ssmith-nova
January 29, 2026
Solved

FDXExecuteCubeView with Consol filter

  • January 29, 2026
  • 1 reply
  • 0 views

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

Best answer by sameburn
Dim csv As String = "Key1=Value1,Key2=Value2"
Dim nvfb As New NameValueFormatBuilder(csv)

 

1 reply

J
JackLacava
January 30, 2026
  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.
S
ssmith-novaAuthor
February 2, 2026

Would you have an example setting up the dictionary handy?

S
sameburnAnswer
February 3, 2026
Dim csv As String = "Key1=Value1,Key2=Value2"
Dim nvfb As New NameValueFormatBuilder(csv)

 

Terms & ConditionsAccessibility statement