Discuss the features and functionality of OneStream.
Recently active
Was going through our app to lock/certify some workflows and noticed that there seems to be a function that I have never noticed before, there is a Corporate Certification Management menu item with two sub items, Unlock/uncertify ancestors and Certify/lock ancestors. Does anyone know what this does, it's the first time I have noticed it.
Hello Everyone, I need to rename a few entities as user provided incorrect names. They loaded data already and I am wondering what are exact implications of renaming them now. I tested renaming and I can see that drill down to the source data is not possible I found another topic on this forum and I cannot find any other implication other than with drill down >>> Entity Name Changes - OneStream Community (onestreamsoftware.com) I did not find anything in documentation Can anyone confirm that this is the only implication of renaming dimension member? That drill down to the source is no longer working? Of course I know that if those entity names were used in cube views, business rules, formulas, etc., then I need to adjust them (but thankfully this is not the case here). Kind regardsJarek
An api is passed in, but typed as Object, what is object type of the correct/most efficient API to use in an Extensibility Rule to call Members.GetBaseMembers()?
I want to have an account that has a calculated value (rounding it to thousands), and then allow a Forms input adjustment to it for footing reasons. The calculated value would have a UD4 of "Calc", and the input would have a UD4 of "Footing". As soon as I make the account calculated it doesn't seem to let me input to it with the other UD4. It shows in white background indicating you can input, but I can't put anything in the cell. Anyone know if what I'm trying to do is possible?
Does anyone know if it is possible to rename a cube? I am happy to execute SQL queries if that's what it takes. Failing that are there any shortcuts for copying a cube (with all the workflows)? We have copied an application but one of the cubes (top level for workflow) must be renamed as it is out of place in the new application. Any comments or ideas will be welcome. Thanks
TeamI have a raw dataset with more than 100 Columns. I would like to connect the data and import 30 columns and have the data imported to cubeview as is. And then will manage the view in Dashboard.Basically, in Excel world am trying to put a pivot on raw data of 100 columns with output being only few of them.Thanks
Hello, Is there a way to set a requested app server name when executing a data management sequence? Thank you.
Hello,I was wondering if it's possible to change the workflow year to show FY20XX instead of just 20XX. In our legacy system we used FY20XX as our current year and we would like to continue with that style. I cannot seem to find a spot where to change it but I've seen images of other workflows with the year showing FY20XX. Thanks, Will
We're trying to export a Form into Excel and we are receiving the following error. Has anyone had this error when trying to export a form into Excel? Thanks
Hello Everyone, Is there a way to force the composite expression to run before the One To One Rules ? i am trying to run a complex expression to override values coming from the Source Data. but the One To One Mapping is triggering the mapping, what i want to Select all BS accounts from source based on the Target mapping , and import UD2 as a None Value . Instead what is happening is that all the BS accounts with UD2 value are being Mapped based on the One To One mapping i did for the PL Accounts. and i only want the PL accounts to have a UD2 Value.
Hello,Well, the title is quite explicit 🙂I am trying to avoid the standard workflow panel as often as possible. Right now, I would like for the user to select the workflow profile just by clicking a dashboard button component and access this menu : Is it possible ? Regards,
Hi, ParamA will be a multiselect combo box and the same should be passed to business rule as well. May I know how it can be done? I'm passing the parameter in calculate button, then DM step and then to BR. Calc button : {seq_name}{ParamCC = |!ParamA!|} DM step: {|!ParamCC!|} BR: Get value of ParamCC Need suggestion on how should it be passed if parameter is multiselect. thanks
OS Version 7.3.3My files are stored in a Named Workspace, "Finance WS"I want to open a file stored in Finance WS. How do I get the workspace guid to accces the file? Dim guidWs as Guid = ???BRApi.Dashboards.FileResources.GetFileResource(si, False, guidWs, strFilename)
Is there a way to make dashboards stop refreshing every time you navigate to another tab in OneStream and then come back to the dashboard?
What is the difference between 'drill down' and 'drill back' functionality? is it just the matter of different names refering to the same function? thank you.
Hi, I have a matrix data source matrixed on Account. Sample below. One of the Account fields is a Date that I need to convert to a Long to store. I can do the conversion but not sure how to target the value to convert when in a matrixed data source. If it were a delimited data source I would use: Dim sDateField As String = api.Parser.DelimitedParsedValues(6). Is there a way to identify the value in a matrixed data source? thanks Greg Code1 Entity Account1 Account2 Account3 Test1 Entity1 1/1/24 0.025 0.5 Test2 Entity2 5/1/24 0.025 0.5 Test3 Entity3 3/1/25 0.025 0.5
Hello, We are using the Excel - Addin and made some templates to work better with OneStream. It worked great, however we found that the users sometimes have the error of clicking "Submit Workbook" instead of "Refresh Sheet". We tried to customize the ribbon to separate them but it is not possible because the Refresh and Submit button are in the same tab ("Data"). Is there a way to modify it? Is it a common mistake? Thanks for the attention and best regards,
If an API and a BRAPI accomplish the same action, like returning a text field from an account, a developer can use either without consequence in a Finance Business Rule. 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 am trying to use the the GetDataCell function for both Rows and Column and the math is not working. For the row, I am using GetDataCell to sum several G/L accounts. For the columns I have Actual(C1), Budget (C3)and the 3rd is a GetDataCell (C3) to take the difference between Actual and Budget. I am not getting any errors but the Variance Column (C3) is returning the value in the first column. Its as if the second column has a zero loaded.
I am trying to create a Cube View that has 2 GetDataCell formulas. The formulas work separately but if I add them both to the same Cube View, one will not work. I am using XFBR in Columns (Time) and GetDataCell in Rows (Accounts). Is there a way both formulas will work in the same Cube View?
Hello, For a project management perspective, I would like to use the Gantt component in a dashboard. The documentation only explain that we should use XFGanttTaskCollection for that. Are there any implementation that have been using this component, any documentation to share about it ? Regards,
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...!!!
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 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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.