OneStream Platform Forums

Hotfix  8.4.3 addresses, among other things, security vulnerabilities found in the third-party Roslyn Compiler DLL.  How do you know if you are using the Roslyn compiler in your implementation of custom code and, therefore, at risk if you are?Is the Roslyn Compiler only used by the WinSCP libraries (and therefore its removal is WinSCP-related)?  Or are there instances where Smart Integration Functions would be using the Roslyn compiler outside of the use of WinSCP?  

Hi all, We have an interest in being able to provide the Map Changes Audit Report (out of the standard Application Reports dashboard) to a group of users via the Parcel Service function. I've been able to narrow down the application report itself to an "RPT" component but not sure where to go from there. Has anyone out there managed to set this up and if so, would you mind providing a high level view of the steps involved? Thanks very much in advance, Kim

Hi OneStream, Please let me know when shall Core Platform Architect certification exam become GA? In the exam portal i still see OCP - LA certification exam. Thank you,

Hello everyone, We have set up a monthly forecast that is compared to the budget or actual figures in different cube views.  We currently use a parameter to select the forecast month in each cube view, but I would like to remove it and have the latest forecast for the year or year N-1 displayed automatically. I have created an XFBR that retrieves the holding company's turnover for each of the 11 forecasts (January, February, etc., November) and displays the forecast closest to December with a turnover.  The problem is that not all users have access to this company, so the BR does not work for them. I could change the BR to add companies to it so that it works for all users, but I find that cumbersome. Is it possible to save a value (X or 1) in a variable when initializing the forecast so that the BR can query this variable based on the Time scenario and thus know which forecast has been initialized? How do you do this in your OS?

Hi all, is there a way to open the "Workflow Multi-Period Processing" page from a dashboard button?we were able to open the pages for specific time (YYYYMM) and the different steps Import, forms, Adj. But what about the Multi-Period processing which is exeucted at the year level (e.g. 2025)? Which is the Workflow name to use in the Change POV and Workflow button POV Action?here is how we set the button  Can anyone help?Thanks and regardsMassimo

Hi !When working on Data Adapter method types, there is alsways a mention about a filter, like here for the WorkflowProfile method : Example: {AllProfiles}{Empty String or Filter Expression}.However, what are the different filter expression available ? So far I was able to use "=" or "<>"... is it possible to use contains, do not contains, like ? Many thanks !Regards,

I am trying to calculate Average Percent Period Movement (AVPPM) — i.e.:AVPPM=Actuals(Current)−Actuals(Prior Period) / ∣Actuals(Prior Period)∣×100 = and store the result in S#AVPPM for the current POV.I tried using the below script in Business rule or Scenario member formula for S#AVPPM but not getting the correct result. api.Data.Calculate("S#AVPPM = (S#Actuals - (S#Actuals:T#POVPrior1)) / (ABS(S#Actuals:T#POVPrior1))*100", True)Appreciate any help!

Hi,We are transitioning over to OneStream version 9.0.1. As part of the transition, we are running validations on the data we have copied over from our previous environments. We are running reports like quickviews & XFGETCELLs to retrieve data. However, after clicking on Refresh Sheet/Workbook, we are prompted with the error message: Microsoft excel is waiting for another application to complete an OLE action Does anyone have a solution to this resolve this issue? This is holding us back with our validations, ultimately affecting our go-live date if this issue persists. We would not feel confident going live if this Microsoft Excel error continues to impact our user base from running their reports.  For additional context: Microsoft Excel is 64-bit version Excel Add-in version 9.0.1 is installed.  Tested on multiple reports along with recreating reports Tested with multiple users/devices

