Forum Discussion

NoorMohd's avatar
NoorMohd
New Contributor
8 days ago

Export Data of Selected Parameter

Hi All,

 

I am trying to create the dashboard where I pass all dimension from combo box to button taht triggers the DM sequence that has the Export Data step.

I get the following error mentioned below.

 

 

 

 

 

FYI  please see the screenshot of the export data step mentioned below.

 

 

 

 

 

 

 

 

 

 

 

 

 

Can someone please help where I am going wrong please help  me with the approach.

 

 

Thank you 

 

 

Application Properties
Consolidation
Cubes
Extensibility
User Interface
  • NoorMohd's avatar
    NoorMohd
    New Contributor
    7 days ago

    Thanks Sam

     

    I did try using the [] still no use however I have made some changes in the DM step using something like this E#Root.List(|!Entity!|) this will catch all the options I have select and produces the result as expected.

    Thanks again Sam

  • sameburn's avatar
    sameburn
    Contributor III
    7 days ago

    Hi NoorMohd 

    I suspect that is because you are passing in comma separated values via your Multi-Select component.

    This means you need to catch the value of your parameter in square brackets e.g. Entity = [|!Param_Entity_J1!|].

    This will catch all of your selections rather than the first one only

    Sam

  • NoorMohd's avatar
    NoorMohd
    New Contributor
    7 days ago

    Thanks Sam for the update.

    I did as suggest it works fine now however now I have an issue of Multiple select I am selecting multiple members to extract the data but I am able to get the data for only first selection 

  • triley1844's avatar
    triley1844
    New Contributor
    7 days ago

    Check the parameter value being passed, my guess it's missing the E# dimension tag for the entity.  I would assume you would get a similar error for the other dimensions, but it's probably processing the entity first and erroring out.

    I think you should be able to add the E# before your parameter reference in the DM job filter box - E#|!Param_Entity_J1!| and that should work.  If you're not passing the dimension tag as part of the parameter, you would need to do this for each one.

    • NoorMohd's avatar
      NoorMohd
      New Contributor
      7 days ago

      Thank you so much for the update.

      Indeed, I did try that however the error is same I tried using the variable name with the parameter syntax that worked 

      • sameburn's avatar
        sameburn
        Contributor III
        7 days ago

        Hi NoorMohd

        I think this is to do with your NameValuePairs. 

        You are passing NameValuePairs to your button e.g Entity = |!Param_Entity_J1!|

        Then you are expecting to pass the same NameValuePairs to your DM sequence 

        However that requires a new set of NameValuePairs e g in example above your key becomes the value e.g |!Entity!|

        Probably the safest way to do this (to avoid confusion) is setup your NameValuePairs on the button to be Param_Entity_J1 = |!Param_Entity_J1!|

        This means your original logic on the DM step will work as you use the same parameter call on (a) the button and (b) the DM e.g |!Param_Entity_J1!|

        Also please add 1 parameter at a time, based on it working as expected. You have added a parameter for every dimension but it fails on the first one, which suggests all the other parameters might also fail for same reason

        Hope this clarifies

        Sam