OneStream Platform Forums

Hi allI'm trying to understand the purpose of the string 'itemName' variable that is available inside the assembly service factories.Does anyone know the intended purpose of the 'itemName'?And does anyone have some best practice guidelines or examples of this variable in use? Thank you very much everyone!Thor 

Does anyone know how you can default the cell to use the cell detail or even better enforce the users to use only cell detail on the form?Thanks

We have a form in our workflow for budgeting. Users have the option of interacting directly with the form or using a spreadsheet template we provided to update their values.  There are pre-seeded values in the cube. Users can then make adjustments to the amounts. When users are updating via the form, we are getting values replaced like we would want. However, when users interact with the form and update via our provided excel file, the amounts are getting appended to the original value. We can't seem to locate where this behavior is triggered on upload to form via Excel. Is there something in the VB we need to adjust, or is this a 'standard' behavior. We'd like to let our users simply replace the values.  Let me know if you need any add'l clarifications. Regards,DK

The query from SAP is currently returning the negative sign in the last position of a cell.ex.  20.56- when it should be -20.56Is there an SAP function I can add to the SAP connector solution that would place the - in the first position and how would I achieve this in OneStream?

Dear all,Do you have any idea how we can lock a workflow that has not any attached entity on it but should be based to a UD1?Thank you 

I have a Cube View that is displaying a single dimension in the first column (Departments), and a second dimension (Accounts) in the second column.   In order to match the formatting of the report that is currently in use I’d like it to display in the first column Departments up to the bolded Total row, then accounts from there on out. In essence it would be  mix of two different dimensions displayed in the first column.   I would also like for the second column to be hidden. I have made some attempts to match the formatting as I described, but without success. Do you have any ideas on how to achieve this?   Thank you for your time in advance.

I created a couple menu components and I'm using images with them on the landing page. I read that you can use an image and also have a header text display but i can't get the header text to show with the image. Is there something special that needs to be done? I am manipulating the parent item below and thought it would be as easy as creating a header text but im not getting the desired result. Below is  a screen shot of the image and the children of the menu but I want to see some kind of value by the image that says Tasks'     'ManipulationsparentMenuTaskItem1.HeaderText = "Tasks"parentMenuTaskItem1.ImageFileSourceType = XFImageFileSourceType.DashboardFileparentMenuTaskItem1.ImageNameOrPath = "LP_task.png"parentMenuTaskItem1.Height = 100parentMenuTaskItem1.Width= 100parentMenuTaskItem1.ToolTip = "Tasks"   

I am curious if there is a way to bypass characters in a transformation rule without using a complex expression.For example,000485 (Source) -> 458 (Target)394904 (Source) -> 904 (Target) 

Hello all, I have a field in my input dataset that I am tracing the mapping for and I can't figure out why One Stream is selecting the mapping rule it is using. The field is a cost center (UD1) value of '1VA' and it is not specifically called out in one-to-one or is it included as a composite range. I really think it should have been falling out as an exception. OneStream however tells me it is applying a Range Rule 'ABC' where the rule expression = '18~21'.  I am flummoxed as to the reason why. I've double checked it a few times.  Any ideas why this range rule was selected, or maybe an idea of other areas to check out to see why the cost center UD1 mapping is behaving the way it is? Thanks in advance. Happy to add add'l details if needed. Regards, DK

Hello ! I've noticed that the workflow time stored in the application is having a weird format, for instance :  Workflow Time : 022008000 = 2022M5Workflow Start Time : 2022003000 = 2022M1Workflow End Time : 2022018000 = 2022M12 The only reason I see for this weird format is on the FX rate table (shown below), as it seems that 2022M1 is in the 4th column (hence 003 if we count column 0), 2022M5 in the 8th column and 2022M12 in the 18th column...   --> Is it just a coincidence, or am I assuming correctly the date format ?    

