OneStream Platform Forums

Hi all, I have set up Cube Data Manager. I am getting this error when I click on “Metadata”: Any idea on how to solve this? Thank youDaniela

We have a workflow structure such that each entity has it's own workflow, with a number of steps for Import, Forms and Journals.   We had an issue recently where one entity (e.g. E123) accidentally posted a journal to the wrong entity (e.g. E321). I can't see any way in the workflow settings to prevent this.  I know in the Import workflow steps there is the option 'Can Load Unrelated Entities', but I can't see anything similar on the Adjustment workflow step.

Hi, I have created an admin dashboard for forecast. I want a text box that shows parameter values, but there is a separate parameter for each Scenario. ScenarioParameterForecast_MarCopyLatestActualsToFCT_MarForecast_JunCopyLatestActualsToFCT_JunForecast_SepCopyLatestActualsToFCT_SepForecast_Dec CopyLatestActualsToFCT_NovCopyLatestActualsToFCT_Dec The parameter has either value False/True and depending on the value, the business rules that are initiated via the dashboard will do different things.  The dashboard is shared between the WFs/Scenarios.How do I create a text box that gives me the parameter name and value?e.g. when I use WF Forecast_Mar I want the textbox to say: "Forecast_Mar = (Value)"December has double parameters why I need both to be shown, "Forecast_Nov = (Value), Forecast_Dec =  (Value)". Is it possible to do this using standard functionality for parameters (e.g. create a new parameter that picks the values from the others that I then link in my dashboard). I

Hello,I am working on a navigation dashboard that includes a button to navigate to a specific workflow. The button works perfectly with the navigation action below. However, it seems that when XFPage is set to Workflow, we cannot keep the dashboard open in another XFPage.Do you know if there is a syntax similar to OpenInNewXFPage=True that allows us to navigate to the workflow while also keeping the navigation dashboard open?Thanks in advance,BeatlesForever

Hi, is it possible to hide 2 columns in a Cube View? I need them for calculation only, but hide from the report. If I set format IsColumnVisible to False or CVMathOnly for one column, it works. If I set it to two columns, I get no data on third data at all, while it should show data.

Getting this error while loading data from BI Blend table to the stage data in the workflow. We have five workflow and trying to union to load the data to the stage & eventually to the cube. However when we load from one table it fail & give column mapping error but clear data and reload next one then it goes through.    

Hi, I am encountering a few issues with dashboard creation. My goal is to display all the reporting dashboards on a single dashboard. Below is a screenshot of my current setup. I have one combo box named "Report Type," which contains a delimited parameter with options like Balance Sheet, Income Statement, and Trial Balance. Additionally, there is a list box that contains a list of report names. I’ve connected a business rule to the list box parameter to dynamically populate the report names based on the selection from the "Report Type" combo box. I also created an embedded dashboard with the main cube view. Could someone please assist me with the cube view part? Specifically, when I select a report from the "Report Name" list box, its cube view should display on the right side. Could you help me understand the changes I need to make in "Consolidated Report_Sub_CV" to pull the corresponding report cube views based on the selection in the report name list box?  

Has anyone had success with the change parameters (Variables)?  I have several reports that all have a simple substitution variable |CVTimeDesc|.  When running the book, I would like to change that Variable to predefined text, however, this doesn't seem to be working.  

Hi - we're trying to PULL files from an SFTP server. These will be used for our OneStream load. Are there any sample BRs that we can reference to facilitate the file transfer from the SFTP server to OneStream? Are there libraries readily available in OS for this?   So far, we have completed the following. 1. Whitelisting of OS IP from SFTP Server 2. Received SFTP server and credentials needed   Thanks!

I am unable to delete a Cube Root workflow for AOP due to an issue related to a workflow profile.The error occurs whenever I attempt to delete the workflow profile.I have already reset the scenario, checked all the data record tables, including the DataUnitCashStamp table, and even used a Custom Calculate BR to set the entity value to 0.I suspect that a form associated with this workflow profile was completed previously, and its log or reference still exists somewhere. Despite thorough checks, I am 100% certain that there is no data associated with this entity in any table.How can i delete the log associated with this workflow profile so i can be able to delete it  ? I need to merge AOP and Forecast under the same suffix in the cube property, unless I can delete that workflow profile, i won't be able to do that. I appreciate the help !! 

Looking for some code on grabbing all entities with a text1 field of "ABC" and then run logic on them.  I didnt see anything in the Golfstream app to use.  

Hi,So I am using one Parameter in Cube View Formatting where I am facing some issue.So there are 11 Forecast Scenario in my application.Fy25Fcst1, Fy25Fcst2 through Fy25Fcst11.My formatting rule is set in this way- If ([|!Scenario_WaterFall_MemberList!|] Contains Fcst2) Then ***Condition***End IfThis is working perfectly for scenario 2 through 11 but even if I select 10, this shows the result of 1 as well.To negate this I tried to replace the condition with  If ([|!Scenario_WaterFall_MemberList!|] EndsWith Fcst2) Then But this is not working. Can anyone let me know what can be done to resolve this issue. Thanks.JackLacavaKrishna 

