OneStream Platform Forums

Outside if BI Blend, is there a use for the Attribute Dimensions and Attribute Value Dimensions?All of the documentation that I am reading, the search for Attribute Dimension only shows up in the BI Blend Section.

Hi,Is there any way to manipulate a workflow profile or create a new one using a business rule? If not, any way to extract / load xml in a BR? Can't find anything that would help me while browsing the api.

Does anyone have a solution to having the workflow period default to the global time? It's a minor annoyance, but for those switching workflow profiles often, it's annoying that it just always defaults back to Jan, and then you have switch to the current period. I understand that not all workflows are set monthly, but if your scenario Input frequency is monthly, it would be nice if it could read of the global time as the default period it goes to, versus just going back to a locked period.

Hello,I am running a Business Rule to extract Forecast data using Data Management task. The BR is working fine for Q1 Fcst, Q2 Fcst but when I am running the same BR for Q3 Fcst, it is failing and giving the below error.Error message -*********************************************************************************************************Summary: Error processing Data Management Step 'Export_TAX_PandL'. Unable to execute Business Rule 'extr_TEST_TAX_ExtractPandL'. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (SQL Error Number -2146232060, -2). The wait operation timed outThe process is also running fine in QA without any issues for all the scenarios.Any inputs much appreciated!! Thank you!

Hello,We noticed that Workflow on entity can be unlocked and relocked even if the parent workflow (period) is locked. We need to have a direct dependency between the parent and child workflows for the lock of the period.

Does anyone know how the "Has Data" field in an FX Rates CSV file is actually being used?   The Design and Reference Guide lists it as one of the columns in the file. I've only seen it extracted with a value of Yes in this column. What is its actual use?  Is it necessary for Loading FX Rates?  What does "No" mean, for that matter what does "Yes" mean?  

Hi, do you know where can I find the Forgot Password option? 

I need to copy one application to another, for that I am wondering if i need to go to the OneStream SQL server and extract a database ( or database schema), and if so how would i do this?The goal is to extract the entire data of an application to import it in another app

Hi All, I need to calculate the base members and roll up to Total member as shown in the below picture I tried using GetDataCell formula but am getting error, can anyone suggest how to do that.Please find the below snaps for your reference. Thanks in Advance.   

Hi everyone. I'm trying to add values to a SQL table, I have checked with several functions of the BRApi.Database, but none of them work for me. My code example:#The variablesDim sqlTest As String = $"INSERT INTO AllocationResults (Step, Amount, Annotation, SourceRule, DriverRule, Type, StepDesc, TargetRule, AllocRule, Generation, Cube, Entity, Consolidation, Scenario, Time, View, Account, Flow, Origin, Ic) VALUES (1, {Amount}, {Annotation}, {SourceRule}, {DriverRule}, {Type}, {StepDesc}, {TargetRule}, {AllocRule}, {Generation}, {Cube}, {Entity}, {Consolidation}, {Scenario}, {Time}, {View}, {Account}, {Flow}, {Origin}, {Ic})" Using dbConnApp As DBConnInfo = BRAPi.Database.CreateApplicationDbConnInfo(si)     BRApi.Database.ExecuteActionQuery(dbConnApp, sqlTest, False,True)End Using 

