OneStream Platform Forums

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

Hi,I created a cube view group in the in the application and it works fine. I placed it into a cube view profile so I could then pull it into an excel workbook via the onestream add-in. This also worked fine.However, now when I go to refresh the data, as this will be a monthly report, the cubeview is not connected and everything is essentially hardcoded. What changed to cause it to go from a living report to not connecting to the data base? 

Hi EveryOne!!!! Dim resultDataBuffer As DataBuffer = New DataBufferDim destinationInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("")Dim dataBuffSource As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(F#myF,A#XYZ.Base)") For Each sourceCell As DataBufferCell In dataBuffSource.DataBufferCells.Values BRApi.ErrorLog.LogMessage(si,$">> {sourceCell.GetAccountName(api).ToString} {sourceCell.GetFlowName(api).ToString}" ) Executing the code above I would expect to get base level accounts of node XYZ with Flow Member myF. However, I am getting the base level accounts but the Flow member is XFCommon. XFCommon is not even a Flow dimension member! Any ideas what I am doing wrong !? Thanks!

I have created a Cube View showing Entity, Account and IC members in rows. Under the Data section, I have set the "Use Suppression Settings On Parent Rows" to True and it is working fine. The entity name will not show for every account/IC. However, when I export it to Excel, the entity name will repeat on every account lines.  Is there a way to  get the "Suppress Parent Row" function to work also when exporting to Excel?  Thanks

We are loading files into OS that have substantial amount of data, for some reason I am able to import the file but upon validating, I do not see any kicks out or any error, the validate tab stays the same and Load tab remains greyed out. I am unable to load the  cube. Anyone else experienced this before?Thanks GSJ 

I am looking for an option to read the parsed Excel file XFD range and check if it contains any #Value! cells. I am able to find a point in TransformationEventHandler business rule to capture the parsed data (TransformerObject.Parser.DelimitedParsedValues), but it's not giving all parsed data every time and giving only few lines sometime.Can you please suggest some solution to validate Excel file XFD range before loading it into cube.Also where can I find the details of the classes in OneStream specifically for OneStream.Shared.Engine.StageRangeContent

Hello, When using the Book functionalities, one could loop parameters and change variables. That being said, I am looping a UD1 parameter (parameter name : MY_UD1), that is used by an XFCELL function in another parameter (parameter name : MY_UD1_VALUE). My question is : do I need to use a "change variable" in order to change the value in MY_UD1_VALUE (which is calculated by an XFCELL) ? Here's what I have currently done but is not giving an output :   Regards,

Hello Everyone,We are setting up our Consolidation and Planning application.In Consolidation we would like to set up workflow by entity (legal entity) to support consolidation.In Planning application, we would like to set up workflow by Business Unit to support planning activities by BUSINESS Unit Owner.any thoughts on how we can set up workflow as described above?Thanks, 

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?

Hello, When I execute a Data management sequence or a custom finance function, I have this pop-up that will be shown to the user : Are there any ways to customize what will be shown to the user in this pop-up ? For instance, I want to  customize the message that will be shown in the blank text field below "0% Complete" or the message next to the task when it is running : Many thanks for your feedback ! Regards,

Hello!  My brain is mush so I'm posting this for the bigger audience to please help me brainstorm or answer me directly if it's possible 🙂  Can I use a middle digit on an account name in a member filter? For example, the 4th digit of our cost centers represents location but I'm wondering if I can actually do anything with that. I want to list all CCs with a 4 in that spot but can't quite figure out a good member filter that works. I tried ? like the placeholders in transformation rules and * to no avail. Here's a sample member filter for reference (I'm using it in a QV): A#RD_tot.base.where(name starts with 'CC_SAP_***4') Any thoughts? I could add that fourth digit in a text field or otherwise create an alternate hierarchy but I'm wondering if there's a way to utilize it as is. Any thoughts are welcome!  Thanks & happy Friday! 

I am looking to get more information on how the OneStream Parameter Dialog Box figures out what parameters to present for the end user when they run cube view report. Is there a way to leverage that same functionality to create a delimited listing of the user parameter inputs that can be displayed on the report header or footer?   I know that you can simply add all the parameter references into the header or footer but I am looking for something that would dynamically update to account for new parameters as they are added into a cubeview report.

I have a process that causes contention if launched concurrently by users. Is there a way to check if a session with a specific description is already running? I would like to abort the session if another session with the same name is already running. I tried looking through properties and found "GetTaskActivityItem", but the definition and sample are not of much help.

In BI Viewer,  Is it possible to drilldown to the base level members using Pivot Grid within the same dimension. Like if I pull Entity dimension in a row then is there any way to drill down to the base level members ?Also, Can filters list out the members in a hierarchical /tree format?  Generally combo box/list/tree map displays it in a flat structure so is there any alternative way to achieve it ?

Was going through our app to lock/certify some workflows and noticed that there seems to be a function that I have never noticed before, there is a Corporate Certification Management menu item with two sub items, Unlock/uncertify ancestors and Certify/lock ancestors.  Does anyone know what this does, it's the first time I have noticed it.

I have a scenario where I modified the member property:Number of No Input Periods Per Workflow Unit - 4I thought this would prevent users from inputting data into the first 4 periods (Jan - April).  However, it seems as though it is not functioning or locking the periods.  I can still input into these periods.Am I doing something wrong?Thanks,Sean

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.

We have a user that has the Solver Add-in installed in Excel.  He has to disable the add-in when he wants to use OneStream.  Has anyone else had a similar issue and found a different resolution other than enable and disable the solver add-in?

Hello folks, I'm trying to add a regression line on a scattered chart in Bi Viewer. I'm trying to use Calculated fields but when I arrive to the point of calculating the y in the equation I get an error as a "summary expression" is expected: [intercept] + [slope] * [V4] If I surround V4 with Max or Min it's accepted but no line is plotted on the chart.  Does anyone have a clue if it's possible to add a regression line on a chart?Many thanks  

Hi,   Anyone knows what the LoadDashboardReasonType or LoadDashboardActionType after the user selects the parameters for the prompt upon opening the dashboard?   I want to put a code after the user selects values for the dashboard parameters (see below) and click OK on the prompt.   Thanks!

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.

I have a extensible rule called "A" to update my Derivative transformation rule group. Now during the workflow execution , i want to run A just before the transformation step.Requirementstep1- Load the file.step2 - Before running the transformation , I want to execute AQuery?Where can I add the business rule so that it runs atleast before the derivative transformation kicks in?  

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

Team I have a raw dataset with more than 100 Columns. I would like to connect the data and import 30 columns and have the data imported to cubeview as is. And then will manage the view in Dashboard.   Basically, in Excel world am trying to put a pivot on raw data of 100 columns with output being only few of them. 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?