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 b...
Forum Discussion
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.
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
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
