OneStream Community

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 · 11-22-2023

Hi I am loading data into a Bi Blend table and I don't want any aggregation applied. My understanding from the documentation is that I can use 'SSOnly.' However, whenever I try use this I get an error. Below is the config: Question 1: Am I doing some...

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

MarkBird · 12-15-2023

Table Views don't currently support drop down lists in excel. There are a couple of enhancement requests open to add this feature: https://community.onestreamsoftware.com/t5/Planning-Analysis/Allow-for-multiple-drop-down-cell-columns-in-Table-View/id...

OneStream Community

User Statistics

User Activity

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?

Create a Bi Blend Table without any aggregation

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

Re: Drop Down in TableView not working.