OneStream Platform Forums

Hello everyone, Is there a way to import data in such a way that we have more than 2 decimal places in the import step?  Our .csv files have 4 decimal places and OS is rounding those amounts to 2 decimal places. We would like to keep that level of detail Thanks in advance

Hi, Recently we upgraded our onestream to 8.2.2 and after upgrade we were not able to create files on SIC server thru this function ExecRemoteGatewayJob. please help me with this issue.   Thanks, Manju K

The goal is to get underlying dashboard data, I'm developing business rule using VB to call respective data adapter. The issue is, the data adapter has 1 parameter, not sure if it's possible to pass parameter value to it in BR. Below is my BR code and sample sql scripts for the data adapter, Dim isSystemLevel As Boolean = False Dim workspaceID As Guid = BRApi.Dashboards.Workspaces.GetWorkspaceIDFromName(si, isSystemLevel, "Default") Dim adapterName As String = "da01_entity_hierarchy_filtered" Dim rsTableName As String = "OutputTable" Dim dctVars As New Dictionary(Of String, String) Using ds As DataSet = brapi.Dashboards.Process.GetAdoDataSetForAdapter(si, isSystemLevel, workspaceID, adapterName, rsTableName, dctVars) If ds.Tables.Count > 0 Then 'If there are >0 tables in the results Using dt As DataTable = ds.Tables(0).Copy() op_table = dt.Copy() ' Clone the DataTable End Using End If End Using     SELECT C.NAME FROM Member C WHERE C.Name = '|!Sel

We would like to enabled SIC in on-premises hosted environment. I see Azure relay setup is needed, is there any documentation or steps to perform those? Please advise. Thanks, Vasanth

Hello everyone!I’m trying to set up an Excel spreadsheet to be used in a dashboard, for users to be able to insert their FX rates in the Workflow.I’m using the XFSetFxRate formula, and it works when I hard code the time, for example ‘2020M1’. However, I need the time to be dynamic, to change based on the workflow.Is there a way to bring the Workflow time in the XFSetFxRate formula? I tried WF and WFTime, but it doesn’t work.Thanks!

Hi,I would like to know what are the best practices for managing consolidation perimeters when the perimeter is not flat.I would also like to know if a company or subgroup leaves the perimeter, how is this structure maintained, can the old members be removed from the perimeter or should they remain forever? Regards, Sara

    Post deleted by the user

Hi, I need to copy data between 2 cubes . they both use different Entity Dimensions . Not Extended ones.so is there any way I can map the entities . I am using customcalculate DM with the Destination Data Units  to run finance rule. I have given the Source Entity and destination Entity in the Corresponding DataBuffers. But when I give  api.Data.ConvertDataBuffer("sourceCube","SourceScenario", databufferConvInfo, sourceDataBuffer). I am getting Error Saying "the Cube and Entity Are invalid or Incompatible". What is the issue ? Thanks.

Hello All,  Is there a way to automate Security Audit Reports?  I'm currently running ad hoc user reports for Audit and would like them to run on a schedule.  Thanks!  Cheryl Patterson  

Hello, I have created a button that opens a Book from File Explorer. This particular book requires prompts to run correctly, but when running the Book from the button, it skips the prompt dialog and runs with errors. Is there a way to have the button ask for the prompts before running the book? Thanks!

Hi, is there a means of creating an administrator group but limiting access to certain dimensions, i.e. the group can see and perform all the same functions as administrators but just cannot see a specific dimension (such as a specific account)?

Has anyone had any issues Windows 11 and QuickViews? We have one individual only that cannot seem to run QVs, or if he can, it takes several minutes to do so. Any ideas what it could be that is causing this? We are on an old version of OS. We changed some preferences in the QV and that helped. We have had IT look at his setup and they found nothing out of the ordinary. We are at a total loss as to why one individual is having problems out of 50 + users. Any ideas will help. Thanks

Hi Community,             I have a Cube View which has multiple source rows and a total row at the very end which is using GetDataCell(CVR()) to obtain the Total.Is there any way in which I can hide the source rows and just display only the Total row. Thanks,

I've seen a post about triggering a DM process from Control-M.  I wanted to see if anyone else is triggering a Control-M process from a Data Management job, and if you have a snippet you can share.

