Account is invalid due to Aggregation property
I have informational account created to store some Include/Exclude value by Entity. Now, I dont want this account to be translated and consolidated so, I have tagged AccountType to "Non Financial" while Aggregation to False. However when I turn on false its become invalid while True makes it Valid for input. Any idea what causing the issue? Based on the OS doc any informational account can be set to False.5Views0likes1CommentEntity - In Use Feature
Hi all, We have a situation where an Entity was created and incorrectly set up and contains data for period 2024M12 and 2025M3. We decided to create a new Entity and updated the transformation rules to ensure that the data loaded goes to the newly created member and not the old one. We have set the consolidation and ownership percentage of the old entity to 0 as added measure. We are now faced with the challenge of not deleting the member as it contains data. Kindly asking if it is advisable to set the In Use feature in this scenario and is there any impact that would cause. Thanks in advance.15Views0likes0CommentsMonthly vs Yearly Cube View Data
Hello everyone! I require some assistance regarding the following objectives that I have in mind for this cube view. Showing the monthly data input cells (which I have done), along with the total sum of all the months in the year. Getting a percentage by using the monthly data / current year. Currently, the Amount 227.00 under actuals - 2025 column is a member filter under rows/columns whereby i use getDataCell(CVC(Col, 1) + CVC(Col, 2) .... CVC(Col, 12)) which I know it isn't the best idea. But I want the column under 'Total' to show this amount and with this amount, I will calculate the percentage in the next table. For example, on the 2nd table (green cells), on row ACTYPE001, when the user click calculate, the answer should be 1/227 x 100 = 0.44% at Jan 2025, 2/227 x 100 = 0.88% at Feb 2025. Please advice on how I should approach these issues or any improvement or suggestion I should be doing.16Views0likes0CommentsOrphan Members
Hi Team, I have a question around the orphan members. I know that when we remove the relationship, the member gets moved under the Orphan section. After moving to the Orphan section, can we load data into the member through the Workflows? Thanks in advance AKSolved2.7KViews0likes7CommentsFetching text property by time
Hi, I'm trying to display a time-variant text property of the UD1 dimension member in a report. The challenge is that the text value can exist in any period of the member, so I currently loop through the forecast periods (spanning two years) to retrieve the values. While the code works, its performance is not good. Is there a way to fetch or look up the text properties by time (possibly from a specific table) without iterating through all periods? Any command or optimized approach to achieve this efficiently would be highly appreciated. Dim Date As String = $"{year}M{month}" Dim timeID As Integer = timedimhelper.getidfromname("Date") Dim myVaryByTimeId As Integer = BRApi.Finance.Members.GetMemberId(si,DimType.Time.Id, Date) Dim mbrText As String = BRApi.Finance.UD.Text(si, 9, mbrId, 1, -1, myVaryByTimeId)Solved118Views0likes8CommentsHow to place multiple UD1 members in Account dimension UD1 constraint
Hello OneStream experts: Thank you for the helps in the past. I have a quick question about place UD1 members in Account dimension UD1 constraint For example: In my account metadata dimension: I have 2 accounts 4001-Sale_IceCream 4002-Sale_Donut In my UD1 product dimension: I have 4 products all under one parent product Product_1,Product_2,Product_3,Product_4 I want to place Product_1, and Product_3 to the UD1 constraint in account 4001-Sale_IceCream's UD1 constraint field. But OneStream only allow me enter one product member in that filed. I can only enter Product_1 but cannot enter both Product_1 and Product_3 in the field. Thank you so much in advance to help me get through this issue.187Views0likes3CommentsConverting Historical Data
We are in the process of changing our chart of accounts and department structure (for us, UD3 and UD1, respectively). Further complicating things is that some of the old UD3/1 members will likely be consolidated into one UD3/1 member, and vice versa. We will need to keep the existing data in its original intersections (e.g if UD3#ABC changes to UD3#123, we need the historical data to stay in UD3#ABC). Or do we? We currently map each of our 3 different GLs* in UD3 to accounts in the A# dim which is at the P&L/BS level. Has anybody out there done this before? What approach did you take? Can we simply create new transformation rules and somehow reference the old ones for historical data? Do we simply create a new hierarchy in UD3 for the new members (bloat?)? If so, how do we reference them in dashboards and cube views that compare past and present data? I have so many questions as to the best or simplest way to do this. Bonus points if they are one and the same. --Brooks *Only one GL is changingSolved380Views0likes2Comments