Hi All, In our multi year planning process, most entities need to upload four sets of fixed costs (all loaded by the same team, but sent to that entity's finance team by different functional teams), in addition to all the driver-based costs we're calculating (mostly based on form inputs).  For the four sets of fixed costs, we have four import profiles under the same parent workflow.  The entities import their files and then run a DM sequence from a dashboard to run the validate/load for a range of years they can select.  When they run this sequence, all import profiles (under the same parent) that have been imported are validated and loaded.We had not set up workflow channels on the different loads, and everything was working as expected.  The different import profiles will use some of the same accounts, but different sets of cost centers.  We did not see any collision of data when the same accounts were loaded, and if a balance that had previously been lo

I've created a form template and assigned it to a workflow profile. However, each time I access that workflow profile, I have to manually click on the form to open it. Is there a way to set a default form template so that it opens automatically when a user navigates to that specific workflow profile?

Hi All, I created a Business Rule to export all the GROUPS that i have in OS applciation. i try to export the data in a file. i tried below option , it did not work created BR and executed there as File output Created a Data Management Sequence and added 2 steps. 2 for BR and other for File Export. But my File export fails as NAME Empty Below is the error Error processing Data Management Step 'ExportGroups'. Name is empty. Below is the BR i used. Imports SystemImports System.Collections.GenericImports System.DataImports System.Data.CommonImports System.GlobalizationImports System.IOImports System.LinqImports Microsoft.VisualBasicImports OneStream.Finance.DatabaseImports OneStream.Finance.EngineImports OneStream.Shared.CommonImports OneStream.Shared.DatabaseImports OneStream.Shared.EngineImports OneStream.Shared.WcfImports OneStream.Stage.DatabaseImports OneStream.Stage.Engine Namespace OneStream.BusinessRule.Extender.BRGetAllGroups_1    Public Class MainClass  &nb

Is there a function, or other method, to get the workflow an enitty is assigned to, if it is assigned?  Seems like an there should be an api for this but for the life of me I can not find it.  Thanks in advance.

Hi, I've created an XFBR String Service file, and I would like to reference other (also XFBR String Service) files to break up the XFBR rule to manageable pieces. I keep running into compile issues. Any insights would be helpful. Thanks. Here are the screenshots of what I have: -Main XFBR String Service file (referenced in the Service Factory): -The secondary XFBR String Service file I'm calling & error: 

Hi  i am trying to fit row in one page for display. now data is shown in different pages

Dear Community Members,Due to my error in the initial definition of culture codes I ended up with two es-MX local language options in the dim library.I removed the es-MX culture code. One of the two options went away in the DimLibrary, but the second one persists.Then i removed all descriptions from the MemberDescription table where CultureCode = es-MX.  Still the DimLibrary shows Spanish AND even more surprising shows the Spanish descriptions.Which leads me to believe that those descriptions are cached somewhere?Any tips?  My ultimate goal is to have es-MX culture code and local descriptions. But only one Spanish in the DimLibrary.SystemConfig (this is a locally hosted client) only has en-US definedMemberDescription Table has only Englishbut DimLibrary still has Spanish descriptions but only where defined before. Other members that never had a local translation do not show Spanish (Mexico), see Scenario Actual below.Thanks in advance

Hello, We are implementing the task manager and one of the requests is for the users to be able to know when comment is added. Is there a way to build business rules so email is sent when comment in TM is added. If someone already has it would you be willing to share it? thank you, Ola

Does anyone have any information/advice on testing applications in OneStream? Are there gotcha's or must test items?

I am trying to add an advanced chart and BI viewer charts to an extensible document. I know I can change the alt text on an image using {XF}{Application}{CubeViewReport}{CubeViewName} but am wondering what the reference would be to add in advanced charts or BI viewer items. 

Hi, is there a way to copy the list of all functions displayed after args.cubeview.?  

Hi,  I am in the process of testing security for applications. I have view dimension library access, I do not have manage meta data access. I have added security groups to access and maintenance groups for which i only have access to "Access group". I cannot edit any members, which is correct based on my security, but i am trying to understand the reason why the meta data is not greyed out? It appears as normal, and i can edit, but when i try save the changes, it says i do not have access. Which is great, it means it works. I was just expecting it to be greyed out like for example cube views. Just curious as to why meta data isnt greyed out as well? Would appreciate any feedback

I have a Cube View that displays Multiple bas members (for example: Tokyo, Osaka, Berlin and Munich) as columns.When I click on the Report button, the report currently includes all four columns which matches my cube view setup. However, I want to customize the report output so that it only include few selected columns (for example Tokyo and Berlin) while still showing all four columns in the Cube View itself.I want to achieve this using an FDX functions.My questions:Which BR type should I use for this requirement?How can I apply column level filtering in the FDX rule so that only selected base members appear in the report output, while keeping all members visible in the Cube view? 

I have an AIP (annual incentive plan) input form whose input range from 0 to 2. Can I create formatting rules to restrict users from entering any number beyond the mentioned range?

Hi all, Could you please advise how to find error in Excel file which we try to load in OneStream on Import step of workflow. When I click Process button after uploading of file, I see the below message:  Invalid URI: The hostname could not be parsed. Unable to execute Business Rule 'ADU_SolutionHelper'.A malformed URI was found in the document. Please provide a OpenSettings.RelationshipErrorRewriter to handle these errors while opening a package.   

Hi    I'm working on a PDF report where the font size is currently very small and difficult to read. I’ve tried adjusting it but haven’t been successful so far. Could someone guide me on how to increase the font size in a PDF document?    

Please share your practical advice to secure Workflow Profile Hierarchies per the two requirements below. Thank you. A. Workflow Profile Hierarchies: Admin v Builder/Business0. 'Cube Root Workflow Profiles' | Admin and Business | Top Level Cube_suffix1. 'Default/Child Workflow Profile Types' | Admin/Business 'Cube Root Workflow Profiles'2. Admin 'Parent/Child Workflow Profile Types' | Admin/Business 'Cube Root Workflow Profiles'3. Business 'Parent/Child Workflow Profile Types' | Business 'Cube Root Workflow Profiles B. Two Workflow Requirements: Admin v Builder/Business1. Builder not allowed to see/create/edit:- Admin 'Cube Root Workflow Profiles'- 'Default/Child' and Admin 'Parent/Child Workflow Profile Types' | Admin 'Cube Root Workflow Profiles'- 'Default/Child Workflow Profile Types' | Business 'Cube Root Workflow Profiles'- Admin 'Parent/Child Workflow Profile Types' | Business 'Cube Root Workflow Profiles'2. Admin/Builder allowed to see/create/edit:- Business 'Cube Root