Skip to main content
N
NoorMohd
Newcomer
February 16, 2025

Export Data of Selected Parameter

  • February 16, 2025
  • 4 replies
  • 0 views

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 

 

 

4 replies

T
triley1844
Newcomer
February 17, 2025

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.

N
NoorMohdAuthor
Newcomer
February 17, 2025

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 

S
OneStream Employee
sameburnOneStream Employee
OneStream Employee
February 17, 2025

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

N
NoorMohdAuthor
Newcomer
February 17, 2025

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 

S
OneStream Employee
sameburnOneStream Employee
OneStream Employee
February 17, 2025

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

N
NoorMohdAuthor
Newcomer
February 17, 2025

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

Terms & ConditionsAccessibility statement