I am writing the Business rule in Revenue % account dimension,  Revenue % = X / PY Y. My PY can be based on POV. For example, if user can select current year as FY2024 then PY is FY2023 or If user choose MAY 2024, then PY is MAY 2023 or if user choose Q2 2024 then the PY is Q2 2023.  I am using this code and I am able to achieve if it is year, but I need more of dynamic based on user selected PoV. how to automate this code based on PoV. any suggestions would be really appreciated. Return api.Data.GetDataCell("-A#X / (A#Y:T#GlobalPrior1")

Hi. We are currently working on a project for a company to analyse their daily sales. The information is not in the cube, so we are using components such as Charts, Pies and even the BI Viewer to display the information in an attractive way. This information is not in the cube because the table we use as the database in the application has more than 400,000 records. Firstly, when working with data that is not in the cube, we cannot add the components we want to a book because the only components (not including cube views) that can be added to a book are charts and reports. For example, if we create a BI viewer, we will not be able to add it to a book. At this point, we would like you to recommend which would be the best component and how we should prepare a dashboard to have these two characteristics that our customer requires. - Being able to navigate from one chart to another by clicking on the same chart (open dialogue) (Can be done in advanced chart)- Dynamic filtering between diff

Hello, I am trying to format this so the Total Assets/Liabilities/SE at the top is just a header without numbers. Does anybody know the correct formula?  

Hi, i'm retrieving the annotations in CV where as i could retrieve as read only for the account type dynamic calc(third row in screenshot) for account type Revenue still i cell is editable(first two rows). how can i make them read-only? i have already set the can modify data to false in both general setting/common & rows and columns/Data regards, Manju    

Our client provides a data file with Cost Center members including Parent/Child Relationship. They would like to Automatically update new Cost Centers when the data file is loaded. Any existing Cost center moves from one parent to another should also be handled (instead of Merging it should Replace). Appreciate any pointers or advice if anyone has worked on solving similar requirement.    

Hi everybody, I've been wondering, in case there are some tasks that need to be executed only at year end by the user, is it possible to create a WF profile that is only active in december and does not show up in the other periods? If yes, how?Thanks in advance!

Hi, I am getting error when retrieving parent member name of a UD dimension using XFGetRelationshipProperty. I have used below syntax. Could someone please help me. XFGetRelationshipProperty(“UD4”,B15,“ParentMemberName”,"","","")  It returns #ERROR: PropertyName      

Hi All: I have created a new Datasource of Trail Balance which is excel source. I have written a complex expression in the logical operator. the logic is, if there is an amount in the debit column, bring that amount in, but if debit column is blank, bring the credit amount ((not negative)) in as a credit amount. I have below DataSource connection:   the code in the Logical operator: Dim debitColPosition As Integer = 2Dim creditColPosition As Integer = 3 Dim AmountDR As String = api.Parser.DelimitedParsedValues(debitColPosition)Dim AmountCR As String = api.Parser.DelimitedParsedValues(creditColPosition) If (IsNumeric(AmountDR) AndAlso Not AmountDR = "0") ThenReturn CDec(AmountDR)ElseIf (IsNumeric(AmountCR) AndAlso Not AmountCR = "0") ThenReturn CDec(AmountCR)ElseReturn 0.0End If when I am running through workflow, the source is trail balance file. I am getting the below error. any suggestions please if anything I am missing here. Error: Unable to execute formula. Index was out of

I'm able to extract the monthly csv files uploaded using BRAPi.Import.Data.ExportStageArchives, but this doesn't seem to work for multiperiod uploads (specifically budget) or I'm just referencing a parameter incorrectly. I've tried entering the time parameter as "2021", "2021M12", "2021M1", even "2021M1-2021M12" within the business rule, but nothing is exported at all for the Budget scenario.... Any ideas?  

Hi everyone, I have a question regarding confirmation rules - is it possible to run confirmation rules from outside a workflow via a dashboard button or some other method? Some of our users who would like to see the status of their confirmation rules without having to complete the form and workflow. Currently, they have to mark all forms as complete, complete the workflow, and process the cube to see confirmation rule status. Then, once they see which rules are failing, they have to revert the forms workflow, then revert individual forms - it seems like a lot of extra steps. The forms nodes on our workflows are set up as "Form Input, Process, Confirm, Certify". One possibility we've considered is a dashboard where users can click a button that runs the confirmation rules for their current workflow, then return the status of those rules in a grid view, all without having to complete the forms workflow. I've created a grid view to show confirmation rule status for the currently selected

How can I create a journal with an excel or csv document?