OneStream Platform Forums

I'm trying to load a file that has data in multiple columns like below.I have created the data source with a Data Type as Matrix DataKey and created source Time Dimensions for 12 months as stated in the screenshot. But when I try to load the data, I get the below error every time. I have already created transformation rules for Scenario and time as below and not sure what else I'm missing here. Can someone please help with this one?Error Message: Thanks...!!!

Is there any way to create a Cube View or Dashboard which has the ability to drill through without logging into the Application? The non authenticated users should be able to access the artifact and view the data. Any help would be appreciated. Thanks

Hello, I am getting this error when trying to access FileShare under FileExplorer:   The path is not of a legal form. .Source code: WcfRetryManager.cs, line 299, method ExecuteRetries..Source code: WcfRetryManager.cs, line 369, method ExecuteRetriesStartingWithPreferredAppServerIndex..Source code: WcfRetryManager.cs, line 497, method TryExecuteAction..Source code: FileSystemWcf.cs, line 198, method EnumFoldersInFolder..Source code: FileSystemWcf.cs, line 853, method GetFolder..Source code: FileSystemOS.cs, line 185, method GetFolder.The path is not of a legal form.   Has anyone encountered this error previously? To me it seems like an application error but I am not sure where I can check further. Thank you.

I’ve noticed in working with the newer versions (that have Workspaces), that the SetLiteralParameterValue seems to only work on literal parameters in the default workspace.  However, I’m unsure if this is a bug or if this is by design.   My understanding from I saw at the Wave Conference was that Workspaces were intended to be used for better grouping of solutions, versioning, and development.  Currently, they support the creation of identically named parameters in multiple workspaces.  If you’re attempting to update a literal param in a specific workspace… is that even possible?  If not, are all active solutions intended to be in the Default workspace only?  Could someone please advise on the intended usage of Workspaces?

I am trying to get the description for prior year in my Excel header for cube views. There is a substitution variable for current year but nothing for prior year. Anyone have any suggestions? Instead of the format 2023M3, I want the header to bring in the description that says March 2023. Below is my current year variable.

I am trying to use a dashboard button to Select All and Unselect All values in a Multiselect Combo-box which I am passing to a Spreadsheet (TableView) business rule. I have tried to run a Data Extender rule from a button that clears the data using the code below:  Dim selectionChangedTaskResult As New XFSelectionChangedTaskResult()selectionChangedTaskResult.ModifiedCustomSubstVars.Add("lv_BusinessChannel", string.Empty)selectionChangedTaskResult.ChangeCustomSubstVarsInDashboard = True ' Set the Return valueselectionChangedTaskResult.IsOK = TrueReturn selectionChangedTaskResult

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! 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?

Hi All,We're running into a few problems with an existing BR that is used to change the state of the current workflow. The current BR is used in the admin workflow & we haven't encountered any problems, however when end users attempt to run this rule on a child workflow, they receive the error message below.Business RuleIf args.FunctionName.XFEqualsIgnoreCase("WorkflowStatusUpdate") ThenDim strChangeType As String = args.NameValuePairs.XFGetValue("ChangeType")Dim selectionChangedTaskResult As XFSelectionChangedTaskResult = Me.WorkflowStatusUpdate(si, strChangeType)Return selectionChangedTaskResultEnd IfWhen an admin progresses the workflow the end users are able to execute the subsequent steps to complete their workflow. Is there something I'm missing in the current rule that needs to be changed or is this an issue with our security setup?Thanks,

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 ? 

We would like to combine two of our cubes into one.  Some of the UD dimensions will change in the new combined cube.  Is it best to start with a new application?  Any suggestions?

    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

Hello, I hope someone can help me out with the following issue.   We are trying to add the Report Header/Title to a report, but we would like to have it dynamically adjust to the width of the CV or Report itself (so also fill the yellow highlighted space). When I try "-1" (how you would do it in the CV settings) it becomes very small.   Furthermore, I would also like to remove the light blue line under the header (or make it the same color, dark blue). I tried to adjust this in 'Application | Application Properties | Standard Reports' but with no luck.   Thanks in advance for your help!      

When using a Parameter to specify a member in a CubeView, how do I specify which Workspace the Parameter is in?  

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 

I am trying to create a Cube view report that should show English Description of Entity members istead of default Description. Is there any XF member property function to do the same or any other solution?   Thanks, Neha

hello all, please suggest if there is a way that we can stop users from running Force Consolidate for a given period? 

Hi,   I'm trying to setup a variance account under UD8 that will calculate the variance between the current year last 12 months and the prior year last 12 moths. Any suggestions on how to write this formula? Thanks.

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 have heard that Onestream supports ad-hoc queries and reporting. But I haven't yet found an easy way to send ad-hoc queries to our OneStream cubes. I'm searching for some sort of query interface like SQL, MDX, or DAX.   So far I've discovered that there is a REST API which allows me to retrieve data from an existing "cubeview". This is a helpful API for extracting data programmatically. But this certainly isn't considered "ad-hoc" since it requires that a cubeview be prepared and deployed in advance. I had also seen that the REST API supports SQL statements but I have been warned against using those; since it circumvents the logical definitions of the cube, and these queries might become fragile and break over time (eg. after future upgrades to the onestream platform). Besides those two options, what mechanism is available to send "ad-hoc" queries to OneStream, and immediately retrieve the results. Our CPM data is very valuable to client processes, and we've been able to accompl

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?

Hello All, Need assistance in getting the USD Override amounts to populate Local Currency Parents in USD values.  The USD Parents are working correctly when data is retrieved in Local or USD. Example Local Curr Entity CNY (rate .800) - 2000, USD Override - 3000 USD Parent Entity (USD) - 3000 Local Currency Parent (CNY) -  CNY - 2000, USD - 1600