User Profile

mpavan

New Contributor II

Joined 2 years ago

11 Posts2 Likes3 Solutions

View All Badges

User Widgets

Contributions

Re: Rename 500+ members in onestream
Thank you for the sample script. In our case there was no logic behind it and the changes are random. I had got the following script and it works. (I will be populating the Key Value Pairs in Excel a...
4 months ago Place Application Build
508Views
1like
0Comments
Re: Rename 500+ members in onestream
Thank you for the suggestion! a) I am assuming that Extensibility Rule is required here? b) Is the following code is what you are suggesting or am I way off? Dim ProductDim ...
4 months ago Place Application Build
552Views
0likes
0Comments
Re: Rename 500+ members in onestream
The member changes only refer to UD dimension and not been hard coded any where so that is not a concern. We do have to test for Data Loss in dev app to be sure once I can get the rule ready.
4 months ago Place Application Build
559Views
0likes
1Comment
Rename 500+ members in onestream
Hello Experts, Is there a way to update 500+ member names in OneStream using XML file. Manually changing each member is time consuming there seems to be no functionality available with XML load? T...
Solved
4 months ago Place Application Build
Metadata
626Views
0likes
9Comments
Re: Derive account based on Data Value in Transformation Rules.
Hello Lee, Sorry for the delay. I had started to work on it but unfortunately account hierarchy is little messy and we do not have a defined range. Due to missing range Derivate rules are becoming...
2 years ago Place Application Build
2.5KViews
0likes
0Comments
Derive account based on Data Value in Transformation Rules.
Hello Experts, We have a requirement to derive account based on Data value. (If data value is Positive Asset Account , if negative Liability account) This has to be done for range of accounts. ...
Solved
2 years ago Place Application Build
2.6KViews
1like
3Comments
Filter Result DataBuffer based on value in secondary Source Buffer
Hello Experts, I have a requirement of calculating Cash_ADJ based a sum value of 2 different buffers. If the sum value is Positive I have to post a cash_adj with value from bufSrc2. Is it possi...
Solved
2 years ago Place Rules
Finance
2KViews
0likes
3Comments
Unable to Calculate Currency Override only for Accounts with Text Filter.
Hello All, I am new to OneStream trying to write a Value Override business rule for some investment accounts, The rule works without account filter. How ever I want to restrict this to Accounts wi...
Solved
2 years ago Place Rules
Finance
4.1KViews
0likes
9Comments
Re: Filter Result DataBuffer based on value in secondary Source Buffer
Thanks' for the suggestion. I have tried but unable to make it work using member formula. Still a lot of learning to do. In the meanwhileI had used api.calculate with in the loop and it had worked ...
2 years ago Place Rules
2KViews
0likes
0Comments
Re: Unable to Calculate Currency Override only for Accounts with Text Filter.
Thanks for the explanation! I understand the simple way of looping through a member list. https://community.onestreamsoftware.com/t5/Accepted-Code-Samples/Using-the-EVAL-function-to-loop-through...
2 years ago Place Rules
4KViews
0likes
1Comment

Groups

No places to display