OneStream Platform Forums

Hello All, Our initial setup had everything copying data files to Application/Batch/Harvest folder.  There has been multiple years of files stored in this location making it unable to open.  I am trying to create something to pull the files and if folders are created to delete the stored files.  I am uable to open the path and the clean up business rule fails to run due to the size.  I spoke with some developers at Nashville Splash and am reaching out on here as well.

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!

Hi All,Any idea why the formula below won't work in CV?GetDataCell(T#|!Par_Time!| - T#|!Par_Time!|.Prior1)The first column contains the formula, and the second one contains this: T#|!Par_Time!|.Prior1. Regards, 

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?

Need to copy an IC account data (Is IC Account = True) between scenarios, one way or another, and it seems like I can't.Tried databuffer copy - no worky. Tried api.data.calculate - same, nothing copied. In the end I tried "Copy Data" data management step for the entire data unit and IC account hasn't been copied.I set "Is IC Account = False" in the account settings and the data was copied without any problem, so said IC setting seems to be the only reason.Is this normal behavior? Something I missed in the documentation?

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

Hi all,  is there any way (we might have overlooked) to not only extract headers to excel, but also footers? Thanks Markus

I am trying to replicate the example from the design & reference guideHowever, i dont seem to have a cubeViewColumn (last line in screenshot) object. The documentation does not show an example of creating this object. Any suggestion would be much appreciated.thanks 

