OneStream Platform Forums

Hello, OneStream Community We currently have OneStream set up to load data files automatically over the filesahre API, notifying users via email when something goes wrong or succeeds. In addition, I would want to compute the validation errors from OneStream and email them to the users about the invalid intersections. Could someone please tell me how to go about doing that? Regards

I am trying out a complex expression in Time Data Source. The issue is the next: I have a Forecast scenario type with input frequency monthly and on the other hand I have a Long Term scenario type with input frequency yearly. Therefore, the colum time in the file is yearly, so I developed a complex expression where I can load depending on neither scenario type year 2024 or WFTime (forecast for this case) or scenario type year 2024 + M12 or WFTime + M12 (Long Term for this case). This is my complex expression (that is not working): Dim vYear As String = args.Value Dim scenId As Integer=api.CurrentDataClusterKey.ScenarioIDDim scenType As ScenarioType = BRApi.Finance.Scenario.GetScenarioType(si,scenId) If scenType=ScenarioType.Forecast ThenReturn vYear + "M12"ElseReturn vYearEnd If I appreciate all your comments, Thank you.

My company is implementing a new ERP system and I need to map the new accounts into our old structure. I am fine with the transformation rules I simply extract out make changes and load back up all is done in our Dev environment. My issue is how do I download to add accounts in the dimension library, If i added manually it will take forever.    Thanks in advance Mark

Hi, This formula is working, but it's returning 100% for each Entity. Is there something I'm missing regarding Entity? Will this work in a member formula or only in a business rule? Dim entity As String = api.pov.entity.NameDim entityID As String = api.pov.entity.MemberIDDim OwnValue As Decimal = api.entity.percentOwnership(entityID) If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyforEntity())) Thenapi.Data.Calculate("A#NCI_IS:V#Periodic:F#EndBalLoad:O#None:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None= "& _"RemoveZeros(A#Income_Loss_before_Noncontrolling_Interests:V#Periodic:C#Local:F#EndBalLoad:O#Top:I#Top:U1#Top:U2#Top:U3#None:U4#None:U5#None:U6#None:U7#Top:U8#None * ( ("& OwnValue &")))")End If

Hi, has any one used DocumentFormat.OpenXml.dll coming v8 to create excel docs? It looks like it is working from standard extender BR once you add reference to DocumentFormat.OpenXml.dll and System.IO.Packaging.dll but it does not work when you do in a file within Workspace assembly as it complains about not finding the referenced System.IO.Packaging.dll even if the dependency is added   Thanks  

What is the difference between WorkflowUnitClusterPk vs WorkflowUnitPk? When would you use one over the other?   Thanks, Scott

I am trying to get the journal post group in the workflow profile properties using JournalsEventHandler Business rule.  Does anyone have done this before? Is it possible to get the journal post group value from the Workflow Profile?

I am trying to call a database stored procedure from an extensibility rule.  The stored procedure returns an OUTPUT parameter, but I'm unsure how to reference that OUTPUT parameter, using the DBParamInfo object and ParameterDirection setting.  Can someone give guidance on the proper usage for OUTPUT. Stored-Procedure CREATE OR ALTER PROCEDURE [dbo].[TEST_OUTPUT_PARAM_PROC] ( @OUT_PARAM_VALUE VARCHAR(100) OUTPUT ) AS BEGIN --Do stuff that needs to be done here SELECT @OUT_PARAM_VALUE = 'Param from Procedure'; END GO Extensibility Rule 'definition DB Call To stored procedure Dim OutParamValue As String = "" Dim tsSQL_CallProcwithOutputParamter As String = "DECLARE RC INT EXECUTE RC = TEST_OUTPUT_PARAM_PROC @OUT_PARAM_VALUE OUTPUT" Dim parameters As New List(Of DbParamInfo) parameters.Add(New DbParamInfo("@OUT_PARAM_VALUE", OutParamValue,ParameterDirection.Output)) 'paramDirection: Using dbC

Is there a way to view application Workflow Status reports in excel rather than having to use a dashboard in the application that shows if an entity is certified/locked or not? Something that is easily refreshable so that you don't have to leave the current workflow you're in to view all entities workflow status? 

Hi all, With the version 7 and above the switch between applications with the addin Excel requires to log off and log on. You cannot switch applications and stay connected. Admin team have to switch often between applications and this new mechanism is seen as a step backwards. Is it possible to restore the previous mechanism with the functionality: Change Application Thanks

