The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Sarikap96's avatar
Sarikap96
New Contributor II
2 years ago

How to use dashboard parameters into BI-viewer calculated fields

Hi all, I have created some calculated fields into BI-viewer. I need to use the dashboard parameters into those calculation expressions as I have some calculations according to that. Any idea on how ...
BI Viewer
dashboards
Parameters
Sarikap96's avatar
Sarikap96
New Contributor II
2 years ago

Hello

Thank you for the response.

Here in my case, I need to give some calculation in BI-viewer expression using dashboard parameters. For Example: Time (Current year - Prior year). I have two parameters |!CurrYear!| & |!PriorYear!| as literal value in dashboard. 

Can we use them inside the calculation that is the concern.

 

 

 

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

You are almost there, just double-click on the parameter name to add it to the expression! 😅 It will appear in the expression as ?Parameter1  .

You can then wire it to Dashboard Parameters by setting the property Parameter Name Value Pairs in the Component Properties tab like this: Parameter1=|!CurYear!| . You can have multiple parameters set up there, separated by commas - eg. MyCurrYear=|!CurYear!|,MyNextYear=|!PriorYear!|