Hi, is there an easy way to remove rows with zeros from the Cube View when using GetDataCell? Thanks GetDataCell(S#|!Scenario!|_Allocations:U3#None:U4#None:U5#None:U6#None:U8#PCRunRate - S#PPM_|!Scenario!|_Lite:UD2#PrjNa):Name(Variance)  

Hello. I have a set of Lookup Transformational rules. I have tried to load a mass upload for multiple lines of transformational rules through a trx file. I had a message saying the load has been completed with errors. However when I try to search for one rule I can't find it in the set of rules. When I try creating one of them manually it won't let me create it as it says it exists already, even though it doesn't show in the rule set. How can I undo what I did? How can I sort it out. A lot of people are depending of these rule set as it helps with Data extraction. Please support.

Hello !   As stated in the OneStream V8.0 the release note document : Cube View Shortcuts: Cube views have been enhanced for scaling, shortcuts, andhotkeys. See Shortcuts, Scaling, and HotKeys for more information. (PF8-57) But this paragraph is nowhere to be found... does someone know what are the new shortcuts, scaling and hotkeys that we could use in Cube View starting release 8.0 ?   Many thanks !

I am executing a Copy Data Management step which references a literal parameter (NOT in Default workspace) to get the scenario value. However, I am receiving an "Invalid Parameter" error when trying to use the parameter even though I confirmed the parameter is named correctly and has a value.  However, when I created the same parameter in the Default workspace, the Data Management step executed successfully.  In a Data Management step, is there a way to denote which workspace the parameter should be coming from? I tried something like: workspace_name.|!Scenario_parameter!| but no luck. Is there any documentation on this? 

Hi everyoneIs there a way to preserve formatting in a Quick View (not Cube View) in Spreadsheet or Excel Add-in on certain row levels? E.g. Font colour for base members = Blue.With Cube Views in Spreadsheet or Excel Add-in you can highlight the levels and assign Styles but this is not available in Quick Views, only in certain sections of the Quick View grid, e.g. Primary Style, Upper Left Style, Row Header, Column Header Style and Data Style.I noticed in the 8.5.1 version documentation that this option is available when you create a new Quick View, but not in the 7.4 version we are using:RegardsJohan

Hi Community, We have a requirement to bypass lines from the source data for each account if the total equals to zero, regardless of the UD1 value. For example if these two lines are in the source data: Account 1, UD1_1, -100 Account 1, UD1_2, 100 we want to bypass account 1. Is there a way to achieve this result? in our case this is happening because we are adding UD1 in the source system and it's triggering a lot of unused accounts to now appear on our staging table because of the different UD1 members.

i have blow code to copy the periodic values from YTD scenario but it didn't work Dim sourceBuffer1a As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(S#" & sSourceForecast & ",V#PERIODIC,A#Top.Base,O#AdjInput)", DataApiScriptMethodType.Calculate, False, destination) Dim sourceBuffer1b As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(S#" & sSourceForecast & ",V#PERIODIC,A#Top.Base,O#Forms)", DataApiScriptMethodType.Calculate, False, destination)                                Dim sourceBuffer1 As DataBuffer = sourceBuffer1a + sourceBuffer1b                                                                If (Not sourceBuffer1 Is Nothing) Then             

We are looking to load data from a year-to-date (YTD) consolidated statement of subsidiaries. The statement is in matrix form, with accounts (both balance sheet and profit & loss) in rows and companies in columns. Each company has two sets of columns: one for financial results and one for eliminations. How can we set up the data source to read multiple companies' statements from one file? We would like to load eliminations to a separate origin (Elimination). How can we change the destination for the Elimination columns?  Also, how do we set up bypass row so that the load ignores headers and total rows? I noticed those rows can be identified by the Account column, where if the account is blank, then bypass. 

In v9.0, I have created all my cube views in a named Workspace (i.e. Not Default). I need to attach a single Cube View to a workflow task. In the past, I would create a Form Template Profile which I would then assign to a workflow Form Input task. In v9.0, when I select the Workflow task, I get the message (Unable to open Cube View "mycubeview"). Is this possible, or do I need to create them under the Default workspace or under Application->Presenatation->Cube Views? Thanks

Hi, I need to build some tables in the application database. I am using a extensibility rule with a StringBuilder and the BRAPi.Database.ExecuteActionQuery command to do that. The "Create table" command is working fine. Eg:sqlScript.AppendLine("CREATE TABLE [PayrollMapping](")sqlScript.AppendLine("[Payroll]  varchar(255),")sqlScript.AppendLine("[Pay_Basis]  varchar(255),")sqlScript.AppendLine("[Salary_Annual_Factor]  Int")sqlScript.AppendLine(") On [PRIMARY]") But I cannot make the "Create table as select" command work. Eg this does not work (Error: Incorrect syntax near the keyword 'Select')sqlScript.AppendLine("CREATE TABLE [EBSRegister] As")sqlScript.AppendLine("Select [RegisterID], [FirstName], [LastName]")sqlScript.AppendLine("From XFW_PLP_Register") Is the "Create table as select" not a valid command for the OneStream BRAPi.Database or is there simply something wrong with the syntax above? Thank you

Hi, Can anyone help with a way of creating username folder in Data management Export folder? This is in the File Explorer area. Is there a way to create a folder here through a business rule? Thanks a lot.    

I am recently created a cubeview report that I am now trying to add to Oneplace to allow our user community to run the report at their will.  I believe I need to do this by going through the Framework Task Setup menu but am not having any success in doing so.  Does anyone have tips/tricks to offer that can help me break the ice?  I am new to building these reports and getting them setup.  Would appreciate any feedback

Hi everyone,I’m looking for some guidance or references regarding the Forms Event Handler. I would really appreciate it if anyone could help with the following:any  documentation or examples for using Forms Event Handlersany sample implementations or best practices shared by the communityHow to use Forms Event Handlers If there’s any downloadable content (like a sample/snippet), or even just some insights from your experience, that would be a great help.Thank You.

Hi All, I am trying to use getSessionDataTable and SetSessionDataTable for loading data from a file placed in harvest folder and then using the table to store it in cube with direct approach. Can anyone provide more insight on these functions? How is it work and if there are any challenge of using these functions?

Hi Everyone. I have the following CALCULATE expression, but it’s returning no results. The source values are not zero, so I’m not sure if the way I’m using the DIVIDE function is causing the issue, or if there is another problem Dim DBCInner As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(A#RETBUYBACK:E#" & strEntTx3 & ":C#Local:O#Top:U2#INNER:UD3#COUNTRY_RPT + A#423100:E#" & strEntTx3 & ":C#Local:O#Top:U2#INNER:UD3#COUNTRY_RPT + A#411000:E#" & strEntTx3 & ":C#Local:O#Top:U2#INNER:UD3#COUNTRY_RPT)") api.Data.FormulaVariables.SetDataBufferVariable("DBCInner",DBCInner,False) Dim regionalRpt As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(A#RETBUYBACK:E#" & strEntTx3 & ":C#Local:O#Top:U2#INNER:UD3#REGIONAL_RPT + A#423100:E#" & strEntTx3 & ":C#Local:O#Top:U2#INNER:UD3#REGIONAL_RPT + A#411000:E#" & strEntTx3 & ":C#Local:O#Top:U2#INNER:UD3#REGIONAL_RPT)") api.Data.FormulaVariables.SetDataBufferV