OneStream Platform Forums

Hello Community...       I can get only one cell data from using FdxExecuteDataUnit. But After that i want to get all data including Rows and Columns. So, For that any sample code...? or what format i need to use..?

Guys, We are using difference of  multiple CVR functions to get the value for a row, and it is working correctly in the Data Explorer , the data is also correct , but when we generate the report in PDF or Excel we are getting an error  in that cell with the name of the first row used in the CVR GetDataCell.For eg: If "GetDataCell(CVR(A1)-CVR(A2)-CVR(A3)-CVR(A4))" is the function , then the error displayed in the cell in PDF and Excel is "Error : A1" .Any idea why this is happening? Thanks

Hi, I have the following code that gives me an error: Object reference not set to an instance of an object. Dim listMbrEntityD As New List(Of Member) Dim dimpkEntityD As New DimPk(mbrEntityD.DimTypeId, mbrEntityD.DimId) listMbrEntityD.AddRange(BRApi.Finance.Members.GetBaseMembers(si, dimpkEntityD, mbrEntityD.MemberId)) I have debugged with errorlog but it doesn’t manage to print anything to see the values, any idea how to solve it?

We created a customized application support security group (Pseudo Admin role) which excludes the accesses of cube view form input, JE create/post and user security provisioning.  This is required by internal control as segregation of duties.  We updated maintenance group setting with this Pseudo admin group in all applicable components. e.g. Workflow profiles, Transformation rule, dimensions, confirmation rules, Forms/JE template, Dashboards etc.  The limitations we confront are that the following components are accessible only to the default administrators.  Can we enable the discrete security settings to those components instead of default to admin only?  Thanks!System Diagnostic DashboardCATExtensibility business rulesDatabase under System tab

Hi All, We are facing an error "Unable to execute Business Rule 'BusinessRuleName'. Select a valid workflow, scenario and year, when executing step from PowerShell/REST API. We are passing the parameters using the option "CustomSubstVarsAsCommaSeparatedPairs". Please help if the execute step and the execute sequence works for business rules with parameters using Data Management api from PowerShell. Please help me with sample code. Thanks & Regards, Lova Ramisetti.

Hi,  Does anybody know if it's possible to configure a Bound List parameter to show both the Name and the Description as the Display Member? It's valid for Member Lists but I get an error in Bound List parameters.   Lee  

Hi Everyone,I have requirement to run 4 data management steps in parallel, is there a way to run 4 data management steps same time? Thanks in advance.  

Hi, how can I recover a member that I remove relationship without deleting? I can't create it because exists,  

  Good morning, I am writing to inquire about the correct formula for calculating the difference between two values in the same column in a Calculated Field of a Report Design. For example, if I wanted to calculate the difference between the values 121.46 and 120.30 in the "Col0Value" column, what would be the exact formula to use in the Calculated Field? The data are read from a cube view data adapter (not MD). The image below shows an example of the data from the data adapter. Thank you.      

Hi there, I have a Workflow Import process that runs automatically via Task Scheduler. My question is, is there a way to capture the Invalid Intersections then send it via email? The idea is to get alerted via email without opening the application that the Validation failed. Regards Jesse

Hi All, Does anyone have the Consolidation and Planning in separate applications? If so, what are the reasons for having them separate or what are the challenges.

Hello Community - I am using multi select combo Box to pass periods selected by user back to business rules, receiving the selected periods in the BR but while executing getting error "Error processing Data Management Step".  Under Data Management I have set Time Filter as WFTimeYear_CopyFAPC=|!ml_WFTimeYear_CopyFAPC!| and  Parameters = WFTimeYear_CopyFAPC=[|!ml_WFTimeYear_CopyFAPC!|]. It looks like the Time Filter is not processing multiple periods from the Parameters, what is the correct way to pass these periods into the Time Filter under Data Units section. Thanks.

I am building a donut chart in bi viewer. I am using my Geography UD2 as the arguments. My member names are long: 'United States Region', 'Asia Region', etc. I would like to rename them visually for this report. Is this possible? I cannot rename them in my dimension library, and renaming them in the cube view with the :name() member expansion does nothing. Thank you in advance.

