OneStream Community

Noemi

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...

Noemi · 11-07-2023

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 ...

Noemi · 11-07-2023

In the grid setting, check the “Display Parent Child Relationship” flag. You can select the relationship properties and set them for each parent-child relationship.

Noemi · 10-11-2023

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...

Noemi · 09-05-2023

Yes. You can write a Cube View Extender in a Finance Business Rule to modify almost anything in a report. You can look for examples in the GolfStream application available from Marketplace.

Noemi

Correct, for other scenario types / time you can use the grid view to review but not to update.

Noemi

Noemi

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...

Noemi · 10-03-2023

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 definition)

Noemi · 10-03-2023

Hi Jacky, You can use row overrides in your column, in my example I have used two different accounts (you can have up to four using the overrides): I hope it helps.

OneStream Community

User Statistics

User Activity

So You Want to Learn VB.NET - pt.2

Can I use different FX rates in my budget compared to actuals? Will I need to keep the data in...

How can I update the relationship properties (such as e.g. percent consolidation) using grid view?

So You Want to Learn VB.NET - pt.1

Can I modify the logo displayed in CV Reports depending on the Entity or other factors (like user ru

Re: How can I update the relationship properties (such as e.g. percent consolidation) using grid vie

Re: If Statements in Books

Re: Cube View Variance Calculation Issue

Re: Dynamic row header text based on another dimension in the member filter

Re: Dynamic row header text based on another dimension in the member filter