OneStream Platform Forums

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?    

Hi,  at the moment we are migrating OS from v6 to v8. The logon procedure in V6 and V8 is SSO, while login in V6 on there is a small pop-up window to choose an account for OS. This pop-up automatically closes after the choice. In V8 the button External provider sign in is not there, instead via logon it opens a full window that does not close automatically.  is there are solution to get this full web-page closed in v8?   thanks,

We have Workflow A, and Workflow B.   We get an error when the loadCube step in workflow B, when Workflow A is in Validation step.  The error we get is "Cannot execute step because the prior workflow step is not completed. . (WP#WorkflowA.Import:S#Actual:T#2022M1)"   The name the actual workflow has been changed to protect the innocent. Our question is:  what is causing this issue and how do we fix it?  It's not clear in the documentation what exactly triggers this error message.  The parameters passed back imply that one cannot load to the same scenario and time if another workflow to that scenario and time is still open.   WorkflowA and WorkflowB are loading to the same scenario and time, but to different accounts. 

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

hi All, good day. I created a Book using cube views reports and App database files (text editor file including DOCSVARIABLE), I used a filter in time dimension to select the period, when I run the book, even in preview, I select the period and the cube views refresh the data but not the App database file; do anyone knows if I need to do something for refresh the text editor?   also if I change the text editor adding or modifying the cube view, the file delete the new cube view and the modified; is it a bug?   Thanks in advance and best Regards

Hello,We are trying to find the best way to determine if a user is using web-based or Windows App OneStream environments to customize a dashboard experience. For now, we are using the si.WebServerURLByClient to determine this which works but seems a bit clunky. Is there a better call to determine which environment a user is in? Thanks in advance.Brett

I need to automate a process of Extracting certain Dimension Descriptions into a Comma Delimited text file for exporting into PowerBI.  The application extract puts it into an XML format, and I need it into a comma delimited file.  Any suggestions?

Good afternoon, I need help with translating a balance account. We set it up to calculate job to date and load its local currency value, then I wanted to translate it using a job to date rate (also setup as the balance account). The formula attached to the account is for every foreign base entity executes this: api.Data.Calculate("A#JTD_COST:V#YTD:F#EndBalLoad:U8#None:C#USD = RemoveZeros(A#JTD_COST:V#YTD:F#EndBalLoad:U8#None:C#Local * A#JTD_FX_RATE:V#YTD:F#EndBalLoad:U8#None:C#Local)",,,,,"U1#Active.base")   The problem is that when I set the original account with  Formula Pass then I get an error during the consolidation suggesting the invalid destination data unit in script. When I don't attach any Formula Pass then nothing happens at all.  Any suggestions what I miss or how else  balance accounts can be translated? Thank you, Ola     

Hi All,In your OneStream implementation, how many environments do you have?  Dev, UAT and Prod?Or do you also have Pre-Prod environment that is common in ERP systems?Also, in the UAT environment do you also have copy of data so that when testing happens or developers need to test the changes - there is enough sample data to test?Would you consider brininging data from Prod, randomize it and load into UAT env so that UAT env data at all intersections as Prod?Thanks!

Here is the scenario: I have a Combo Box that holds value "Summary View" and "Detailed View". Based on the combo box selection value in the dashboard, the CV columns needs to update dynamically in CV. Summary View should have all columns except "Variance" Column. And when Detailed View is selected, This should have all columns including 'Variance' Column. The tricky part is that these are shared columns from another CV. And we already have a formula for 'Variance' column in XFBR. In Short: When Summary view is selected, Variance column should hide and when Detailed View is selected, all columns should show up! Any idea or a suggestions are greatly appreciated! Thanks. 

Hi! We are trying to control the size increase in our production application. We know the growth comes from: Stage tables that allow users to drill down and back onto source data. Data records Audit tables (they can grow a lots if they are recording continuous changes to rules, data for example) Logs which will impact Framework database growth (task activity and error logs, will vary depending on the detail login set in BR, DM and on the system configuration as well as your retention policy) Load transactional data, which will increate your data units and data records unnececarily, which BIBlend should be used for this type of data load instead of loading it to the finance cube. We have analyzed it and we realized the StageAttributeTable and other stage tables has a significant size. Has ayone performed databse maintenance by deleting data from the stage tables? Is it possible to do that while keeping the cube data intact and workflows completed? Any ideas or best practices regarding

  Is it possible to add members to both main and alternate hierarchies using EventHandler from source. Was not able to achieve using existing code. Below code is being used to add new members from source to the Flow dimension which works for main hierarchy but not adding under Alternate hierarchy, any help is appreciated. The new member needs to get added under both parents below     Dim flowDimName As String = "Product_Attributes" Dim flowMF As String = "F#TopProductAttributes.Base" Dim flowLookup As Dictionary(Of String, MemberInfo) = Me.CreateMemberLookupUsingFilter(si, flowDimName, flowMF) Dim ExistflowLookup As List(Of MemberInfo) = BRApi.Finance.Metadata.GetMembersUsingFilter(si, flowDimName, flowMF, True) Dim flowAddedMembers As New Dictionary (Of String, String) 'Set the parent to add new FLOW Members under       Dim tFlowColIndex As Integer = (objTransformer.TransformerDimensions(StageConstants.MasterDimensionNames.Flow).DataTableColumnIndex) + S

Hi everyone!!I am trying to share a total amount that is calculated form one cubeview to another but it will not let me if I do not bring the source rows for the calculation (From the 1st CV to the 2nd) but I only want the totals. (If anyone knows how to do this great!!)My other alternative is to bring those rows and hide them. Does anyone know how to do this?Thanks!!! 

Hi All,We have a parameter attached in the entity POV of all our cube views, and it works perfectly on base level. However, not in the review level workflow.Is there a way to include dependent entities in a review-level workflow via XFBR String? The entities in the review level are dependent, coming from the assigned entities in base level workflows underneath it.I have tried using objList = BRApi.Workflow.Metadata.GetDependentProfileEntities(si, profileKey) with no luck. Perhaps I am missing something.Bound list has been tested as well, and attaching the parameter in the POV of a cube view, only works in the base level workflows as well.  When the workflow is a review, it will show a full list of entities that we do not want. Is there a way through the XFBR string and parameter in the member dialog?Appreciate all suggestions.

Hi everyone, I have a business rules that is triggered through a dashboard. This Business rule is looking at a True/False parameter. How do I add the parameter to the dashboard and with a dropdown list showing the valid values (true/false) that can be used to save the value to the parameter? Thanks in advance,

Hi everyone,  I have a Budget Workflow profile with two import steps. Both steps are set up on different data source and different transformation rules. When Importing and Validating data, it works fine. However, when I get to the Load step, if I load one step, it works. But as soon as I try to load the other step, I get the error message: Error processing data. The Entity dimension member '' is invalid. I have checked the data and transformation rule and everything is fine. The issue is not with one particular step because I tried loading the second step first and vice-versa and the error message also shows. Any idea what it could be? Thank you!

Is there an easy way to bulk delete members in OneStream?

I need a BR to help me schedule a Task Manager Refresh through out the day. Anyone have something that has worked for them? Cant find an BRApi that addresses this.