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
fc
11 months agoContributor
WfTime parameter not working in SQL table editor
Hi everyone,
I'm currently working on a dashboard that, through the use of a SQL table editor, will show data stored in a table. Below an example of one row from that table:
The interface of the SQL table editor allows me to filter the data to show only specific rows, and I added a filter for the columns T_ENTITY and PERIOD:
The first filter (T_ENTITY) works as expected. The second filter should filter out those rows in the table whose Period differs from the one selected by the user in the WF. Nevertheless, if I use |WFTime| as parameter, it doesn't show any row, even those that have the same Period as the WF. If I instead replace |WFTime| with the static period (es 'PERIOD = '2022M11'), it works fine.
The conclusion I take is that |WFTime| is not equal to the current WF period. To check that out, I added the following label to the dashboard header, setting its value equal to |WFTime|:
and it shows exactly the current WF period:
Is it possible that the parameter |WFTime| does not work as a filter for a SQL table editor? Or am I missing something?
Thanks in advance for the help!
Does having = '|WFText4|' and Period = '|WFTime|' work?
If that doesn't fix the issue you could create an XFBR string that accepts WFTime and WFText4 as variables, and then create the where clause in the xfbr.
3 Replies
- BenEppelContributor
Does having = '|WFText4|' and Period = '|WFTime|' work?
If that doesn't fix the issue you could create an XFBR string that accepts WFTime and WFText4 as variables, and then create the where clause in the xfbr.
- JackLacava
OneStream Employee
This. That WHERE is simply dropped into an SQL statement, so it needs to be quoted accordingly.
Reason #7492 to use Dynamic Grids instead...
- fcContributor
The solution was right there but it didn't cross my mind :)
Thank you both
Related Content
- 2 months ago
- 1 year ago
- 2 years ago