Application Build

Hi OneStreamers,   I have a set of scenarios for forecast, rach one must have its own rate tables. Is it possible for me to use only one rate type and combine that with each scenario to input the rates ?  Thank you, Adam

   Hi,I would like to add up all the children of the accounts and put them in the getdatacell, to create a row of Total, both for flow1, flow2 and flow3 

We have built a custom model in a dev environment and now want to migrate this to a user test environment.  The build includes a number of database tables that we want to copy between the environments as they contain a large amount of data that needs to be used by the user test and will also be required to be migrated to the production environment.  Is there a way to copy database tables between environments, there doesn't seem to be anything obvious in the Load/Extract object list?

As we cannot filter the Tree member expansion, is it possible to create a custom Tree?If not as a custom expansion, perhaps a code that returns a tree i.e. XFTreeItem?Dimension:AccountParent1    + Member1    + Member2        +Member2.1            +Member2.1.1            +Member2.1.2        +Member2.2            +Member2.2.1 In the above account dimension, I dont want Member 2.2. I just want the ultimate Parent1, the next level (Member1, Member2), and all base members. The result would be something like: Parent1    + Member1    + Member2            +Member2.1.1            +Member2.1.2            +Member2.2.1 Thx 

Hi there, For a client i want to do a detailed analysis of the data (numbers) in the database. We want to investigate the percentage of numbers < 0.01.However, when i use the Data records i see the following:But in this view i cannot filter on values in the Value1, Value2 etc. columns. In the binary table itself i see as contents of the CellAmounts the following:When i convert this to a string i see a binary code that i cannot read.Does anybody know how to write the select statement in SQL to see the Value fields in the CellAmounts column so i can filter on them? Thanks in advance.

I have tried with the suppressions to make the cells that have 0 disappear but it has not been effective. In the first cell I would show how the data is arranged, and in the second image how I would like it to be   

Hi All, In an event of OneStream primary database crashes during the month or year end of the Statutory Reporting when users heavily rely on the system, Could you please suggest the steps we will consider to reinstate the system. Thanks Amit

Hello - I have a cube view that currently has two columns. The first is just base members of an account hierarchy, and the second is a dynamic calc UD8 that retrieves the text 5 value for each account stored by scenario type. The UD8 is working and pulling the correct text 5 values, however some but not all of the stored item text is delimited by semicolons. How can I split this text by semicolon into separate columns in the cube view?

HelloI have created a "level 2" transformation rules on ICP dim in order to force certain accounts to be filled in specific fixed IC elements.Do I have:     -  "level 1" with One-To-One Mappings.     -  "level 2" with a composite filtering on the account A#[140305] "Level 2 Composite" is completely ignoredWhere am I making the mistake?Thanks in advance for the helpMarcello 

Hi All,We are using a spreadsheet component to capture some drivers from end users in our application, how do we customize the ribbon of the spreadsheet component to show only OneStream option in the ribbon?If I do right click, "Customize ribbon", it lets me display only OneStream in the ribbon , but the customization is lost on refreshing the page. Any guidance on how to retain this customization would be helpful.   

Hi,I have created some new balance sheet accounts relating to Right Of Use Assets, I have copied the structural dimensions from my existing fixed assets, so that every member property field matches. I use a generic cubeview for recording opening balance adjustments, when I key into all my other balance sheet accounts, then the derived value flows through the remainder of the year. This happens regardless of which is the first month I key into. However, for my new ROU accounts, it does not do it. The values just show as 0 and I have to key in the actual value manually each month thereafter. Here is some sample data to show what is/is not happening. Also, it does not matter which month is the first month.So what have I missed in creating these ROU account codes in the member properties ? They use the same flow constraint as my other fixed assets, so it's not that.Where else do I need to look ?CheersMark

Hi AllI am updating the Admin Consolidations Dashboard (ADM) so that only some users can execute a Force Consolidate. I can hide the radio button group if the user does not have access but I am struggling to update the radio button group (Consolidate/Force Consolidate) so that the correct option is selected. The list of values for the radio button is controlled by a parameter (pm_ConsolType_ADM). In the LoadDashboard event I have updated this parameter using SetLiteralParameterValue (using v6.8). I am assuming that this is how the radio button selection is controlled as I can't find anywhere else where it can be set. If I click on the 'Reset parameter selections' it works.I have tried unsuccessfully to Redraw the dashboard like this:Dim selectionChangedTaskResult As XFSelectionChangedTaskResult = New XFSelectionChangedTaskResult()selectionChangedTaskResult.ModifiedSelectionChangedUIActionInfo.DashboardsToRedraw = "2_1_AutomationTasks_ADM"Any help you can give me is much appreciate

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