Application Build

Hi All,   I am using  Import , Forms and AdjInput   for Different columns in One Cube View but I want to Hide those names in the Cube View which are highlighted in Red color in the below picture, Can anyone suggest how to  Hide/ Rename those names?   Please find the attached screenshot for your reference         Thanks in Advance.        

 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. 

Hello, For Planning we use a scenario of type Model, on this scenario I do not find why consolidation on Revenue accounts is not working. The translation is working, but it does not aggregate or consolidate to group level. For accounts of type Flow (for volumes) it does work. Setting on the account is: Is Consolidated (Regardless of Formula Type), no formula is active on the account. Apart from that it happens also on asset accounts. I checked the Business Rule for consolidation, but couldn't find anything related to scenario or account. Any hints where I could look would be much appreciated. Kind regards Ben  

New install of 7.3.1.WebServer on one machine.  AppServer on another.When I attempt to access any of the WebServer pages, I am prompted with a very odd login page.The only fields on this page are a missing header_logo,  username/password fields and a login button.I tried to log in with the default Administrator password and it says "The password was reset and needs to be changed."  I have not logged in to OneStream yet, so the default password should not have changed.Since I cannot access OneStream, I am not able to reset the password.I have no idea where to start looking to resolve this one.Any help would be appreciated.Raymond

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?

My client is using the 7.2.3.14520 server and getting an error message that says:Unable to log on User ''.  Your client XF version '7.2.14520' is incompatible with the XF server version '7.2.2.14307'.We get that error message when using the URL or the (7.2.3..14520) Windows client.  Same error. We are able to click through and login.Any ideas?

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

Hi Team, I am writing this post in regard to moving the cubeview up or down without renaming the CubeViews. For example: In workflow profile we have option to move the task/activities up and down. Do we have any such kind of options in the Cube Views to rearrange the same.

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

Hi everyone. I am looking for some assistance with using data buffers for a revenue planning form. Essentially, budgeted revenue growth percentages will be input individually for each brand by month. The total PY Actual revenue for each brand by month will be loaded into OneStream. The formula to forecast budget is:CY Budget = PYAct * (1 + Growth % / 100) While I can calculate each CY Budget cell individually for each brand by month, this would be a tedious and very long process since there are 26 brands and 12 months, which would require 312 individual calculations. I would like to use a data buffer instead to calculate CY Budget by looping through each brand (and across all months from Jan 2022 to Dec 2022). However, I am unsure of how to do this and would appreciate guidance. For ease of reference, I have also attached a screenshot of my cube view.

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?