Hi Folks,Can anyone give me an example of moving an entity from one parent to another using ReadRelationshipNoCache? Or even the version using GetRelationshipInfo?CopyOrMoveRelationships doesn't have a 'no cache' option, so looking to do it at a lower level by reading and updating the member's relationships (i.e. dropping one and adding another) -Jon

Hi everyone,We’ve been using the SaveDataEventHandler to prevent users from submitting zero values for a specific scenario and flow. While the error message works perfectly in the Cube Views, we’ve encountered an issue when users try to submit a zero from Excel—no error message is displayed. From what I’ve read, error messages don’t work in Excel.As a workaround, we’re considering a different approach: instead of throwing an error when a zero is submitted, we would save the zero as NotStored (dataCellStorageType.NotStored) and NoData (dataCellExistenceType.NoData). However, despite our efforts, we can’t get SaveData to function as expected. Has anyone encountered this issue or have any ideas?Dim ScenarioName As String = "Actual"Dim FlowMember As String = "USDOverrideEndBal" If args.NewDataCell.DataCellPK.ScenarioId = BRApi.Finance.Members.GetMemberId(si, dimtype.Scenario.Id, ScenarioName) Then     If args.NewDataCell.DataCellPK.FlowId = BRApi.Finance.Members.Ge

I have a book report with multiple Cube views ,Excel ,Word and and PDFs. If all together the book has 100 pages, Is it possible to show the Page numbers 1 of 100, 2 of 100 in sequence?I have tried the Cube View Extender BR discussed in this forum previously and that does display Page numbers only within the Cube view where the rule is attached to and in the format of Page 1 0f 1 ,Page 2 of 2.Page Numbering Format for Books | OneStream CommunityAppreciate any help or guidance.  

I've got a Tree View component which is populated via code in an Assembly.It currently displays all the members for a selected dimension but will can only show those members that a user has access to.The tool that is a part of is indented for cross group use so it would be useful for users to see all the members available, not just the ones that they have access to. It's purely a visual aid, not for data viewing.Can anyone advise if this is possible and what I'd have to do to enable it?Thank you in advance :-)Craig

Hi all,I'm 100% certain that I read somewhere that Version 8 would include a new XF function for Excel add-in that would allow us to drilldown on a cell whose data is retrieved via an XF function.However, now that we are upgrading to Version 8, I cannot find any information about that at all.  Even a search in the OneStream documentation does not show any XF function that allows this. If anyone has a link or more details about this expanded functionality, would you be kind enough to share that here?   Thanks in advance

I have created a macro that auto-generates excel files for upload to a workflow for adjustments, however I get the following error when the file is selected for import: This is resolved if I open and close the excel (not even necessarily saving when closing). Has anyone encountered this error before? and aware of a solution that would streamline this need to open and close files.

We want to discourage users from always running the Refresh All Tabs button every time they open their workbook.   

I have a Cube View report in Guided Reporting where the user needs to be able to select from anywhere inside of the following three hierarchies. The hierarchies contain extensibility. I am running into an issue where the hierarchies are not appearing correctly, and member are missing in the 'List Selector' on Guided Reporting.I created my parameter to pull the tree views of all three entity hierarchies.I have confirmed that the Cube View parameter selection shows up as expected.When I try to select Entity in Guided Reporting, I see the following:The only items that are showing under the tree views are the members that do not have any extensibility. Output is showing its children, but it is not collapsable to the parent. If I switch the order over the tree views in the parameter, whichever is the last one listed has its members listed out like Output does in the screenshot. I have tried multiple different ways to write the parameter out and have been unsuccessful.Has anyone else ex

Recently, our client requested that the reports display descriptions associated with specific combinations of dimensions. These descriptions correspond to the unique combination of all dimensions and are provided in the data import file.How can we achieve this? Would creating a new dimension be a viable solution?What alternative approaches could we consider? Since the model is already built and this requirement was not initially specified, we're exploring the best way to address it. 

Hi All - I have a quick question When I am using the Data Buffer, I am able to write to the Elimination Member.The Same for the Set DataCell as well.When I try to use the same in the Member Script Value it is not writing to the Elimination Origin except forms. Any Idea why ?Below is an example'                        strMemberScript = "Cb#Cube:E#100:C#Local:S#Actual:T#2022M12:V#YTD:A#123456:F#None:O#Forms:I#101:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None"'                                objMemberScriptValue.Amount = 100'                                objMemberScriptValue.IsNoData = False'                                objMemberScriptValue.Script = strMemberScript'

Hi , I was wondering if i can have dynamic POV in a cubeview without BR. Is there possibility of condition in POV for example I can put a param scenario and say whenever Budget UD1= Model and if Actual it should be 1000.  

Hello, Other than the 200 character limit, are there any other restrictions imposed on the Default Description for a dimension member? Thank you for your time.

Does anyone else have issues with locking and unlocking FX rates on the Application tab in the UI?  I can clearly see some periods with rates locked that I want to unluck, but the system will not let me unlock them.  I've tried logging out, ending session, etc.; only then do I occasionally get it to work.