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
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 ...
JackLacava
OneStream Employee
OneStream EmployeeIt's actually super-simple, we just didn't have documentation on it for some time. But now we do!
Have a look at https://documentation.onestream.com/release_8.2/Content/BI%20Viewer/BI%20Viewer%20Tabs.html, particularly the two sections on Parameter Name Value Pairs. It has examples and all. Should work fine on 7.x releases and above, I don't know about 6.x.
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
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!|