OneStream Platform Forums

I'm trying to export data via a Data Management step.I am running into frequent errors stating: Error processing Data Management Step '[DM STEP NAME]'. Unable to create or open file '[FILE PATH]'. The process cannot access the file '[FILE PATH]' because it is being used by another process. My servers were unoccupied as no tasks were running in the background in the task activity log. I've also tried via DM sequence and selecting my own server which did not help.  

I have a dashboard that uses a Tree View.  Its in a named workspace.  The only way I can get images to work with it is to upload the images to a Default Workspace.  Is there a way to reference my images in the workspace where the Tree View is?  

Hi There, I am trying to create a book with a loop on our UD4 (project). I have it working but I want to add an IF statement to filter out tabs that contain no data. Referencing a previous post, I tried adding an IF statement to filter out an account (A#TotSGA in our case). This is the statement I am using, but it doesn't seem to work. XFCell(Cb#00_CorpRpt:E#7420:C#Local:S#Budget_V2:T#2024:V#Periodic:A#OtherSGA:F#EndBal:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#|Loop1Variable|:U5#Top:U6#Top:U7#None:U8#None) <> 0.00 I have attached screenshots and referenced the previous topic below. Any help is appreciated! Re: Suppress NoData Tabs in Book Using Loop - OneStream Community (onestreamsoftware.com)  

Hello All, I have a cube view in which i am using on the Row Level a GetDataCell Function, example GetDataCell(Account1+ Account2): Name (Trade). on the column level i have a Comment using the V#Annotation:Name(Comments). however, on the GetDataCell the Comment is highlighted in Green. is there a way to be able to allow the user to write a comment on row that contains a GetDataCell function? 

Hello, I am new to Onestream and trying to solve something that seemed easy but it doesn't work:( We need to map an account by the entity and by the time. I used composite mapping. to be exact; A#[651200]:E#[8*]:T#2019M12} has to be mapped to account A A#[651200]:E#[8*]:T#[2019M3] has to be mapped to the account B -  also all other instnaces of #651200 for all other entities are mapped to the acount B. I have only composite mapping for this account. It doesn't work. It totally ignores the time dimension.  Any tips? thank you, Ola      

Hi Folks,I need to retrieve all cube root workflow profiles in the first parameter. Upon selecting a particular cube root workflow profile, all its related workflow profiles should appear in the second drop-down list of the combo box. Likewise, there is a third combo box for the current workflow year and time. What can be the Dashboard Data Set for this?Thanks 

Originally posted by Chris MatthewsWe are able to freeze panes with a cube view export straight to excel but when the same cube view is used in a book the freeze panes is lost. Is there a setting or way to keep the freeze panes?

Hi Team, We have a requirement like, Finance team wants to have one report with the details of Workflow Status, who certified the respective entity (name of the user) along with certification time stamp.   used the below Dash Board data set rule. followed the below steps to get the grid view Attached the Business rule to Data Adapter Attached the Data Adapter to BI Viewer. But here i am getting two certified status for the entity. we need the latest certified status. can you please help us to resolve this. Imports System Imports System.Collections.Generic Imports System.Data Imports System.Data.Common Imports System.Globalization Imports System.IO Imports System.Linq Imports Microsoft.VisualBasic Imports OneStream.Finance.Database Imports OneStream.Finance.Engine Imports OneStream.Shared.Common Imports OneStream.Shared.Database Imports OneStream.Shared.Engine Imports OneStream.Shared.Wcf Imports OneStream.Stage.Database Imports OneStream.Stage.Engine   Namespace OneSt

  Dear Team, I am currently working on updating the "Profile Active" property for a specific scenario type within a workflow profile. I am trying to implement this change using the below code snippet, but am not seeing the desired result: code snippet: brapi.Workflow.Metadata.GetProfile(si, "Parent Profile.Profile Name").SetAttributeValue(ScenarioType.Control.Id, 1300, Boolean.TrueString) Though I am aware that this update can be performed manually by accessing individual workflow profiles or using the grid view, my requirement is to execute this task through an extender rule. I've identified that the attribute index for "Profile Active" is 1300 and the value to be updated is of an object type. I suspect there may be an issue with the way I'm passing the new value in the code. I would appreciate any guidance or insight on how to correctly update this property using the extender rule. Your assistance is greatly appreciated. Thanks  

Hi,I try to get the data unit information of different DM steps, such as Calculate, Copy Data, Reset Scenario, Clear Scenario, Custom Calculate. For a regular "Calculate" I'll get the information viaPublic Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DataManagementEventHandlerArgs) As Object            Dim sbLog As New Text.StringBuilder            Try                Dim returnValue As Object = args.DefaultReturnValue                                Dim dmStepMetadataInfo As DataMgmtStepMetadataInfo                If args.OperationName = BREventOperationType.DataManagement.ExecuteStep    Then                    dmStepMetadataInfo = DirectCast(args.inp

Hi there everyone,Anyone ever created a connection between apps in the same OS environment? Working on some data movement and I have the connector set up, but struggling a bit with the connection string for the external database connection I'm setting up to reference the app I'm pulling data from. Is it the same syntax as the BI Blend connection, or are there other keywords that need to be in there?Thanks!

Does anyone know if the Smart Integration Connector is FedRamp complaint with OneStream v9?Thanks.

Hi all,We upgraded one of our OS instances to 9.0.0After a first look, it seems BI Viewer does not work anymore from Desktop app, but charts are showing from Modern Browser interface, any idea? Can't find a clue on Know Issues.On Desktop app, only the layout shows, no content:Same Dashboard from Modern Experience shows fine (I blurred data here)Any advice? 

Hi guys, bit of an odd one here.Our client is looking to leverage SmartLinks once their 8.5 upgrade is complete. We are doing testing in their Development environment and have the SmartLinks up and running (mostly) as expected. Our SmartLink navigates the user to a specific dashboard, but the dashboard is WF driven. On top of that, when opening OS in the Web, it defaults the WF to the WF the user was most recently in. I know SmartLinks is a new feature, but was wondering if anyone had any intel on how far the code can go. We prepopulate parameters with the generated link, can Workflows (Profile, Scenario, Year) be set the same way? It doesn't seem like it. Not sure how I would go about this issue going forward, however.Thanks

Hi Team,We have a client that upload excel templates using xfdrange into OneStream. They have different files per Business Unit (UD2). Two of the files run into the following intersection error during the validation step:All the other files are correct, however, when they upload these two files, all data intersections (from all other files) are suddenly also invalid intersections. For examples, the line listed here is not from either of the two files but from a seperate file that has no errors when uploaded individually). When you would navigate to "Intersection" instead of "invalid Intersection (1)" all data intersections from all files are there. Only the local users get this validation intersection, when I (administrator) would run "Validate" from this screenshot, the error dissapears.Strange thing is:they have uploaded data on this intersection before in previous Forecast Scenarios without errorsSecurity has not changed for either the application, user, workflow profile, entit

