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
MichaelHahn
OneStream Employee
10 months agoReport Parameters Cannot be Located in App
An advanced customer has many Cube View reports using parameters that I cannot locate anywhere in their application.
-They parameters do not appear to be part of any XFBR because there are no BRs b...
- 10 months ago
These are dynamic, fill-in-the-blank parameters. They don't exist anywhere except when/where they are used. Then OneStream creates them on the fly by prompting the user by the name of the parameter.
You can literally type anything you want in between the |! !| in various parts of a CubeView, such as Row, Column, or POV, and what you typed in the |! !| will be what the user is prompted with when the CubeView is run.
I've seen things like |!Enter Time (YYYYMNN)!| used like this before and the user is required to type 2025M1 in the parameter prompt.
IMO They're to be avoided in practice. If a user is required to manually type in an entity name and cannot spell that name correctly, the report will not show data and usually the admin and/or support will get a call.
RobbSalzmann
10 months agoValued Contributor II
These are dynamic, fill-in-the-blank parameters. They don't exist anywhere except when/where they are used. Then OneStream creates them on the fly by prompting the user by the name of the parameter.
You can literally type anything you want in between the |! !| in various parts of a CubeView, such as Row, Column, or POV, and what you typed in the |! !| will be what the user is prompted with when the CubeView is run.
I've seen things like |!Enter Time (YYYYMNN)!| used like this before and the user is required to type 2025M1 in the parameter prompt.
IMO They're to be avoided in practice. If a user is required to manually type in an entity name and cannot spell that name correctly, the report will not show data and usually the admin and/or support will get a call.
- MichaelHahn10 months ago
OneStream Employee
I think this is the answer. I learned something new. Thank you!
Related Content
- 3 years ago
- 2 years ago