Report 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 being used in the CV report.
-They parameters do not appear to be part of a bound parameter or linked cube view as I extracted all reports and performed a lookup and I wasn't able to locate them.
Here are some examples:
|!account!|
|!entity_Var!|
|!scenario_Var_2!|
The odd thing is the parameters worked in my local application. The prompt the report gave when running is simply “account” for the Account-related parameter. Has anybody seen these before? Are they system generated?
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.