Hi Everyone, Does anyone know whether it is possible to Lock V#Annotation for input? Any assistance will be appreciated Thank you!

Just checking to see if anyone else has been experiencing the following issue with Version 8.We are currently testing the upgrade from 7.x to version 8 and have run into a huge formatting issue with our books that are produced to Excel and sent out to management via postal service. The source cube views for a batch use the same column template. We have Excel column width formatting set up for each of the columns (but consistently on each column). When the cube views are run and exported to Excel, the column width is not being recognized in most of the columns. I have tried direct formatting, I have tried with a literal parameter and getting the same results no matter what.  I don't see where I can attach the workbook itself but am attaching a screen capture sample.  In this case text wrap is set to False and column widths are set to 100.  Note the results.  Oddly, in like the first book, some of the sheets ARE recognizing the column width. I'm just wondering if anyo

I'm using the following code snippet in a Dashboard Extender Rule to loop through the list a of Workflow Profiles.  However, the code fails, if the user does not have security access to a particular Workflow Profile, returned in the list.  Is there a way I can get the list returned with security access applied, so the list only returns Workflow Profiles that the user has access to?   Dim profile As String = "text1 tag to match" Dim wfProfileName As String = "" Dim cubeRootInfo As WorkflowCubeRootInfo = BRApi.Workflow.Metadata.GetCubeRootInfo(si, si.WorkflowClusterPk.ProfileKey, True) cubeRootCluster As New WorkflowUnitClusterPk(si.WorkflowClusterPk) cubeRootCluster.ProfileKey = cubeRootInfo.CubeRootProfile.ProfileKey Dim profileInfos As List(Of WorkflowProfileInfo) = BRApi.Workflow.Metadata.GetRelatives(si, cubeRootCluster, WorkflowProfileRelativeTypes.Descendants, WorkflowProfileTypes.BaseAndParentInputProfiles)   For Each profileInfo As WorkflowProfileInfo In