Hello, Is it possible to get the user who completed a 'Form Input' step in OneStream ? To clarify, I am able to do so for 'Import/Validate/Load' steps but I'm under the impression that it's impossible for Forms or Journals. Anyone with a similar experience ? Thanks Here goes my desperate attempt: Dim wfstatus As WorkflowInfo = BRApi.Workflow.Status.GetWorkflowStatus(si, mywfstep) Dim logusername as String = wfstatus.LastExecutedStep.StepLogItems(0).UserName ' (wfstatus.LastExecutedStep.StepLogItems is Nothing) = True    

I have an excel template. I had a DataList on a cell coming from another sheet.  I added the name ranges for the TableView as it gets data from SQl.  It used to work but it has stopped working and the DropDown of the list doe not happen. It shows the arrow for the partuclar cell but when you click it does not show the list.    Thank You, Indu

Hi Community... I'm trying to extract data from CV using FdxExecuteCubeView method..So, if anyone give sample code for that with respected method query means... It'll be very helpful to refer...     I want to know how we are passing values in this method...By CV POV...?Thank You...!

I want to navigate to a workflow from a dashboard button and thougt I found my answer in selecting the open page action and using "XFPage=Workflow".  This works and when i click the button it takes me to the workflow page using my current WF settings.  I was hoping to get more granular and go to a specific workflow and found in the Design and Reference Guide this example which I was hoping to explore: "XFPage=Workflow:NameofWorkflow"  Has anyone worked with this succesfully as I just cant seem to get it to work and not sure if there is some syntax nuance I am missing.  Using GolfStream as an example I am trying "XFPage=Workflow:Houston.Journals" as an example but nothing.  It stops going to workflow at all.  

I need help with keeping some CV formatting when exporting to Excel. The current CV I've built works just fine, but when the client exports to Excel, some of the percent values are truncated to the whole number and the '%' is removed. EX: OneStream CV shows a cell value as "35.6%", but Excel shows "35" I've tried to mess around with the Excel formatting in the designer tab for CV's, but I cannot get the setting to carry over during export. Any advice would be much appreciated! 

How do you consolidate currency overrides using alternative currencies e.g. Base Entity and immediate parent are in EUR and ultimate parent is in USD. Client wants to view consolidated view of immediate parent in USD including the currency overrides. The same reverse is required for USD entity rolling up to EUR. We have created alternate flow members but the aggregation is a challenge.

Dear Community: I am trying to add a previous year M12 balance to a SCF report.  I can't seem to get prior year data to come over.  However, If I code the amount it does work. ' api.Data.calculate("A#CF_RepaymentEquityInvestment = A#CF_RepaymentEquityInvestment + A#33100:T#POVPriorYearM12") does not work ' api.Data.calculate("A#CF_RepaymentEquityInvestment = A#CF_RepaymentEquityInvestment + A#33100:T#2022M12") does not work ' api.Data.calculate("A#CF_RepaymentEquityInvestment = A#CF_RepaymentEquityInvestment + A#33100") does not work api.Data.calculate("A#CF_RepaymentEquityInvestment = A#CF_RepaymentEquityInvestment + -62225") ' Returns amount as intended   Thanks

Hi all, i need to buil a chart that it is easy to build in excel, but I don't know how to handle it using a chart in the report designer of the report component.  The chart that i have to build is the one in the attached picture. It is a waterfall chart in which you can see the delta between actual and budget distributed on the different line of business (for example delta between actual vehicles and budget vehicles is 31.5, delta between actual rail control and budget rail control is 13.3... and so on). On the other hand though the two bars representing actual and budget have the percentage distribution of the line of business (for example for the budget you can see that the total is 439.3 of which 57% is for vehicles line of business, 37% is Rail Control... and so on). Is there anyway the chance to build a chart like this one using the report component?   thank you in advance.

I'm looking to add a formula that takes an account and subtracts the difference between two scenarios. So, something like this: GetDataCell(A#ProductionTCFacSTd:S#Target_FY24) - GetDataCell(A#ProductionTCFacSTd:S#Target_FY24_SC). Can you please help see what I need to do to make this work in my cube view?

Hi Everyone. Is there a way to delete accounts in a scenario that have a certain value, for example, 0?

Hi Does anyone know where all of the below information is stored?    Thank you, Mikki  

Good Morning!  Does anyone know how to build upon the set up variables in OneStream?   For Example: |CVYearNext| - This gives me the following year of the CV.  What if I want the following Year and the next one? Does anyone know how to pull that data?  So, if the CV is 2022 this variable will give the following year 2023, if I need 2024 and 2025 and so on.  How do you expand on this variable?