Hello Everyone, I need a Literal parameter which will dynamically calculate something like the prior forecast based on another parameter so i ended up writing an XFBR for that Literal parameter, something like below XFBR(HelperRule,GetPriorForecast). And now i need this Prior Forecast value for some Finance calculations. So I tried to retrieve the value of Parameter in the finance rule by using  BRApi.Dashboards.Parameters.GetLiteralParameterValueBut it returns the same "XFBR (Helper Rule, Get Prior Forecast)" rather than the Actual String Value. Strangely enough, if i use the same XFBR for Scenario Filter in a DM step, it picks up the proper string value. Curious Why would it not work when I try to retrieve its value in a finance BR?

https://community.onestreamsoftware.com/t5/OneStream-Tech-Talks-Continue/New-Episode-of-Tech-Talks-Available-Now/td-p/33894 G'day, In this Tech Talks for Data Movement, Nick Bolinger suggested to use DMES as a better way than a DM Copy Job to copy data between S#s. We Imorted Actuals for '21-'23 via a Yearly Matrix and S# to then use a DM Copy Job to copy the Base data to a new Monthly S#Act: '21-'23 + '24.Pls share your DMES expertise to help us better copy Base data from historical Yearly S#Act's T# ('21-'23) to those T# of a live Monthly S#Act ('21-'23 + '24). TY.

Hi All, I would like to create the Dashboard for the Adim which should display all the Current login users Details in the applications. Kindly help to achieve this development.   Thanks

Hi all, How do we calculate Data Unit in OneStream ? I know that the largest Data Units should never be above 2-3 million intersections. The sweet spot for OneStream is between 250,000 and 500,000 records. But what can be the maximum possible records in the given example we can have to avoid performance issue in OneStream ? Please consider these dimensions in OneStream. Thanks

Hi, I have a book, with different report, but 2 of them are excel spreadsheets with cubeviews inside. They work, but after created and attached i am getting this error if i want to open it again and do any change.   Error in DXCustomFunctionsHelper.GetSpreadsheetDataProvider(). The spreadsheetDataProvider is not available using the Workbook's Tag property. It works in the book.... Any idea? Anyone?   Thanks JJ  

Hi all, We are in the process of implementation. How to eliminate Share Capital of the subsidiary where Percent Consolidation (PCON) and Percent Ownership (POWN) is 100%  Thanks

Hi all, I have the same question as AndeaF (https://community.onestreamsoftware.com/t5/Reporting/Conditional-formatting-based-on-the-value-of-other-rows-and/td-p/20227) Is the below solution post by OneStream still the only workaround for the question? I am trying to compare the variance of prior year and current year data and want to return a specific number format based on the two numbers. Thank you.  

       

Dear community, I need to display numbers in columns in cubeview. Is that possible?  Please refer below image for better understanding. TIA

Hello, Let's assume we have the entities in the dimension "Entity" and the Business Units in a UDx dimension . In this case, is it possible to trigger intercompany eliminations at Business Unit level ?  Thanks, Regards, Harry  

Hello,  Let's assume we have an extensibility on the dimensions account with 2 cubes. When we need to export the dimension account, we are only able to export the accounts for the 1st cube, and the accounts for the 2nd one (two files). Is it possible to export the full account hierarchy (within a single file), with a field specifying the associated cube ? Thanks for your support, Harry

Does anyone have information on how to restrict (No access) on scenario  Member, The app has the entity security setup. i tried with Data cell access Security "on the cube data access" not able to figure out. if any one gone through this scenario please help. Thanks PK  

Hi All, We have a client who is concerned about users being able to delete and reload journal entry attachments. From what I can see there is no audit record of this, the items show up in the ‘Attachment’ table when posted but once deleted there is no record of this being deleted. From what I can tell there isn’t a separate audit table associated with this. Does anyone know if there is way to prevent users from being able to delete an attachment or a way to provide an audit of items that were changed? I also was trying to find where attachments for Journals get stored to see if changing security on a folder was possible (maybe the only record is the table itself and this isn’t an option). Another idea was an event handler but it doesn’t seem like deleting an attachment is considered an event. Any thoughts or suggestions would be appreciated!

Hi All, How can I show Cell Detail Classification in the report ? Thanks

Does anyone know how to use VBA code to save offline copy?  I know VBA support the following, but anything for save offline copy? RefreshXFFunctions()  RefreshXFFunctionsForActiveWorksheet() RefreshQuickViews() RefreshQuickViewsForActiveWorksheet() RefreshCubeViews() RefreshCubeViewsForActiveWorkSheet() ShowParametersDlg() ShowParametersDlgForActiveWorksheet() Thanks