Application Build

  In order to see data, are all 18 dimensions used Question Credit: Nick Hymes   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi , I was wondering if anyone who has implemented OneStream has come up against issues from their IT Security people with OneStream decision not to empoly a Web Applcation Firewall (WAF) as standard. This seems to be a common requirement of most IT Security governance approvals so I'd be interested in seeing if anyone has had this issue and how they resolved/accomodated it.   many thanks   Steve

Hello, Does anyone know how to turn off the Quickpost function for journal entries?  Regards, Ronnie Karpinski

Hi, I noticed that when exporting a workflow/cubeview to excel the default save location of that file is C:\Users\xxxx\AppData\Local\Temp\OneStream. The local IT group policy is to empty that folder upon rebooting the computer. This path is not setup in my own/local excel options. Is there a way to change this folder location to for example 'downloads'? 

Is it possible to change the Fiscal Year Month Type in the time profile after an application has had data loaded to it? For example from Fixed Weeks 4-4-5 to Calendar Month?   

Our team has been working through an Infrastructure project, which requires pulling task activity from the Framework Database.  When pulled directly from the database, we see task activity type in numeric format.  To get the descriptions I ran an comparison by extracting the Task Activity dashboard tool and was able to identify the below descriptions:  (CASEWHEN a.TaskActivityType= -1 THEN 'Unknown'WHEN a.TaskActivityType=10 THEN 'Recycle Application Server'WHEN a.TaskActivityType=100 THEN 'Get Data Cells'WHEN a.TaskActivityType=101 THEN 'Get Data Cells Using Script'WHEN a.TaskActivityType=110 THEN 'Cube View'WHEN a.TaskActivityType=111 THEN 'Cube View Report'WHEN a.TaskActivityType=112 THEN 'Export Cube View To Excel'WHEN a.TaskActivityType=120 THEN 'Quick View'WHEN a.TaskActivityType=200 THEN 'Book'WHEN a.TaskActivityType=1000 THEN 'Data Management'WHEN a.TaskActivityType=1100 THEN 'Data Management Scheduled Task'WHEN a.TaskActivityType=2000 THEN 'Load And Transform'WH

Hi everyone, I have been looking in the marketplace to see if there is any tutorial about 'Best practice' to set up Securities in OneStream. I couldn't find anything. Do you have any approach to suggest? Do you use the Child/Parent group often? It seems like it could become quite messy.. Any comment is very appreciated Thank you in advance

Hi All, Has anyone set up a new scenario to load stub period data and is willing to share your experience. I will need to produce financial reports for the full year 2022 and partial year from Aug-22 to Dec-22.  So, I am thinking of copying Aug-22 to Dec-22 actual data to another scenario “Actual22”.  The data will be in USD to avoid translation issues.  However, I am not sure if I should use the same Scenario Type “Actual” for “Actual22” because of the business rules set up in Flow Dimensions for the opening, movements and closingCalc.  What do I need to change if I use Scenario Type “Actual” or another Scenario Type?  What are the other considerations I have missed? Please shed some light. Thank you in advance!

Originally posted by Eric Osmanski 5/15/2020 Is there something up with V#Footnote and V#AuditComment? We have a form where the user needs to enter in comments. There are no conditional input rules in this application or Data Cell Access restrictions on the Cube. If we use V#Annotation, V#Assumptions, or V#VarianceExplanation, then everything is good and the column is open for input. If we use V#Footnote or V#AuditComment, the column is read only. What am I missing?

Hi,Is there a way to find the primary node or secondary node of a member with alternate hierarchies in OneStream like the default parent of a member in Hyperion HFM?

Hi All, I am trying to get my member formula to calculate an unbalanced balance sheet and I built a Quick View to see the calculation. However, it does not seem to be calculating anything with the member formula.    The following is the member formula under 'Calculation Out of Balance'   If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyForEntity())) Then   api.Data.Calculate("A#Calc_OOB:U1#Manual_Input:F#EndBalLoad:I#None = A#Total_Assets:F#EndBalLoad:I#Top - A#Total_Liability_Equity:U1#Calculations:F#EndBalLoad:I#Top")   End If Any guidance would be greatly appreciated!

I'm starting to plan for upgrading our OneStream dev environment from 6.2 up to 7.0.  Part of the testing will have to involve the Excel add-in.  If I uninstall the 6.2 add-in, and install the 7.0 version,  can I still use it with our Production 6.2 environment?  

