User Profile

mpavan

New Contributor II

Joined 3 years ago

12 Posts2 Likes3 Solutions

View All Badges

User Widgets

Contributions

Requirement to Translate different entities at different rates in Budget.
Hello Experts, I am wondering if any one has worked on requirement where 2 entities need to be translated at 2 different rates for Budget scenario. I know how we can translate entire scenario by ...
2 months ago Place Rules
Finance
19Views
0likes
1Comment
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...
7 months ago Place Application Build
554Views
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 ...
7 months ago Place Application Build
558Views
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.
7 months ago Place Application Build
575Views
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
7 months ago Place Application Build
Metadata
690Views
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.6KViews
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
2.1KViews
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 meanwhile I had used api.calculate with in the loop and it had worked ...
2 years ago Place Rules
2.1KViews
0likes
0Comments

Groups

No places to display