OneStream Community

Nikpowar97

I am trying to run a Custom FX translation rule on run a set of Account @HistoricalRate with Periodic Rule type.The function seems to be working fine for the direct Rule type but does not seems to be working for the periodic Rule type. any reason? Di...

Nikpowar97 · 07-19-2024

    Post deleted by the user

SIC: Error for non Admin users · 07-03-2024

Hey I a running a stored procedure on Oracle EBS in OS using SIC. Me as a admin can run the job succesfuly. However other than admin users cannot. Smart Integration Connector remote query failed.ORA-03135: Connection lost contactORA-03135: Connection...

Nikpowar97 · 06-03-2024

api.Data.Calculate("A#FCTR:F#EndBalanceLoad:I#None:O#Import:V#YTD:U1#00000:U2#00:U3#GL:U4#0000:U5#00:U6#00:U7#None:U8#None = A#Assets:F#EndBalance:I#Top:O#Top:V#YTD:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:U7#None:U8#None:C#Share - A#Liabilities:F#E...

Nikpowar97 · 05-27-2024

Is there any way I Can enter a +ve or -ve value based on the text property if a Flow member in a form. I think a Save Data Event Handler can, but I will throw an error if the only after the form is saved. What if the cell color will change (Just like...

Nikpowar97

For the cube I have used Closing rate at Direct rule type. Scenario follows the cube Fx setting. And I am using standard using Business Rules in the cube translation algorithm setting.

Nikpowar97

I expect at Rule type Periodic, the translated value = Prior period Translated value + YTD change from period period * Translation Rate. which does not seem to be working.however the for the Direct Rule type, the translated value = Current YTD Local ...

Nikpowar97 · 07-26-2024

I think you can use these functions and give it a try in Extender BRBrapi.Finance.Dim.GetDimPk(si, "DimName") 'dimPk Dim relPk As New RelationshipPk(dimTypeId., parentMember.Member.MemberId, childid) 'relationshipPks Dim relPositionOpt As New Relatio...

Nikpowar97 · 07-19-2024

I wrote a code from my end for my Account dimensions (you can replicate for others) Imports System Imports System.Collections.Generic Imports System.Data Imports System.Data.Common Imports System.Globalization Imports System.IO Imports System.Linq Im...

Nikpowar97 · 07-19-2024

Thanks @Henning , This is always a expected option we use in all our project to create a Ent_Adj member to make topside adjs on forms. I was looking forward to explore to see if we can input data through forms on parent entities without the option (A...

OneStream Community

User Statistics

User Activity

Custom FX Translation Not working for Rate type Periodic

Deleted post

SIC: Error for non Admin users

Formula Error: MemberFormula

Disallow invalid Entry in forms

Re: Custom FX Translation Not working for Rate type Periodic

Re: Custom FX Translation Not working for Rate type Periodic

Re: Move member from One Parent to other parent member

Re: Ho to extract a hierarchy for any dimension in Level format in OneStream?

Re: Input data in forms at parent Entity