How to copy a scenario from one application to another?
Hello, I recently recovered a scenario from a restored application copy from a point in time. I now would like to extract that scenario from the application copy and put that in our working application. Does anyone have any idea on how this would be done? Thank you, Jeremy MorganSolved1.9KViews0likes8CommentsXFGETCELL(), XFSETCELL() PERFORMANCE
Hi all, Every forecast cycle we get the same performance complaints from the same region group of users. They are always uploading massive amounts of data and refreshing massive amounts of data in the same workbooks using the XF functionality in Excel. To be clear, we have tried multiple times to convince them that they should be importing that data via CSV and advising that they will not get the same performance using the XF functions. We have also tried having OneStream re-index the databases before these cycles and we have regular daily app pool recycles. The OneStream data logs really don't show any significant refresh issues (less than 5 minutes usually) but the one user doing all this work is insisting that it's taking hours and hours to finish refreshing and they often have to close and reopen Excel and re-launch OneStream. We have raised multiple tickets and OneStream does not see any back end issues. We have looked at their Excel preferences and tried different options there but no improvement. I am 100% out of ideas so if anyone out there has any thoughts, would love to hear what you've done to resolve these issues. I'm going to post this as well somewhere in the community where Excel discussions happen. Thanks for any advice.39Views0likes1CommentCubeview Drill Down issue: Load Results for Importe Cells is empty
Hello there, We are having an issue when using the Drill Down option from a Cubeview, and it's that after getting to a base data cell within the Drill Down window, and then trying to navigate to stage using the "Load Results for Imported Cell", the results window is displayed empty: The workflow that is being used it's a simple Import, Validate and Load, that retrieves the imported data from a Connector and there is no further data processing once it's in the Cube. From the Workflow Page we can use Drill Down and Drill Back just fine. Any ideas of why is this happening? Thank you. OriolSolved48Views0likes4CommentsChange Load method through connector code
Hello everyone! Quick question. Does anybody know how to change the Load Method for a ProcessDataTable through the connector code? We have a dashboard where the user wants to choose the Load Method with a radio button. We are able to pass that parameter to the code and change the api.LoadMethod property to Append but the load still executes as Replace. The above works if we change the load method directly in the WF, but not from the code1.1KViews0likes2CommentsTime/data setting in data source/Transformation rule for Multiperiod upload (delimited files)
Hi Everyone, I'm trying to build Data source and transformation rule for multi period manual data load through single file. The import step didn't succussed. Can anyone suggest time settings in data source & transformation rule. I selected data type as "Stored Data key text" in Data source . My source file format is Col1 has GL accounts, Col2-13 Jan to Dec data.Solved66Views0likes5CommentsMatrix Data Load Basics
I have a matrix data load question. I get the concept of how the matrix data load works. I haven't done too many of them, so I want to make sure I'm not missing the basics. The file I have has the year on one of the first lines in column 9. The next row contains the headers with periods in 12 separate columns. Is there an easy way to get the year from the first line (without a lot of code)? Or should I get year based on the POV? Then I am guessing a complex expression in the time columns to build the OS time key? I know I can do all of this in code, but I don't want to skip over any out of the box functionality or best practices. Any good guides on some of the best approaches with the Matrix load? Thanks, ScottSolved1.2KViews0likes5CommentsWorkflow Leading Practices - Input Data to Parent Entities | Forms?
Please share your Workflow leading practices to input data to Parent Entities. Thank you. In addition, please help us with three initial questions below: 0. Workflow: Parent Input – Forms/O#AdjInput - Is this Workflow the leading option to input data to Parent Entities? -- We prefer not to use Forms/O#Forms by creating alternative Base E#/A# Members as they are massive. 0. If Forms/O#AdjInput is the leading option: 1. Account Dim: Member Properties | Vary By Scenario Type And Time | Adjustment Type -- How to massively set A#'s 'Adjustment Type' to 'Data Entry' from the default 'Journals'? -- Can we still use Workflow 'Journals' as they are tied to O#AdjInput as the default? Loading Form Data 2. Form Input Template: Format – CSV v Excel -- CSV v Excel: which template format is better and why? -- CSV Template: please share a copy here per OS Support. -- I couldn't find a Form CSV template in Community, Solution Exchange or Design Guide. Thank you, SMEs.Solved149Views0likes3CommentsHow to know Static IP of OS Cloud instance?
We're planning to load data from Oracle EBS into OneStream thru REST API. However, during our tests, we are unable to reach Oracle EBS using both postman (error: getaddrinfo ENOTFOUND) and business rule (error: remote server cannot be resolved). Infra team from the Oracle side asked us for the Static IP that OneStream uses but I am not familiar on how to get this, any thoughts? They'll use this so that they can configure and allow requests from this IP. Appreciate your help.Solved5.4KViews0likes10CommentsHow do you know if you are using the Roslyn compiler?
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?SolvedWorkflow Profile Hierarchies: Security Model | Application Security Roles v Workflow Security
Please share your practical advice to secure Workflow Profile Hierarchies per the two requirements below. Thank you. A. Workflow Profile Hierarchies: Admin v Builder/Business 0. 'Cube Root Workflow Profiles' | Admin and Business | Top Level Cube_suffix 1. '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/Business 1. 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 Workflow Profiles' -- Business 'Parent Workflow Profile Types': Review, Base Input, Parent Input -- Business 'Child Workflow Profile Types': Import, Forms, Journals C. Security Model: Application Security Roles + Workflow Security | Admin v Builder/Business 0. Security Groups: 'Admin Roles and Builder Roles' and Child Groups = 'Admin Roles' + 'Builder Roles' 1. Application Security Roles | Manage Workflow Profiles = 'Admin Roles and Builder Roles' 2. Workflow Security = 'Admin Roles' = Admin/Business 'Default Workflow Profile Types' 3.1. Workflow Security = 'Admin Roles' = Admin 'Cube Root Workflow Profiles' 3.2. Workflow Security = 'Admin Roles' = Admin 'Parent Workflow Profile Types' 4.1. Workflow Security = 'Builder Roles' = Business 'Cube Root Workflow Profiles' 4.2 Workflow Security = 'Builder Roles' = Business 'Parent Workflow Profile Types' D. Security Model Results: Admin v Builder/Business - 1 + 2 + 3 + 4 = Workflow Requirement 1 = Fail - 1 + 2 + 3 + 4 = Workflow Requirement 2 = Succeed Thank you, SMEs.286Views0likes1Comment