"Hey boss, look a this Cube View I made - it shows our EUR Fx rates
against all currencies in our app. Cool, uh?" "FX rates we loaded last
month aren't cool. You know what's cool?" "... You?" "Real-time FX
rates." Alright boss, let's get rich compete...
The system looks for formulas on members of the Point of View in this
order: Account -> Flow -> UD1 -> UD2 -> UD3 -> UD4 -> UD5 -> UD6 -> UD7
-> UD8. As soon as a formula is found and executed, the process stops.
So if you placed a formula on the Acc...
SQL: cross and delight of the IT revolution. If you've been in the game
for more than a few years, chances are that you got your hands dirty
with database queries once or thrice. OneStream itself keeps data in a
SQL database, and as much as we try to...
The CPM world has traditionally allowed users to define custom lists of
members in code, which is very useful when built-in expansions are not
enough for their needs. This is a fairly rare occurrence in OneStream,
because of the superior power of its...
Right click on the cell and select Cell Status. That should indicate how
that data was obtained, and as @TimVierhout said, a grey value is
typically derived. It's hard to say more without seeing the Account
settings, the Scenario settings, and the ca...
Display Components linked to Parameters are evaluated at display time,
so you need a dashboard refresh to get things like Labels to update once
you change their value. Seems to work here in v.7.4.2. Configuration:
Button to trigger refresh and page c...
Did you mean "is there a page where one can set all the formatting
options for all cube views in an application"? If so, the answer is no.
Defaults are set in the application code. If you think this would be a
useful feature, please request it in Ide...
That's straightforward, what you're looking for is Derivative Rules.
This example will duplicate all values coming from Account 10999 into
another account called Test.
Yes, sorry, i forgot the second half of the technique, which is to
couple that with an icon-only Button (for example ) to trigger the
drilldown. To be fair, a similar approach can be taken with BiViewer, it
just tends to be a little more disjointed...