Hi Community, For us the biggest lack of the Onestream product is the ability to point to two different applications in the Excel formulas. We are a customer since around 2016 (live 2018) and we have raised this on may occasions and in many forums.  It has been hurting us all along when testing developments on test vs. production - to see either that it did not impact the numbers or it had the impact we desired. We have been coping with comparing reports etc.   Now we are in the middle of the first rebuild after going live - and the amount of datapoints, levels that we need to check is massive - while we still wait for this most obvious long term deficit, in an otherwise very good product, to be fixed, we turn to you guys.   Can any one share their approaches to compare the data between applications in the development process in generally.   Kind regards Per

I want to create a new application in our production environment, but I only want certain people to have access to the application.  How do I add security on the application?   Thanks, Winni

Happy upcoming Father's day everyone!! I just submitted the following enhancement request to OneStream developers. Does it make sense to you. Let me explain the context:Before I select a Workflow I have to select a Cube. Why is that required? Why can’t users organize Workflow under some other criteria of their choice - maybe a folder of Workflows based on Finance Dept's functions?From my experience, a workflow can be designed to update and pull data from multiple cubes; so why is it associated with only one “Cube”? That confuses me.Here is the enhancement request:Under OnePlace - give us a Workflow-Explorer that allows us to organize by creating sub-folders of Workflows.Create a default folder with Consolidation, LRP, Planning, Forecast as sub-folders.May Oracle stock crash -  like Bitcoin and the rest of stock market!!

Is there a way to change the Cube name after data has been loaded to it? thanks,Greg

Hello, has anyone seen an error like this before? I'm loading information from our PreProd to Prod environment and am getting the following error: "Summary: Error processing XML file type 'TransformationRules' XML: Line 379, position 22, element transformationRule. Rule already exists in this Rule Group, [Aggregate amount of institution's - 1- largest loan commitments]." From what I can tell there isn't anything particularly special about this line of code, it's just the line showing the given rule. And if it already exists, shouldn't it be overwritten through the load process? Any help in this matter would be greatly appreciated.

Hi,   Is it possible to define restrictions for input in a cube view between two UDs dimensions ? In order to "guide" the user in their input, I would like to define a restriction between UD4 and UD5, so that only specific UD5 elements (in columns) could be editable based on the UD4 (in rows). I don't see any restrictions on UDs elements in the datamodel, so what would be the best way to achieve this ?   Regards,

Hi all, I have built out my cube view that shows headcount change for 2019 M12, I want to be able to capture the ‘Ending Balance Headcount’ for 2020 M1 as its ‘Begin Balance’.  Will a rule be the way to go in order to achieve this? Unsure on where to go from here.   Thank you.

Hi Team, Is there any option to delete user groups in RCM under the Account Reconciliation Market place solution using a template? We have close to 3000+ obsolete user groups which need to be deleted.

How do you prevent users from accidentally loading data via QV submission to a non-forecast scenario ie; Actuals. The CV is set up to point at the WF scenario so if a user doesn't change their WF POV it will submit the data to the incorrect scenario. 

Is there any way to get a complete listing of active users and disabled users

Hello All, I have one specific query about data Management Tasks as below: If I want to allow a user to be able to edit parameters of only one of of the DM Group and not to allow edit anything else - Question is >> which 'Security roles' need to be looked at? I can see only way to allow editing is to allow Security role 'ManageData' BUT this allows everything and all DM tasks and even user can setup a new DM group - which is really risky and can not be allowed.  Kindly help with your comments if I am missing something here. Our current status is, we can not allow users to edit the DM tasks and we keep on making parameter changes for business users, which is really a big pain. You guidance here would be really very helpful. Thanks Satish  

We like to have a "Prod Yesterday" version in Test that has data from the overnight backup of production.  This helps when working with data issues and testing where one wants to have up to date data.   The major stumbling block to automating this is the need to automate the Rename Application functionality in OneStream Database Configuration manager.  Has anyone found a solution for this?  Or, for the more general solution of automating a daily restore of production to a lower environment for on premises OneStream?  Overall process:  MS SQL job restores the MS SQL DB to the lower environment  We run the One Stream Database Configuration Tool , select the database, right-click and select "Rename Application"  Restart the IIS servers  Import (IE "Load") XML files to apply Test environment config 

Statement: I have People Planning in my application, I can set this up so that only some people can see the data – and not the CFO admin Question Credit: Peter Fugere   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases   Want more Fact or Fiction? OneStream Press Authors are subject matter experts... but do they know about the 80's, sports, movies, or other pop culture trivia? Are you able to tell if their knowledge is fact or fiction? If so, come for the crown, stay for the fun, and emerge the new Fact or Fiction Champion at Splash San Antonio. Prizes will be awarded! You can volunteer to participate or you’re welcome to attend. Secure you spot today by contacting Press@OneStreamSoftware.com. We hope to see you there!