Discuss the features and functionality of OneStream.
Recently active
I created a combo box in a dashboard and the combo box is associated with a parameter that provides a considerable list of elements for selection. The user would like to have a button to clear all the selected elements as needed. Would you know of any alternative to clear the selected elements from the combo box? Thank you for all the help.
Hi,Is there a way to show a prompt for a dashboard ONLY during the first time the user opens the particular dashboard? User will provide some POV and this should be saved to be used by the dashboard everytime the user opens it.I am thinking of creating a custom table on the database that gets populated with the username, and the POVs that the user chose. It would be best if I can make use of the dashboard parameters prompt, and just create a rule to (1) check if the user has an entry on the custom table, (2) do not show the parameters prompt if the user has entry.Thanks!
We are in cloud OneStream environment and our retention policy for Non Production is 7 days and Production 365 days ( I think ). Restore from backup does whole environment restore and not application by application. We have multiple application including PLP and I was wondering if anybody has figure out way to restore application.Any help or procedure or steps are apricated.Saurin Patel*migrated from champions
Has anyone worked yet with workspaces (loading/ extracting) using a .xfproj file? I am trying to moved a dashboard maintenance unit (DMU) out of the default workspace into a new one. However, when I export my .xfproj file (pre-7.3), remove the DMU from default, and load the .xfproj file back in I do not see it loading to the new workspace I created. Is there something in the .xfproj file that needs added to accumadate workpsaces in 7.3?
SourceA10000_0TargetA10000How can we achieve it in different ways?1. Connector SQL query -> Using this in the sql query Select left(Account, len(Account)-2) leaves blank rows in the import step.2. Data Source ? 2.a. Logical expression Return args.Value.Replace("_0", String.Empty) - This works fine. 2.b. What about Text Fill settings or Substitution settings?3. Transformation Rule ?
Base entities can be assigned to more than one Base Input Workflow. Question Credit: Chul Smith Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
I'm loading a Fixed Width data file to Stage for Transaction matching. This file has:HEADER record that has the transaction_date in it.multiple DETAIL records with transaction type and amounts (but no dates).TRAILER record (Ignore for this sample)Goal - Load the DATE from header record on every detail record.Sample FileHDR01122023DTL0088351000000572975A000000018DTL0088351000000123456A000000018TRL000000What I want to load into OneStreamRecord_1:Date: 01122023Tran Type: 100Amount: 572975Record_2:Date: 01122023Tran Type: 100Amount: 123456
hello all, please suggest if there is a way that we can stop users from running Force Consolidate for a given period?
Hi Community, We have a few scheduled calcs and consolidations running on an hourly basis, and sometimes these start queuing up and cause other DM jobs to fail/get cancelled by the system. Is there any good way to monitor or alert the admins via email if there are more than a few DM jobs getting queued up? We already have a scheduled task which queries the TaskActivity table for any failed jobs periodically and then sends out an email to the admins to address them. But this idea doesn't work for the Queued Jobs as this DM also gets "Queued" along with the others. Thanks, Sudarshan
Hi, So I have inherited a OneStream application and although I know how to build cubeviews, I cannot work out how to replicate the feature shown below on some of my existing application's cubeviews. The cubeview "parent" is referencing a row template to provide the flow lines and a column template which holds the parameter elements to select in this example the PPE Class. I am trying to recreate this layout, but try as I might, on running the cubeview it just serves a popup for the user to select the parameters, rather than docking it to the cubeview output. What do i need to select, or where do i need to place these various elements in order for me to be able to dock it like this screenshot. Thanks Mark
I am trying to figure out how to share a structure between OS BR files. In an Extender BR file named ExtenderBR I have: Public Structure MyStruct Public Element1 As String Public Element2 As Boolean Public Element3 As Integer End Structure Public Function MyFunct1() As String Return "" End Function Public Function MyFunct2() As MyStruct Return New MyStruct End Function In my Finance BR file, I include the BR\ExtenderBR from above and include a line Dim ExtenderBR As New OneStream.BusinessRule.Extender.ExtenderBR.MainClass Dim xx As String=ExtenderBR.MyFunct1() 'This works ExtenderBR.MyFunct2() 'Generates error, as the Finance rule doesn't know about the custom Structure Any thoughts how to share MyStruct across multiple OS Business Rules files?
Does anyone know how to format the object lookup cell in the cubeview? We currently have formatting on the cube view as follows. If(IsRowNumberEven = True) Then BackgroundColor = #FFFFFFFF, *white* ExcelBackgroundColor = #FFFFFFFF, Else BackgroundColor = #FFCFF0FC, *blue* ExcelBackgroundColor = #FFCFF0FC, End If If (RowName contains 'NoZebra') or (IsColHeader = true) then BackgroundColor = #FFFFFFFF, *white* ExcelBackgroundColor = #FFFFFFFF, end if In some of our reports we use IsRowNumberEven = False, but in this case I need the odd rows to be blue, but since it counts the column headers I don't know how to get around this.
How do others manage User Names in their applications? We were advised to use FirstName LastName as the user name, the Description field is not used (screen shot below). We have single sign on enabled which uses AzureSSO and the employees 5 digit number assigned by IT. We have several name changes that we have held off on making in our application. Our application includes a custom compensation model that also leverages the User Name and a separate security model within that module. We can replicate the name change in the comp model and test; however we are concerned about other implications that we have not considered. Our implementation partner highly cautioned us from renaming metadata. I fully appreciate the complexities with Entity or Account metadata name changes; however in this User Name metadata, the implications seem small (historical logs will have the old name pre change and new name post change, possibly an impact to their f
Hello, I am trying to create a FX Scenario - Acutuals at Prior Year Rate. I know i can use Constant Year For FX Rate and assign the year from which OneStream will pick Actuals rate in this case. But i dont want the user to be changing this property every year. My approach is to set "Translation Algorithm Type" to "Standard Using Business Rules For FX Rates" and create a custom translation for that specific scenario "Actuals at Prior Year Rate". Does anyone has the logic to translate the scenario using Actual Exchange rate tables switching one year back from the POV being translated?
Hello - we would like to move specific Forms and Adj data from one application to another - data are extracted via Data Export in DM, does anyone have an example of the Extensibility Rule (BRApi.Finance.Data.SetDataCellsUsingUsingCsvFile) to load the extract data? Many thanks - Wei
Hi Everyone,In our system - Profit Center is in the Entity Dim and Cost Center is in UD1. Only specific Cost Center(s) are valid per profit center, and this mapping is stored in a SQL table in the system.The need is to be able to enter data for 1 specific account, against all valid CC and PC combinations. In Cube Views - if we have Entity.Base in rows, is it possible to get the valid UD1 in the row using the mapping table?
Hi, I have an application DB table with a date column and I am using the LoadCustomTableUsingDelimitedFile function to load a CSV file to the table. The xfDateTime# token is assigned to the column in the LoadCustomTableUsingDelimitedFile function. The dates in the CSV file are in the dd-mm-yyyy format. However, the LoadCustomTableUsingDelimitedFile function assume the dates are in the mm-dd-yyyy format. Data is loaded but when querying the table using the Month() SQL function for example, the day is return instead. Is there a way to make sure LoadCustomTableUsingDelimitedFile knows the date column in the data file is in the dd-mm-yyyy format? Thank you
Whats the Table name where all the Dimensions are stored ? I need to generate/Automate a report which will give me a list of all Dimensions setup in our system. I can do it using the Extract process But I need to write a business rule to SFTP the output of the dimensions data
If you’re using a dimension for only dynamic calculation members, it needs to be enabled on the cube where you want to use that dimension. Question Credit: Chul Smith Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
Hi all, I'm still new to Cube Views and how dynamic they can be. We currently have 3 separate Cube Views, call them Canada_Results, US_Results, and UK_Results that are run independently by different users. These each have their own unique Account and UD intersections in each row. Our corporate group would have their own Cube View, call it Global_Results which displays the total results. Is there a way to build our rows in Global_Results to simply "grab" the row results from these existing Cube Views using a function like GetDataCell? We'd like to avoid creating calculated accounts or re-entering our Account/UD intersections as a formula for each row in Global_Results as that would get tedious for us to maintain. Thanks!
Hi, I have a data management step/data management sequence that use member dialog parameters, which means users are prompted for the parameters selection when running them. I have attached the data management sequence to a Pre-process step of a workflow (via calculation definition, setting the filter value equal to the data management sequence name and using a DataQualityEventHandler rule). However, when running the Pre-process step the data management sequence runs using the default values for the parameters and users are not prompted for the parameters selection. How do I make so that users are prompted for the parameters selection when running the Pre-process step?
My Cube view has entities in rows. One of the rows is a sum of several entities ( E#A1+E#A2+E#A3). In the 4 columns I have Actual, Budget, Variance and Variance%. Variance and Variance % being calculated from the two first columns. Works fine except for the row that is a sum of several entities. For this row I believe the variance-columns displays the variance for the first entity (E#A1). How can I solve this? Can I set calc order anywhere?
Hi, I'm trying to look up values from a VLookUp table (previously made in the Transformation Rules) within a Complex Rule in my Data Source, MMomentoff how could I this? Thank you very much in advanced. Best, Nieves
How do I combine XFMemberProperty with Dynamic expansion in a cube view? E.g. I want to expand Entity and account on Rows. Row1: E1 =E#Total.Base, E2=A#FinancialAssets.Base in columns I have transaction and ledger amounts (UD5) and then I want to add one column with entity currency and one with Text8 which we are using for region. Based on the entity on each row. So the XFGetMembers should reference to Row1 Expanion 1. Col1E1: U5#DS_Trans_CCY Col2E1: U5#DS_Ledger_CCY Col3E1: XFMemberProperty: Currency Col4E1: XFMemberProperty: Text8 Entity.Base Account.Base Trans CCY (UD5) Ledger CCY (UD5) Currency Text8 Entity A Account 1 10 100 EUR Germany Account 2 15 150 EUR Germany Entity B Account 1 23 56 DKK Sweden Entity C Account 1 78 78 SEK Sweden
I am trying to create a form template using all base and Origin as form.When I am running the form through WF,i get a light green shade in the fields where I need to key in data.Any suggestion as to why I am unable to see the white cells?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.