Application Build

Hello All,We have created a weekly forecast dashboard for our users (weeks are mapped as scenario, e.g. Week1, Week2 etc.) and intend to restrict them to current week scenarios only to avoid posting to a wrong one.Currently we use parameter, where users select the current week from a drop down and input data, Is it possible to provide them access only to the relevant scenario (week) instead of giving them a drop down, without admins having to make changes every week?

Hi there,I'm testing out the capabilities of OneStream for a PoC. Is there any way for a front-end user to add new members to, e.g., an account dimension through a component of a dashboard? Ideally using a variable specified within the dashboard.In the example screenshot, I want to enter a name in the text box, press the green button, and have the specified name added to the dimension of the cube view below.Thanks!! 🙂

Dear Community, Can we export a hierarchy/hierarchies into a relational table? For an instance if I want to export the complete hierarchy of any Dimension into a table view format whether it will be possible?  I could see we have a Load/Extract to extract the metadata for a hierarchy, is there any other way to showcase or export into it in the form of tables? 

Hi All,Ive got a problem with transformation/load cube workflow steps in our build, It has been in our applications for over six months (an older dev application has the same problem). This error doesn't seem to cause a problem in our data although may affect a dimension we put into our application for future use, I want to isolate it regardless. The error is an "Object reference not set to an instance of an object error" and doesn't actually stop the workflow step from completing, making it difficult to track exactly what is going wrong. It also doesn't flag when compiling all business rules being only apparent whilst running the rule. This error occurs on all the load/retransform steps I have tested although that doesn't help much as a lot of our transformation rules overlap.Id really like to know if there is a way of viewing which business rule is failing on running these processes but cannot fathom how, is there a way to do this? Thanks,Tom 

I have been trying to give a couple of our users access to the Database Page in the System Pane. I created a new security group named DatabasePageAccess (and SystemPaneAccess) and add another security group and 2 specific users to this new group. I then changed the security group on the System Security Roles for the DatabasePage System User Interface Role to "DatabasePageAccess" and SystemPane to SystemPaneAccess. Asked the 2 users to test it out. They were able to see the System Pane now but cannot see the Database page still. I have been going in circles and cannot reason why they cannot see the database page when I seem to have done it all correctly. Has anyone else ever seen this?System Security Roles Screenshot from User (does not show the Database page as an option)  

I set up a Hybrid Scenario with a Data Binding Type of "Copy Input Data from Source Scenario." I tried following the example in the Design and Reference Guide (below) for the Origin dimension, where the properties are as follows:      - Member Filters to Exclude: O#Top.DescendantsInclusive      - Pre-aggregated Members: O#Top=O#Import     When force consolidating, I get data in both O#Import and O#Elimination, but O#Top for my source scenario and hybrid scenario agree. Is there any way to only copy data into O#Import? As a side note, if I change Pre-aggregated Members to O#Top=O#Elimination, I only get data in O#Elimination. Thanks! Molly  

Dear Team,I'm trying to check if value of a specific column is <> 0, if isn't I would like to inform user by some kind of Message Box.I was trying to use SaveDataEventHandler, but the issue is this value is not inputted by user - it's calculated by UD8.Do you think there's any another possibility? Thanks a lot! 

I am going through the process of making an application multi-language. There is one area that I cannot work out and it is an important element: Certification Questions. I am using XFStrings to hold the translated text and this is then used on Cube Views, Dashboards, Confirmation Rules etc. Certification Questions do not execute the XFString function and there is no event I can find for building the Certification Questions form. Does anyone have any ideas?

Requesting OneStream to add a DateTime component for easy use by developers, at present textbox has been used everywhere to capture date from users in custom applications.

Is there a way to report first Value for Each Time Period similar to TB First setting in Essbase? M1 .. M12 M1 Value to be shown for FY

Originally posted by Erin Nielsen Hello, Is there a way to easily copy over our Budget Scenario and all of the data in it, into a Budget V2 Scenario, so that i can add data to the Budget v2 Scenario? Essentially allowing the app to have two versions of the budget?   Thanks, Erin

 Seeking to improve efficiency for user management and security/audit review processes. The OneStream application is accurately showing the user assignments but it's only available in the OneStream application itself and the GUI is not very flexible in viewing the out of the box forms. We have already installed the marketplace solution "Security Audit Reports" which improved our capabilities through a user dashboard and different reports with user details, but it is also only in the OneStream application GUI. As a workaround we have been using the Load/Extract option to pull an XML file and manipulate in Excel. 

