OneStream Community

Nikpowar97

    Post deleted by the user

SIC: Error for non Admin users

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 · 05-17-2024

Is there any way we can input the data at the Parent Entity: One Possible way is Set O#AdjInput and Set Account Property > Allow Adjustments to Data Entry to which I want to input data data.But I am sceptical as it will not allow me to allow Posting ...

Nikpowar97

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

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

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...

Nikpowar97

I am not sure but can u try writing a XFBR and use the function (Parameter should be a literal parameter value) Return BRApi.Dashboards.Parameters.GetLiteralParameterValue(si,False,Guid.Empty,"Default.prm_Name") and the call the same in the CVNot sur...

Nikpowar97

@AndreaF , I think this is possible using 2 ways, 1. (Suggested method) Write a sql query in the adapter the Application DB tables doing some joins. below are the table names:a. Memberb. Dim (Can be optional)c. Relationship OR 2. (Avoidable due to lo...

OneStream Community

User Statistics

User Activity

Deleted post

SIC: Error for non Admin users

Formula Error: MemberFormula

Disallow invalid Entry in forms

Input data in forms at parent Entity

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

Re: cell format in CV using parameter

Re: Combine application table and UD dimension information