OneStream Community

Adding unique records to a Member List · 05-16-2022

Hello- I have created a business rule that uses a buffer to bring back UD1 members that have a value against them, then they are added to a list like this: myList.Add(api.Members.GetMember(DimType.UD1.Id, curUD1)) Later on in my code I do a sort Asce...

Jason · 02-16-2022

Hi, I have built a Finance business rule that users a data buffer to identify base level UD1 members with data at a specific intersection and sort the results. The user is prompted to select a parent level Entity and that is passed to the BR and used...

Jason · 02-07-2022

I have created a DM sequence that calls multiple steps. One of the DM steps prompts the user to select a seed Scenario which I then pass to my Finance BR as a parameter value. The scenario options are presented to the user as a Member Dialogue Parame...

Jason · 01-18-2022

I have a Stage Attribute of text type attached to my source records. As expected, this drops off when I push data from Stage to the Cube. When I run a query in the Excel Add-In and do a drill-down back to source at the base level intersections, I can...

Jason · 06-01-2022

Since you don't want to eliminate the activity, I would try to solve it with 2 UD's if that's an option for you. One party writes to a location in UD6 lets call it Location1_In, and the other side books to Location1_Out in UD7... both use the same re...

Jason · 06-01-2022

Actuals are usually going to be locked down by period so an accidental submission would fail in most cases. If the latest period of Actuals is still open and the user submits you could try the following: reverse the entries through a new submission (...

Jason · 05-31-2022

I have done something similar and got it to work:In this case, I extended horizontally so Actual is at a more granular level to my Forecast scenario. It's 4 lines of code.#1 I set my destination to write to O#Import#2 I set my source buffer which is ...

Jason · 05-17-2022

I got this working, the fix was simple. On the sort line just add a Distinct()The code becomes:objMembers = (From member In myList Order By Member.Name Ascending Select Member).Distinct().ToList()

Jason · 02-16-2022

I got this working now. Here is what you need to do to get it working:Create a simple list with these 2 lines of codeDim entityDimPk1 As DimPk = api.Dimensions.GetDim("YourEntityDimName").DimPkDim objEntityMemberInfos1 As List(Of MemberInfo) = api.Me...

OneStream Community

User Statistics

User Activity

Adding unique records to a Member List

Looping Entities In a Data Buffer

Prompting a user for a parameter selection through a DE123 Dashboard

Viewing Stage Attributes From Excel

Re: Related Party Accounts- IC Matching

Re: Question: How can I prevent a user from loading data to a close period via import forms

Re: Seeding Actuals to Forecast for Extended dimension

Re: Adding unique records to a Member List

Re: Looping Entities In a Data Buffer