Application Build

Hello OneStream Infra Experts, I would like to know if we are customer to OneStream and bought the cloud Onestream application, Can't we download and setup an Onpremise Onestream server like Hyperion Onprem version. Please let me know the server details and configuration to Install the OneStream. Thanks

When I use the Pre-Aggregated Member settings, it is copying the data twice.  I've tried multiple settings and multiple scenarios.For example, I have tried just O#Top=O#Forms.  After I run the consolidation, there is data in both O#Import and O#Forms, doubled. It also happens with multiple Dimensions.  I've tried O#Top=O#Forms,U5#Top=U5#PlanningLoad and the data is doubled in both Dimensions 

Hello OneStream Admin Certified experts, I would like to perform the certification on OCA and need your experience on how to prepare and what are the documents to refer and minimum duration to prepare on self training. Thanks Sreenu

Hi,Copy pasting data from excel into CV forms generally work, but the exception seems to be for date values (CV Cell Type - Date). Does anyone have experience with this and know if it's possible?  

Hi All,I wish to change the property 'Show Manipulation button' of my SQL table editor to hide manipulation buttons if the workflow selected is a parent but show if the workflow selected is a base. Is this possible?Regards,Mark

Entirely tied to the moment we upgraded the clients to version 7.1.3 we started getting the Windows "pick an account" window when they select External Authentication. We are cloud hosted.  I've opened a ticket with Onestream and with our internal resources, and no solution.  Anyone else experience the same or is it just us?

Hello all,I am building a planning application on which the end users interact via drop-downs for Entity and UD1 members, and click a "Save Inputs" button that saves input data and runs a custom calculation on the selected entity and UD1.This is done through a data management step that runs a business rule, and on which the selection of the UD1 and Entity impact the business rule to avoid recalculating all the application each time. There are 6 business rules, that respond to different functional models, activated by different "Save" buttons across the application.I want to create a button or data management sequence that will run all the business rules (the 6 models) for all UD1 members of the 4 entities, as an admin task. I have created a Data Management sequence that runs the 6 steps consecutively, with its corresponding button, but have not been successful to modify the arguments or the Data Management parameters to perform the calculation for all members, as I cannot input "E#All"

HiDoes anyone know if it is possible to create a 'Read only' column in a SQL table editor?I have set the column format 'AllowUpdates = False' which almost gives the correct functionality. However, the field is still editable when you insert a new row.I currently get around this by completely ignoring the value in the field during the SQL Table Editor Save Data Event, but I wondered if it is was possible to ensure that it never appear editable to the user?Regards,Mark

Originally posted by Matt Grundey 11/6/2017 Hi, has anyone any examples of using Cubeview extender rules to change the logo displayed in a report based on the entity selected. I'm aware that this wouldn't work where entities are shown in rows or columns. I can't see any examples of passing in parameters into these rules that could identify the entity, nor can I see from the reference doc how I can get the entity that the report is using. 

Hello, I've deleted several on prem databases from both SSMS and the Database Configuration Utility, however, when I access System > Tools > Environment the deleted databases are still listed under OneStream Database Server with a message "((Database Not Found #))".  There doesn't appear to be a way to remove these via the front end. Is there any other way to remove these?

All Scenarios belonging to the same Scenario Type must have the same Formula assigned Question Credit: Janice Kirkbride Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi AllI am trying to build BR (Finance or Extender (General Server), activated by Dashboard button) to calculate Journal (based on two different Cubes) and post to Dt or Ct ('if' statement to define where exactly)?I thought it would be possible with 'api.Data.Calculate' by just having simple equation TargetCube = 1stCube - 2ndCube; but cannot get to the place where I could define whether it should be posted as DebitAmount or  CreditAmount.Thanks!

Hello,Our Business Operations team provided us the plan in an offline copy of a cubeview in Excel.When the FP&A user opens the offline copy it shows #LOGON instead of the numbers.How can the FP&A user see the actual values instead of #LOGON?is there any setting that will need to be set to view the values before submitting into the application?Thanks 

Hi, I am getting many metadata errors when loading a version 6.8 extract in a version 7.4 application. Are there differences in the xml structure between versions? Thanks

Hello, is there someone who knows how to get more information on this error?The next 2 messages refer to a scenario member, for which I run the calculation, but I don't see any "=" that has a wrong statement behind it, could of course be a small typo, but it's a large scenario formula. thanks in advanceBen

Hi all, I'm trying to figure out if there is a dashboard, marketplace solution, or custom report where I can view security groups/users and references where they are assigned to objects. Preferably with the ability to sort.For example:Security Group Name:"Security Group" Object:Application -> Workflow -> Workflow Profiles -> "Cube" -> "WorkflowProfile" -> Profile Properties -> Security -> Access GroupApplication -> Tools -> Business Rules -> Connector -> "Business Rule" -> Properties -> Security -> Maintenance Group   Thank you!

Hi Team,Under UD4 I have an XFBR string, which returns Jurisdiction - the case is I can't include there hierarchy.Base, as it needs a single entity to work. Is there any parameter like |CurrentEntity| which I can include in XFBR or do you have any idea how to solve it? 

Do we have a function that can be used in a member formula that will calculate the average of the last 3 periods.Example: If my current forecast month is June, I want to calculate the average for the months of May, April, March for which I have actuals for a given account. Thank you. 

Posting this because I searched for the answer before putting in a ticket with OneStream support (who were excellent, by the way).  One of our applications wasn't working in a lower environment.  The connection to the application SQL DB wasn't working.  Tried removing and adding it back using the OneStream Database Configuration tool.What the fix was:The “Invalid Connection” issue was due to the DB security settings for the service account user (that was running the OneStream server application).  Not quite sure what the issue was  -- it might have been the default schema for the user.  In any case, looking at the permissions for the user in the other application SQL databases where it was working correctly gave us the guide towards fixing the issue.

Is there a way to set the property of a dashboard button to disabled?  I have a dashboard that includes a number of button objects that execute various tasks, such as running a calculation, locking the workflow and so forth.  What I'd like to be able to do is to disable a button as part of a business rule so that the user has to follow a sequence of activities and can't, for example, keep pressing the calculate button on the dashboard. I don't see any property in the button object that supports enabled/disabled.

Hello All,   I would like to know if there is any Activity guide document for OneStream Application design represents the process to build a new cube..   Thanks in Advance

Dear Colleagues,Did you build the XFSetCell feature to import text fields from a spreadsheet into an Annotation view? Any assistance on this matter would be greatly appreciated.Regards

Is there any option for the users to see the Recent Pages they opened in the application? 'Navigate Recent Pages' allows the users to select and go back to a recent page, but this information gets removed when the session is closed. Please let me know if there is an option which persists between sessions? Thank you. 

Hi All, Can anyone suggest is it possible for Admin to enforce Workflow POV and Cube view POV for users, if so please guide where to do it on OneStream  Thanks in advance.

Hi All,   Currently I have weekly data, if i enter commentary in Week2 it should be in the same week later if I enter commentary in Week3 am getting w2 data in w3, can anyone suggest how to overcome this?     Thanks in advance.