As we've seen in part 1, we can manage data in memory using individual
variables. However, often you need to handle multiple elements in a
similar manner: you might want to retrieve all base members under a
particular Account, or check parameters pas...
Can I use different FX rates in my budget compared to actuals? Will I
need to keep the data in different cubes? You will not need a separate
cube just to have different FX rates for different scenarios. On any
specific scenario, you can set up an FX ...
If you want to unlock the full potential of the OneStream platform, you
want to learn a bit of VisualBasic.NET. Don't be scared! It's much
easier than it looks. We'll now cover the basics (lol) of the language,
in a short series of posts. First, a ge...
Hi, could you try to use this if statement (it worked for me) (|WFTime|
Contains M2) or (|WFTime| Contains M3) or (|WFTime| Contains M5) or
(|WFTime| Contains M6) or (|WFTime| Contains M8) or (|WFTime| Contains
M9) or (|WFTime| Contains M11) or (|WFT...
Hi Julia, your issue is similar in a way that you have formulas in both
the rows and the columns? And you would like the column calculation to
override the row calculation? In this case, you can use a row override
on your column like in my example: P...
I have not used substitution variables in my example, I simply put the
name of the account (CV account or MF account would give me the account
specified on the cube view POV instead of the one on my override