Anyway we can copy cell details (Amount, aggregation Weight, Classification and description from period 1 to Period 2 via business rule?  

I need to delete a single record in the Error Log but my Data Adapter won't let me, complaining about "unsafe SQL statements".In a rather bone-headed move, while developing a BR, I accidentally wrote an insanely large block of text to the Error Log -- like somewhere between 1.3 and 1.5 million characters -- in a single record via BRApi.ErrorLog.LogMessage.It's made the Error Log workspace page pretty much unusable because it's trying to read that record to display it. It takes 5 or 6 minutes to display the Error Log.After finding the UniqueID for the offending record in the ErrorLog table, I tried the following SQL in a Data Adapter to remove the record:DELETE TOP (1) from myOneStream_Framework.dbo.ErrorLog where UniqueID = 'bb5158a6-aae9-471c-b883-edddc8640a5e'Apparently, OneStream thinks I am a cyber-criminal and blocked my code execution with the following message: Database query error. The specified SQL statement is not safe.I also tried:UPDATE myOneStream_Framework.dbo.E

Hi, I am starting last month as Admin. I am trying to help one of our internal users with an issue. The amount that was imported by accounts and by base level LE_PC_CC that belongs to the gray area in this Workflow can't be seen or opened in this WF form to be manually adjusted. Is there something wrong with the configuration of the Workflow?  Thanks in advance!  

Hi Everyone. I am creating a CSV file with the information from a datatable. The problem is that it generates the file with the columns but without the datatable information. I wanted to know if there is another way to create a CSV file correctly. Dim strFilePathFull_AllocationDetails As String = strFilePath & "/" & strModelName & "_" & strScenarioName & "_" & strTimeName & "_" & dtAllocationDetails.TableName & ".csv" Dim xfeFile_AllocationDetails As XFFileEx = dtbSH.DataTableToFile(si, dtAllocationDetails, strFilePathFull_AllocationDetails, Nothing) And my function: Public Function DataTableToFile(ByVal si As SessionInfo, ByVal dt As DataTable, ByVal strFilePath As String, ByVal listColToSkip As List(Of String), ByVal Optional strSeparator As String = ",") As XFFileEx Dim strDt As String = Me.PrintDataTable(si, dt, strSeparator, 0, False, listColToSkip, """") Dim bytes() As Byte = System.Text.Encoding.UTF8.GetBytes(strDt) Dim fileinfo As New

Hi All,I am trying to run a business rule through Data Management step but getting attached error. Can anybody help me how to run the business rule from Data Management?I am also disclosing the error message belowError processing Data Management Step 'Data_Buffer_Practice'. User 'Muhammad Zubair' is not a member of the 'Actual' scenario's Manage Data Group. 

Hi,I have a Custom Calc rule called by a data management step and I am experiencing a weird behaviour. I know there is data in Actual 2023M6, and I can get that data when running the data management step from either Actual 2023M12 or MF7 (name of another scenario) 2023M6, changing the GetDataBufferUsingFormula appropriately, but not from MF7 2023M12. I'll post the details below. 

We leverage MS Azure single sign on for OneStream.It seems like lately we experienced an issue where users are not able to login using SSO.Is this a known bug with version 7.1.3.14022?The way the support team resolved it was do an IIS reset on the servers and disable/reenable SSO but we don't want to keep doing this.Thoughts???

Dear community. I have a use case where I need to sul up data from 2 different entities and apply a ratio on it. For this, I would like to use a data buffer. However, the data buffer typically only run on a data unit hence 1 entity at a time. So I created a data management job dat would run on these 2 entites, and I wanted to use a Globals object along with this data buffer so that I could store data from these 2 entities into a single data buffer. However, I'm not sure if it's the right way to do it ? Is there a way for a data buffer to take data from 2 entities ? Or, if I use a globals object with a data management sequence, is the Globals object persisting when running on 2 different entities ? Many thanks for your anticipated feedbacks ! Regards,

Hey all!So I have noticed a strange behaviour on my Dashboard buttons with Workflow navigation "links" like below: Above works great it takes me to Profile, Scenario and Name. However when I want to go to below instance, the previous year (2024) remains, even though in this case I have hardcoded 2023. I have to press the button 2 times in order for below value (2023) to kick in!I have several buttons where I use substitution variables and business rules to fetch times. But for this particular example it is not working, only difference in this case is the scenario which has some set parameters: Does anyone have any solution how to get the button to work on the first click instead of having to click 2 times? Thanks in advance! Jones 

Hello everyone,We are trying to upload data to OS through a csv but I'm getting the following errorI checked the file both with excel and directly with a text editor and it seems the amount is correctly formattedDo you guys have any idea why OS is giving us this error?

Hi - Is there a way to override security to show the IC Partners' Workflow Statuses in a Dashboard so each workflow can view altogether the status of all Partners?  I created a data adapter using a WorkflowAndEntityStatus Method Query but they can only see the Workflows they are in the Access Group of.  Can I replicate what is happening behind the scenes in the IC Matching > Show Partner Workflow Status?Thanks in advance to anyone that can help! 

Anyone has called and executed Excel function (Forecast.ETS) from within a business rule?

Hi,We would like a particular user with authority over several accountants that have certified their accounts for that user to be able to uncertify (un-certify) those certain workflow profiles if any changes are required.At present, if the workflow has been certified the user gets a warning.. has not been granted access to application role 'UnlockWorkflowUnit' for application.So how do I grant them this access ? The only group they are not in is 'Administrators', but we do not want them to have full unlock/uncertify rights, but only for the selected entities which are under the parent that they have reporting responibilty for.Keywords Unlock and UnCertify Ancestors and Unlock Workflow Unit

Hi,   Does OneStream application has any App or link to access for Apple Mac book users ? We have many leaders in our organization using MacBooks, IPAD Pro etc.. they are not able to access Onestream application now. Any suggestions ? We have recently upgraded to OS 8.1 version. 

I have an application using the culture feature. This gives me multiple member description options. When I pull a member in a cube view, it's displaying the description from the wrong culture. It's pulling from the English culture description instead of the default description. How can I change which description it displays?