in our initial design we have a local Admin user - OS_Admin that runs all our DM and Scheduler jobs. This was a local Admin user that pwd never changed (IT requires all AD users to change pwd's and we have too many embedded scripts with pwd for this to work).  When we migrated to V8 and the new SSO security structure was applied, we found that keeping the option for manual user sign-in created more issues for our SSO users than we could justify so we have stopped being able to sign in as this user. Issue:  We have logic that is pointing to the Global and this user's settings that drive most of our activity.  In the short-term I have changed the User based settings to point to my user but I need to get away from that. Need: I need to be able to sign-in as the local user to set the POV for WF (Scenario, Time, WF) OR is there a way I can change that from my Admin user.  Don't care either way, just need the result to be that the OS_Admin user's POV is updated. 

I am currently working on a SQL Table Editor component in Workspaces and would like to know if it is possible to dynamically change the background color of a cell after a user edits its content (e.g. highlight the updated cell in a different color). Is this functionality supported in the SQL Table Editor? If so, please share how to implement this behavior - either through a business rule, parameter or any available UI configuration. Any guidance or examples would be greatly appreciated.

Hi,  I'm trying a landing page dashboard where I can put buttons that go to various locations, both inside OneStream and outside OneStream.  Some of these links will be to files in the box or SharePoint, and some will be to other Tableau dashboards.   I'm struggling to figure out how to create the Navigation Argument so i can select it with my button component.  Where do I go to build one?  Is there a blog post or article on this?

Hi. I'm looking at a way to find all cube views used in book definitions. I was thinking of exporting all xlBook files all at a time via Load/Extract but I cannot find how to do it. Is it possible? Or would there be another way of getting that information? Thanks!

Hi! We’ve developed a custom REST API in our OneStream application to automate user management. So far, the following methods are working successfully: CreateUser – Creates a new user DisableUser – Disables an existing user Now, we are trying to add a new method: EnableUser – This method receives a user name and sets the IsEnabled property to True. The logic is quite simple. We retrieve the existing user using: Public Sub EnableUser()       ' Get user name     Dim username As String = Me._UserProperties("name")       If String.IsNullOrEmpty(username) Then Throw New Exception($"Supplied name is empty")       ' Get user      Dim userToEnable As UserInfo = BRApi.Security.Authorization.GetUser(Me._Si, username)       If userToEnable Is Nothing Then Throw New Exception($"User '{username}' was not found in OneStream")       ' Set IsEnabled = True     userToEnable.User.IsEnabled = T

Hi All, Anyone has encountered OS-CAT-0021 error while performing copy application by using cloud administration tool? what's the solution to sort out this. 

hi All, I need to upload data into the new scenario Plan with 5 years and would like to load data in parent membaers (Entity, Account and UD1), I'm using the scenario property "Allow input into Aggegated Consolidation member" but I think that this property is for another purpose. I'm coming from EPM Planning where it could be possible and many people told me that uploading data at any level is possible but cannot find any example. Could somebody help me? Thanks in advance and best Regards. Mario Guerrero

I am the admin for the application. I dont find any button to closed/reopen workflow at v 8.4.1. BUT we do have a workflow closed without any reasons and I cannot reopen it.Anyone have any ideas on this? Thank you.  

Hi all! We're looking at creating an integration from Workday for automatic maintenance of our Entity dimension - including new member creation, hierarchy creation and movements, and text fields updates. Wondered if anyone else is doing something similar? Is it a complex integration, does it seem to work relatively seamlessly? Any best practices to share? Thanks in advance!  

Was asked to create a dashboard that gives the HQ admin the ability to lock and unlock Workflow profiles. Found bits and parts to use the user POV and descendants. Unlock descendants isn't working but.. Was looking at member tree and some of the other tree functionality, but couldn't get it to work for profiles. My thought is the profile hierarchy then they would select what to lock or unlock. Was curious if anyone had any recommendations or solutions they could share? Appreciate it in advance! 

Hi, Can someone point me to a syntax cheat sheet for formatting cube views and reports in Excel? I'm trying to get this number to show in thousands and have my negative numbers be in red with parentheses, and I'm super close, but I have this odd space at the end I can't seem to solve.  ChatGPT got me here:  ExcelNumberFormat = [#,##0,_);[Red](#,##0,_))] But it's stuck there. 

I am trying to load stage data via Excel and having an issue I am not sure how to fix.  I am loading data, including for attribute values 1 and 2 (AV1# and AV2#).  However, if there is a zero in either AV1 or AV2 the row is suppressed, even if there is a non-zero value in the other attribute dimension.  Is there a way around this behavior with a special token I can add or some other change?

Hi all, I'm just trying to get a feel for how common this use of proxy members is these days.  I've worked for multiple organizations and typically, if we were planning at any level higher than the most granular level of data, we would plan a number representing a group of members, at some 'proxy' member created specifically for planning purposes.  That is, we would not use some random existing base member that held actuals. For example:If our dimension hierarchy looks like the one below and we were planning at the Region Level:I would not plan for the entire RegionA by loading my planning data to "South3".Instead, I would create a unique member (say, "RegionA_Plan") and load my data there.Wondering how many companies out there would use the first method rather than the second method and what advantage there would be to this?Thanks in advance for your thoughts on this.RegionA     North        North1        North2  &n

I'm having trouble with a dashboard I'm building. I want to display either an IS or a BS on a single dashboard frame based on user's selection. I've created a list parameter with the options "Income Statement" and "Balance Sheet". However, no matter which option I select, the dashboard only displays the IS. I suspect I'm missing a step to properly link parameter selection to switch between the two reports. I don't have much experience with multi report dashboards up to now, I've only worked on single report dashboards. Could someone help point out what I am doing wrong or guide me on how to make the report dynamically switch based on the parameter. Thanks.

I am trying to configure a data adapter through the service factory. The assembly containing the services factory is on another maintenance unit. The assembly is WsasFactory and when attempting to bring the data set into an adapter it can't seem to find that object reference to the assembly. The assembly and service factory are configured on each maintenance unit and workspace as shown: MyAssembly.WsasFactoryWhen attempting to bring it into the data adapter I have tried using...{WSMU}{MyDataSet}{}{WS}{MyDataSet}{}{Workspace.Current.WS}{MyDataSet}Yet, I keep getting this error for each reference shown above - Error processing DataSet 'MenuNavPM'. Unable to find the Workspace Assembly Service Factory class for name 'WSMU' in Workspace Is there a reference special for using the service factory between maintenance units I am missing? 

Hi everyone, My employer recently migrated from v7.4 to v8.5, and one of the new 'features' is the ability to rename journals before submission.  Due to internal processes we'd like to restrict users from making any changes to journals names (regardless of their status) as they must follow a predefined naming convention.  Based on your experience, does anyone know if this is possible?  Thanks, SERGIO

Hello ...  We are trying to output the formula for Accounts of type DynamicCalc in a cube using an U8 member named U8#AccountFormula. In this member we have defined the following: Return api.Account.Formula(api.Pov.Account.MemberId,API.Pov.Scenario.MemberID,Api.Pov.Time.MemberId) The code above only seems to work for all Accounts except type DynamicCalc Is there another function we should be leveraging? Thanks