Application Build

Hi Onestreamers,Could you guide me to a document or an article where I can learn more about OIS ?Thanks,Adam

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

Using v.7.4.1.Initially, I set up 1 WebServer and 1 AppServerI configured the single AppServer to handle all processing and added that AppServer to the WebServer Config.The AppServer was receiving the heartbeat request as expected.Then I set up a second AppServer.  I changed 1 AppServer to be General Access and Stage Load.  I set up the other AppServer to be Consolidation and Data Management.I checked the logs on both AppServers and only the AppServer configured as General Access and Stage Load received the heartbeat request.I decided to swap the AppServer functions and the heartbeat followed the General Access AppServer.I assumed the heartbeat would be found on ALL AppServers.  Is it by design that ONLY the General Access AppServer gets the heartbeat?

hello - I have the Workflow start time and Workflow end time set on the Scenario. I am trying to change WF POV from Dashboard component Combo box by passing Scenario as parameter. scenario is changing but the year is not, i need workflow start year dynamically updated along with scenario. Any inputs on how to get the Workflow start year changed along with Scenario is appreciated.   below are my settings under Actions section Selection changed POV Action: Change Workflow Selection changed POV Arguments: WFScenario=|!MyWFScenario!|

Hi Community, Does anyone have experience running confirmation rules when the workflow tracking frequency on the scenario is set to yearly?  The rule looks like its only running for the POV time which the WFYear but I want the rule to run for each period. I'm hoping someone else has come across this as well. Cheers!

Hi, I would like to know how to extract a list of active user from an entity in Onestream.

Recent installation of 7.3.1.1 WebServer and 3 AppServers.When I log on to the WebServer and attempt to hit "http://localhost:50001/OneStreamWeb/OneStreamXF.aspx, I get an error that says 'Unable to access application server using address "http://[AppServer]:50002/OneStreamApp." 'If I open a browser on my webserver and navigate to http://[AppServer]:50002/OneStreamApp/svc/Data.svc, I get the expected result ("You have created a service").I was also able to create an application database from my app server, so I know the connection to the db is correct.How do I figure out what is missing?Thank you in advance for any help. Ray 

Hi All, Can anyone  please suggest how to add Orders Commentary in Dashboard?     Thanks in Advance.

Could you confirm if it is possible to apply Security when using in an application the EXTENDED DIMENSIONALITY: It means, if we  want that Corporate cannot create new users for a specific LOB, or create new companies or accounts or manage access rights for this LOB. It is possible to restrict to Corporate all these options? Many 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

Hi Team, The user unable to login into OneStream application. We have verified that all access has been setup. But, after clicking of "External Provider sign in " we are facing the below "500 internal server error"     Thank you Regards, Praveen

Hello, If I wanted to build out a driver based forecast in OneStream, are their any trainings or webinars that can explain that process? 

Hi All,  I am getting this error  "The SMTP server requires a secure connection or the client was not authenticated. The server response was: Authentication required" while trying to Use BRApi.Utilities.SendMail using the ConnectionName as "OneStreamEmail"  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?

We would like to combine two of our cubes into one.  Some of the UD dimensions will change in the new combined cube.  Is it best to start with a new application?  Any suggestions?

When using a Parameter to specify a member in a CubeView, how do I specify which Workspace the Parameter is in?  

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

How do others manage User Names in their applications? We were advised to use FirstName LastName as the user name, the Description field is not used (screen shot below). We have single sign on enabled which uses AzureSSO and the employees 5 digit number assigned by IT.   We have several name changes that we have held off on making in our application.  Our application includes a custom compensation model that also leverages the User Name and a separate security model within that module.  We can replicate the name change in the comp model and test;  however we are concerned about other implications that we have not considered. Our implementation partner highly cautioned us from renaming metadata.    I fully appreciate the complexities with Entity or Account metadata name changes;  however in this User Name metadata, the implications seem small (historical logs will have the old name pre change and new name post change, possibly an impact to their f

  If you’re using a dimension for only dynamic calculation members, it needs to be enabled on the cube where you want to use that dimension. Question Credit: Chul Smith 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

My client needs me to capture foreign characters apart from regular English as part of Account Metadata. Some of their ERP(Account/Entity) data is in chinese characters and the question was will this be brought in to onestream in their local language or do they first need to translate it to english?