OneStream Platform Forums

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.  

Hi team ,Good Day !I get the following error when i try to export the cubeview form in the excel format. Can some please help me on this please. Thank You 

Hi all, we are using FDX routines to extract high volume data from our cubes for external consumptions and we noticed an odd behaviour when using the FdxExecuteCubeView method with parallel processing and a NameValueBuilder parameter: we wanted to share this with the community to understand if it is an undocumented bug or else.FdxExecuteCubeView advantages:extracting any type of cube data (base/aggregated, input/calculation/dynamic)leveraging parallel processing for the given combinations of entity/scenario/time (e.g. using the FDXEntity/Scenario/Time substitution variables in the CV)Among the FdxExecuteCubeView input parameters, it is possible to define a NameValueBuilder object to evaluate at run-time other eventual substitution variables in the cube view.⚠️Unexpected behaviourIt seems that, when using both parallel processing (e.g. the FDXEntity/Scenario/Time filters trigger multiple CV rendering, with parallelQueryCount option > 1) and a NameValueBuilder object (even empty), the

Hi everyone, we come across an issue with the excel addin formula (XFGETCELL). Although all dimensions are specified in the formula, the result gets impacted by the settings of the Cube POV. Sometimes no values get retrieved, sometimes all cells with formulas show #Name or #Value. Uur expectation is that whatever is set in die Cube POV, the XFGETCELL formula retrieves the data based on the dimensions used in the formula. Does anyone of you have this issue as well? To my mind this is a bug in the excel addin. Regards Martin

Has anyone set up direct Connect to OneStream from CMS hosted on AS400 ? It will be interesting to know the challenges you faced 

I have attached multiple Cube views in one excel(Different sheets) through cube view connection. Here, i want to pull that consolidated excel file into Books. how can we achieve it. can you please help us to sort out this.    

Hi,Is there a way to see what PoV was used when a Data Management step was executed?I am not able to find these details under Task Activity.Please suggest if there is a way.Tx.

I am updating a customization to the Account Reconciliations solution to version 8.4 and have converted my custom business rules into a workspace assembly/assembly files.I added a custom maintenance unit to the OneStream Financial Close workspace to build said assembly and I am now having issues calling my assembly, specifically, the workspace assembly service factory file I created is not getting recognized.I found an instance of a button in the Reconciliation Manager MU where a button component calls upon the Integration assembly in the Integration MU using the following syntax:{Workspace.Current.Integration.WSMU}{OnOpenDetailItemTransactionDrillbackClick}{ItemID=[|!SelectedReconItemID_RCM!|]}I also have my Workspace Assembly Service that I created set on my custom maintenance unit:So after adding my own custom button (to appear on the Account Recs UI) in the Reconciliation Manager MU, I followed the same logic for executing the call, below is an example:{Workspace.Current.MyAss

Was able to "Process Cube" for October and November... in attempting to close a form for December (1Q) - now receiving this error message. The Entity Assignments and Calculation Definitions on the Workflow Profile are the same as they've ever been. Can somebody share other possibilities based on what this code is telling me? Cannot execute the Process Cube (Calculation) workflow task because the current workflow profile [Investment_Sub] has not been assigned a calculation definition.User Interface Stack Trace:   at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)   at System.Se

Is it normal for certain security settings to be "reset" when a copy of production is made to dev? Every time we make a copy of production into the development environment certain security fields within Security Roles, Entity dimension, Scenario dimension, Workflow Profiles and Data Management Groups are set to "(Not Found)" instead of the correct security group.  Is this normal? If so, what's the easiest way to update this? Thanks!

Hi all,I'm quite new in OS and, as a Dev, I'm writing some code in Assemblies/Business Rules.I'm experiencing an issue with Intellisense.While I'm working from inside a class, I can see all the hints supplied by intellisense for all the Standard/OS Classes/Methods and for the Methods inside my current class.Unfortunately I cannot see hints for my other custom classes/methods that I wrote under the same assembly/namespace (they are correctly referenced, the assembly is compiled)I tried adding triple-slash comments, but - again - no luck.Just wondering if there's something I should do to make intellisense works or if I stumbled in a platform's limit.Thanks in Advance for Your precious helpFabioG 

OneStream Support team has submitted a Bug PF-33928 to Development team to Fix the XFGetCell Issue. Issue:XFGetCell formula shows zero (instead of blank) despite setting DisplayNoDataAsZero parameter to FALSE

Hello OneStream Community, Currently working on setting up an automated process to handle BAI file uploads directly into each specific bank workflow in our OneStream application.  1. BAI Parser & Data Source Configuration - We've installed the BAI Parser dashboard to view and manage all imported BAI files. The BAI data source has been configured and initial tests with sample files have been successful. 2. File Transfer & Business Rules - Plan is to automate the transfer of finalized BAI files from our system via FTP to the OneStream file system. This requires a BR to connect with the FTP site and currently developing a BR to facilitate this connection. Once the files are in OS, they'll be imported into the appropriate bank workflow. 3. SFTP Wrapper and Workflow Integration - After the initial FTP transfer, a separate BR will be implemented to securely retrieve and upload the BAI file into the bank workflows. Question: For those who have set up similar BAI automat

Hi Team, Could someone assist me with transitioning WinSCP operations to SSH.Net? Also, is this a good move to make? Thanks, Anitha  

XFGetCell formula shows zero (instead of blank) for despite setting DisplayNoDataAsZero parameter to FALSE

Hi all, I thought this was easy but not sure what I am missing. I have a current data management job that is running off this parameter and works just fine.  Scenario=[Actual], Time=[|GlobalTime|]. I have tried [|GlobalPrior1|] with no luck I am trying to get the prior month so I have tried Scenario=[Actual], Time=[|GlobalTimePrior1|] but that is an invalid sub variable, is there another syntax to use on this? I know you can with t# in cube views but this is the DM job. Thanks in advance!

Hi everyone,In my environment, I had some calculated data in 2023Q4. 2023Q4 was completely locked and certified.After that, I loaded a zipfile, containing XMLs consisting of Cube Views, Data Management Steps, Extensibility Rules, Metadata and some dashboards. I uploaded this to update an existing partnerplace solution running in my application.After loading the zip file, the calculated data from 2023Q4 was gone. After recalculating, the data was back, so no issue. However, I'm very confused on how the load of a zip file containing XMLs could have affected calculated data in a locked period. Thanks for any help or information.Kind regards,Floris