How to install the Golfstream demo application on cloud? I have downloaded the GolfStream65 references material from MarketPlace. After unzip it, it was some .mdf and .ndf files. Since I'm on the cloud version, I am not able to access to the server. What is the possible way to install the Golfstream demo on cloud version?

How does fragmentation on the OneStream Datarecord tables impact performance? I have an application with a lot of tables having fragmentation > 90%, but how big of an impact does this have on performance? Or do the Datarecord tables/logic/databuffer work in a different way? Any knowledge/experience on this?   Cheers Frank

Hello Everyone, I need to rename a few entities as user provided incorrect names. They loaded data already and I am wondering what are exact implications of renaming them now. I tested renaming and I can see that drill down to the source data is not possible I found another topic on this forum and I cannot find any other implication other than with drill down >>> Entity Name Changes - OneStream Community (onestreamsoftware.com) I did not find anything in documentation Can anyone confirm that this is the only implication of renaming dimension member? That drill down to the source is no longer working? Of course I know that if those entity names were used in cube views, business rules, formulas, etc., then I need to adjust them (but thankfully this is not the case here).   Kind regardsJarek

Does anyone know if it is possible to rename a cube? I am happy to execute SQL queries if that's what it takes. Failing that are there any shortcuts for copying a cube (with all the workflows)? We have copied an application but one of the cubes (top level for workflow) must be renamed as it is out of place in the new application. Any comments or ideas will be welcome. Thanks

Hello,Well, the title is quite explicit 🙂I am trying to avoid the standard workflow panel as often as possible. Right now, I would like for the user to select the workflow profile just by clicking a dashboard button component and access this menu : Is it possible ? Regards,

Hi,   ParamA will be a multiselect combo box and the same should be passed to business rule as well. May I know how it can be done? I'm passing the parameter in calculate button, then DM step and then to BR. Calc button : {seq_name}{ParamCC = |!ParamA!|} DM step: {|!ParamCC!|} BR: Get value of ParamCC Need suggestion on how should it be passed if parameter is multiselect. thanks

I am trying to create a Cube View that has 2 GetDataCell formulas.  The formulas work separately but if I add them both to the same Cube View, one will not work.  I am using XFBR in Columns (Time) and GetDataCell in Rows (Accounts).  Is there a way both formulas will work in the same Cube View?      

I’ve noticed in working with the newer versions (that have Workspaces), that the SetLiteralParameterValue seems to only work on literal parameters in the default workspace.  However, I’m unsure if this is a bug or if this is by design.   My understanding from I saw at the Wave Conference was that Workspaces were intended to be used for better grouping of solutions, versioning, and development.  Currently, they support the creation of identically named parameters in multiple workspaces.  If you’re attempting to update a literal param in a specific workspace… is that even possible?  If not, are all active solutions intended to be in the Default workspace only?  Could someone please advise on the intended usage of Workspaces?

I am trying to use a dashboard button to Select All and Unselect All values in a Multiselect Combo-box which I am passing to a Spreadsheet (TableView) business rule. I have tried to run a Data Extender rule from a button that clears the data using the code below:  Dim selectionChangedTaskResult As New XFSelectionChangedTaskResult()selectionChangedTaskResult.ModifiedCustomSubstVars.Add("lv_BusinessChannel", string.Empty)selectionChangedTaskResult.ChangeCustomSubstVarsInDashboard = True ' Set the Return valueselectionChangedTaskResult.IsOK = TrueReturn selectionChangedTaskResult

We are in cloud OneStream environment and our retention policy for Non Production is 7 days and Production 365 days ( I think ). Restore from backup does whole environment restore and not application by application. We have multiple application including PLP and I was wondering if anybody has figure out way to restore application.Any help or procedure or steps are apricated.Saurin Patel*migrated from champions

Has anyone worked yet with workspaces (loading/ extracting) using a .xfproj file?  I am trying to moved a dashboard maintenance unit (DMU) out of the default workspace into a new one.  However, when I export my .xfproj file (pre-7.3), remove the DMU from default, and load the .xfproj file back in I do not see it loading to the new workspace I created.  Is there something in the .xfproj file that needs added to accumadate workpsaces in 7.3?

hello all, please suggest if there is a way that we can stop users from running Force Consolidate for a given period? 

Hi Community, We have a few scheduled calcs and consolidations running on an hourly basis, and sometimes these start queuing up and cause other DM jobs to fail/get cancelled by the system. Is there any good way to monitor or alert the admins via email if there are more than a few DM jobs getting queued up? We already have a scheduled task which queries the TaskActivity table for any failed jobs periodically and then sends out an email to the admins to address them. But this idea doesn't work for the Queued Jobs as this DM also gets "Queued" along with the others.   Thanks, Sudarshan