Hi Everyone, Our business team would like to make it mandatory to attach a document to every journal entry.  I know this can be done via a confirmation rule.  However, one of our business partners googled this and AI returned the information in the screenshot below so they are questioning why we can't enable the setting referenced.  We can't find this in any of the OneStream documentation nor see it when creating new workflow forms or journal templates.  Is anyone familiar with this setting?  

Hi All,Does anybody have experience working with books which has dashboards as a pdf.In books, I have Report and inside it has dashboard report as a type. Why we cannot add dashboards there. It is only showing components list. Also, I am adding component like data adapter, grid, embedded dashboard but it is not working. In preview section it is not showing any report or output.   

Hello,I am encountering an error when assigning a BI Viewer to a dashboard in version 8.5.  The BI Viewer is sourced from a Cube View MD data adapter. When I run the dashboard to which the BI Viewer is directly assigned, it renders fine. However, when I run the main dashboard attached to my workflow, I receive the following error message. I have done the same processHas anyone encountered something similar before - and if so, was there a fix? I am perplexed, because I've been able to use BI Viewers in child/dependent dashboards without issue.  

I have 2 Datasource imports that I want to use the same mapping tables.  The first workflow is an actual monthly GL load.   The datasource is a comma delimited file and uses 2 different columns to determine the source value for the UD1 dimension.   The second Datasource will use an Excel Matrix to Load Budget data for multiple periods.  There is logic in the first Datasource to use the Account source value instead of the UD1 source column as defined by position.  This is based on the value in the Account source field.  See the code below: Dim Accountcol As String = args.Value 'Reminder - (2) column is 3th column in excel - need to count "0" as a digit Dim CostCentercol As String = api.Parser.DelimitedParsedValues(6) 'Identify PL Accounts (greater than 39999) If Accountcol > 39999 Then 'Need to bring in Cost Center Return CostCentercol Else 'Use Account as UD2 source Return Accountcol End If My question is  How do I create a datasourc

Hi all,What is the best way to export and import a dashboard into a new application?Do I need to select all its components every time, even if some already exist in the destination?I’ve noticed that if you select only the dashboard or the embedded version, the components don’t appear in the XML file.Thanks in advance!

Is there a way to capture mouse or pointer position in OneStream? I want to be able to change a value dependent on where the mouse/pointer is currently located within a grid. Any thoughts?

Hi Team,Quick question — has anyone else encountered this behavior in rule logic?I’m working with a standard api.Data.GetDataCell(...) call that includes the O#Top member in the POV. Here's the line I'm using:Dim baseValue As Decimal = api.Data.GetDataCell("C#Local:A#1104000000:F#CLO:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:U7#Top:U8#Top").CellAmount.BRApi.ErrorLog.LogMessage(si, baseValue)On the Cube View, this correctly returns -501 under O#Top.However, when I log the value in the rule using:-          It outputs the value from O#Import, not the aggregated O#Top result I expected.This rule worked flawlessly for 3 years until now on Version 7.4.As a workaround, I manually aggregated the base origin members in the rule, which produced the expected result.However, I’m still unclear why O#Top didn’t aggregate properly in this case, given that it functions as expected in Cube Views. I checked and compared with several other apps, i