OneStream Platform Forums

Dear Community, For an allocation purpose, I would like to load data currently stored in a data table, into a cube. But to speed up the process, I would like to ignore Validation and Transformation steps. Is there a way to do so ? Regards,

Does anyone have example code they'd be willing to share here that allows the Intersection Error report to be attached and sent via email when errors are encountered during *automated* load processing?Our users are being notified that an error has been encountered, but they have to log into OS to look up what the error was (new unmapped account, etc.). It would be nice to provide the error detail as an attachment or in the body of the email.Also just curious how others in the community are notifying users that Load Errors have been encountered during automation, and providing the error detail to them?Any input is appreciated.Thanks!

Hi all,  We created a test account to load some test data into but we now would like to remove the account. How would I go about clearing the data from the account in order to delete the account? The data was inputted into the account using an XFSET function.   Thanks!

Hi!   I’m trying to create a cube view that can drill down to stage detail data. Is there any documentation on this?  Any input would be greatly appreciated!

Is there any way for me to rename different scenario types(from the 24 scenario types) and also add a new one?

New to onestream and doing some training and have sandbox env to play around with it. I have questions on the cube design and extensibility.  I am trying to extend account and product dimension to fit to my three cubes even though level of entity will be the same in two diff cubes. How would I go about? e.g I want to reallocate my salary based on NetSales.Can I have two account dimensions? I cant think of how I am going to do allocation. Or I just need one cube & have everything in their but that will decrease performance, I guess.    

Hello! I'm an Enterprise Applications Business Analyst and we are looking for a RACI chart that shows the intended usage of the OneStream tool to better understand who and how to support our clients (Finance). We currently use Financial Reporting, Account Reconciliation (without Trx matching), and Capital Planning. Does anyone know if something like this has been created by OneStream? Does anyone have one from their organization? Thanks!

Hello everyone, Is there a way to collapse/expend column via a native display configuration on Onestream (v8.1) ? Something same as the RowExpensionMode option in the Header Formatting but for the column. Thank you in advance.

Is there an upward limit on the number of blank lines that can be kept in a journal template?

Hi everyone, I'm just trying to set up a sandbox of the OneStream server for my own learning.  However, I'm not very knowledgeable on the database side and am not sure how to set up the databases required for the application.  I've installed SQL Server Developer version but as I'm not a database person, I'm not sure how to create the underlying databases.  Unfortunately the OneStream guides I'm following don't go into the details of the steps within the database (understandably).  Does anyone have any guides or describe the steps needed to create the underlying databases for the server? Thanks,

We have users experiencing connection conflicts with the OneStream Excel Add-in. When they enable the OneStream add-in it disables the add-in they have for their ERP. They would like to be able to use both add-ins at the same time. How can we enable them to have both add-ins active? Have there been similar issues? What is causing their ERP add-in to be disabled? 

Hi OneStreamers, I am using the table vStageSourceAndTargetDataWithAttributes in a dashboard to display cost centers (Source Account) and Accounts (Target Accounts) per all other dimensions, for a selected entity and period. It's working fine but the amount from the table is always in the local currency of the entity, and I'd like to see all amounts in EUR. Is there an easy way to convert the figures in the table ? I saw there was a column named "Converted Amount", maybe it can be used somehow to show translated figures ? Appreciate your insights on this. Adam

This seems like it should be a no brainer, but I've spent a couple hours trying to figure it out and googling for a solution and I have nothing. I am trying to export data to a file, but my BR is written in C#.  I can do it with no issues in VB:  'Prepare the Extract File path Dim configSettings As AppServerConfigSettings = AppServerConfig.GetSettings(si) 'Data management extract location Dim folderPath As String = FileShareFolderHelper.GetDataManagementExportUsernameFolderForApp(si, True, configSettings.FileShareRootFolder, si.AppToken.AppName) & "\" & DateTime.UtcNow.ToString("yyyyMMdd") & "\Extracts" 'if the diirectory does not exist create. If Not Directory.Exists(folderPath) Then Directory.CreateDirectory(folderPath) ' full path and file name for extract Dim filePath As String = folderPath & "\AppTypes.xml" 'if file already exists If File.Exists(filePath) Then File.Delete(filePath) File.WriteAllText(filePath, outer.accountRecs.ToString); I tried to conver

I am trying to insert a row into a OneStream Application SQL Table through the SQL editor Dashboard component.  I am getting the following error message.  Is this something that needs to be changed in the SQL or a component setting I need to change.  At the moment I have not added anything additional to my SQL create table statement except the column names and a primary key for the Row Number.  

Is it possible to use Cubeview Parameters in XFGetCell ? Saurin

I have a Cube View that uses a parameter 'pm_EntityList' in the POV to let the user select an entity.Its possible that the same parameter can exist in both workspaces.In my case, the parameter is defined in both the default workspace and a workspace named 'CustomerWorkspace'.If I specify |!pm_EntityList!| in the entity POV for my Cube View, which parameter will the cube view look at?Taken a step further, lets say there are two Named Workspaces with the same parameter.  Now which one is evaluated?

Hi all Can I copy a journal using a business rule? Cheers

I want to round the values for the Revenue account for all UD2 members to whole numbers. Do I have to get the values, round them and write the value, or is there a simpler method?

Hi all, Short question. I have a message similar to this:  "Unable to delete member 'XXXX'. Error removing member. Member 'XXXX' has data. Same as in post Unable to delete Entity member - OneStream Community (onestreamsoftware.com) With the exception that the cube is clear (in total there are 2 cubes; one without data and the other doesn't use the dimension in which the member exists). Should it be data somewhere else? If it is the case, where? Thank you. BR, Carlos

With v7.4, it's now possible to create separate Maintenance Units, to isolate a "solution". But with that also the new "Dashboard Type" have arrived, including "Custom Control", but also a new Navigation Action on a button, called: "Forward Custom Control Action to Parent Event Listener" Anyone have experience in how this works, or where I can find more documentation or examples of the functionality

Does anyone know what this message is talking about. Sorry...new. Users are trying to drilldown by 3 dimensions in the rows and are only getting approx. 6 rows of data and then the message under the output. Their row settings are at 10,000.   Any help would be appreciated.... James

Hi Guys, We are upgraded to V8 and now need to update our integration to SAP BW as well. As of now, the ERPConnectStandard20.dll has added in the assembly folder under the gateway server folder. And per the SIC guide, only the smart integration function business rule can used to call ERPConnect function, so we believe the steps should be: 1)Build smart integration function business rule to extract data from SAP BW 2)Using connector business rule to call the above function for processing in the Import step But we didn't found any sample for this. Appreciate if any input or sample code on this. Thanks,  

Dear Team, Does anyone know what's the updated version of function SetCultureInfoForUserToThread? I thought that like with other functions I just can see it's new version using intellisense, however nothing appears here. Many thanks!  

Hello, I created a new Scenario and assigned it as ScenarioType 3. I went into Application Properties and made sure ScenarioType2 general and dimensions were set up for it. I then went into the Workflow Profile and created a new Form under one of the workflow and it is not showing up. Did I miss something when I setup the new scenario? Thanks, Will

Hi There has anyone had an issue at their clients previously where the OneStream excel add in keeps disappearing?It’s becoming a problem as some users don’t have the option to add back and have to contact IT all the time to assist.Anyone experienced something similar, if so, any ideas on how we can help fix it?