OneStream Community

MarkBird

Hi all I was wondering if it is possible to override the default 'clear and load' settings on a data load step from 'Level 2: Workflow Data Unit' to 'Level 1: Cube Data Unit' Just to give a bit of context: We perform a data copy from a Budget scenari...

MarkBird

Hi all What would be the best way to create an intersection of two hierarchies within the same UD? For example, assume these are Profit Centres in UD1. I would like to be able to create a cube view where by I could choose a node from hierarchy 2 and ...

MarkBird · 12-19-2023

Hi Is it possible to configure default group settings for a grid view? E.g. I've got a table here, and I'd like to configure the table so that it is grouped by the message column: Regards, Mark

MarkBird · 12-07-2023

Hi I am using a column override formula in my cube view and I have noticed that it doesn't work when I try override a column when the name has spaces in it, even if I surround it in square brackets. Am I doing something wrong? Regards, Mark

MarkBird · 12-06-2023

Hi I have got a list of member info and trying to do a simple loop through the list to get the member and it's parent using the following code, however ParentMemberId is always coming back as -1. Dim UD1DimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si,...

MarkBird

@MarcusH thanks for this, I think it is exactly what we need! It's not quite as simple as the first option 'Clear All Import/Forms Data from Cube' because we have got seeded data in the scenario that we don't want to clear out. But I'll look into the...

MarkBird

Hi Davide I think that we have done something similar to what you are trying to achieve using an XFBR rule and a parameter. Parameter Config: XFBR Rule: Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, By...

MarkBird

Hey Robb, thanks for the reply. The problem with these solutions is that the subtotal's won't be correct? So we'd have to create manual subtotals in the cube views?

MarkBird · 12-19-2023

It also only works for my user so doesn't really work

MarkBird · 12-19-2023

I have managed achieve this by using a bit of a workaround: 1) Set 'Show Group Panel' to True and 'Save State' to True 2) Run the Dashboard and set the group by settings as a user' 3) Set 'Show Group Panel' back to False But this feels very much like...

OneStream Community

User Statistics

User Activity

Clear data using level 1 data unit (rather than level 2) on data load

Create an intersection of two hierarchies in the same UD

Define a default grouping using 'Show Group Panel' functionality in Grid View

Column override doesn't work when the name has spaces in it

ParentMemberId is always -1?

Re: Clear data using level 1 data unit (rather than level 2) on data load

Re: Conditional formatting based on the Scale

Re: Create an intersection of two hierarchies in the same UD

Re: Define a default grouping using 'Show Group Panel' functionality in Grid View

Re: Define a default grouping using 'Show Group Panel' functionality in Grid View