ContributionsMost RecentMost LikesSolutionsRe: determining parent by hierarchy elegant! Nicely done. :) Re: NetSuite to OneStream Integration MindStream Software has NetSuite Connect for OneStream and OneStream CPMx. NetSuite Connect provides direct integration with NetSuite for data, segments/dimensions, and FXrates through an easy user ...Re: determining parent by hierarchy Here's an example of recursive tree traversal that will build in-memory a searchable parent child list representation of your dimension's members, with the code I posted earlier, you can get to your ...Re: determining parent by hierarchy If what you have to work with is Current State and Expected State, then your best option is to discard Current State and build the Expected State. The problem is OneStream wont allow this when data ...Re: determining parent by hierarchy https://community.onestreamsoftware.com/discussions/Rules/determining-parent-by-hierarchy/43551/replies/43576_ Re: determining parent by hierarchy If I had to write an API for this requirement, it would look something like this (pseudocode, Member here is MemberInfo.Member): public class MemberNode { public Member Value { get; } p...Re: determining parent by hierarchy I would update the use case for this requirement: The requesting process or user to include the parent of the member being moved. Without the parent in the request you're being asked to perform ma...Re: Help Needed with Confirmation Rule to Validate Annotations for Thresholds Yes, dynamic is the way 🙂 Re: Help Needed with Confirmation Rule to Validate Annotations for Thresholds Also, consider organizing your decision logic using named variables and using named strings for easier readibility. This will save you confusing which quarter you're referencing and make your code e...Re: Help Needed with Confirmation Rule to Validate Annotations for Thresholds change line 19 to: Dim hasComment As Boolean = Not String.IsNullOrWhiteSpace(StringAnnotation) Try this - it checks for a comment in the current (2024Q1) period: ' Get current QTD value for Ent...
