Application Build

Hello All, I'd like your input on whether it is possible, or not, to conditionally display or hide a dashboard's component ? I have a case that, depending on the scenario selected in the workflow, I want in my dashboard to display, or not, a button (that will then allow user to seed forecast, but I want them to be able to do that only when they are doing their forecast, as dashboard is shared across scenarios) I tried to use a XFBR that would return me a different value (True or False) depending on the scenario selected and add this XFBR as value of the setting "Is Visible" of the button component, but that didn't work (thrown an error "Index was outside the bounds of the array"). So I don't know if it's because it's not possible or I did an error but open to any suggestions to make this requirement work Thank you Matthieu

Hi all, I am trying to create a journal where the UD dimension elements are selectable on rows. The default setting shows only accounts in the rows while the UD elements are in the journal POV.    How can I move some of the UDs on the rows to achieve an HFM like journal where the user can reclass from 1 UD element to another UD element? Thanks for the help Marcello  

Hello, I cannot find where is the place where to set the folder directory of server files (using the data import profile type).     Thank you for your feedback.   Marcello  

Hello All, I want to display the default currency value for specific entities in a cube view. Account being displayed is of type Balance so ShowCurrency setting fails to display currency here. Thinking of writing a XFBR rule to pull currency and display custom names in the rows along with Entity names. Is there a better alternative to achieve this? Any leads would be appreciated.

Hi, is there an easy way to prevent users to work on wrong periods? It seems that all periods in Onestream are open for data load.   This request is mostly related to statutory consolidation.   My concern is that some end user can start working of Jul 2042 (instead of July 2022) after realizing after a week that he is working on the wrong period. I know that in Hyperion the admin had to "initialize" the data unit setting the "Review level" as "First pass". If status is not "First pass" nobody can work. Instead in Cognos Controller the same feature is achieved with the "Submission" creation, where the consolidator selects Scenario and Period to open and which forms are assigned to the specified submission. If Cognos submission is not set obody can work.   I am wondering if there a standard feature in Onestream to lock all periods and then enable them month by month?   Thanks in advance for the help, Marcello 

Hello,Does anybody know what's the logic for TimeKey creation?As I see it's 10-digits code, but I can't see any logic behind it.Example:"TimeKey": 2018003000,"TimeName": "2018M1". Thank you.

  "Cube" is another name for the Financial Model 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, Do you know if there is a way to display in a Dashboard where a Member name is used in the application (in which Cube Views...) ? Thanks, Regards, Harry 

I have a set of Controller level users for Audit reasons don't have access to load or modify data.  I am wanting them to be able to enter Variance Comments.  The answer maybe obvious, but I wanted to be sure.  Do I have to grant them access to load data to these data points to be able to also enter their comments?

  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

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

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

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

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.

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  

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!    

Even a simple globals.getObject("_ex") throws a object reference not found error. Is the use of the globals object prohibited inside a spreadsheet rule? The code: Error log when this spreadsheet rule is used: But if I comment out line number 24, the error log becomes:     

Hi I am trying to extract a dashboards  from an application and load into another application, would any one be able to share the XML template that is used for Project Extract & Load? or would appreciate any other helpful suggestions and guidance.    thanks - Kumar 

Statement: You can move data or metadata between applications 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!

Hi everyone, Is it possible to set a search/filter option in the combo box where user can type in the value and it will be picked up from the underlying list?  Alternatively, another component that can do it? I have tried using the tree view with search and filter option but it does not display anything if I use member list as bound parameter. Any other parameter type should be used specifically for tree view to work?

I have five cube views attached within a dashboard that utilizes the tabular layout. The content dashboard where the cube views sit is redrawn when a combo box is changed. However, the dashboard always redirects to the first tab. Only the content dashboard is set to redraw when the combo box is modified, and embedded dashboards are utilized to build up to the main dashboard. The goal is to change the combo box without redirecting the dashboard to the first tabbed report. Has anyone else seen this behavior and has a solution to redraw the dashboard with the new combo box selection while maintaining the current tabbed report displayed?

Hi, let's say I have a dimension with Member001 to Member020 being siblings. In a cube view I want to have rows with all members from Member001 to Member012. Using cube view designer, what's the syntax to specify the range, without having lo list all the 12 members? Thank you

Happy inflation and food shortages <Not!!>Quick question. I have over 15 years experience in Essbase and find it confusing that we have multiple 1Stream cubes in one 1Stream application - but they all share the same outline!! I think I understand 1S extensibility.Is there an article that explains the differences of Essbase vs 1Stream? I would like to suggest to 1Stream developers to show cube name somewhere when I open a workflow. I don't see a way to tell if that workflow is for which cube!! very confusing.