OneStream Platform Forums

Dear Community Users, We have Blank rows and Blank Columns for the space convention. I'm getting 0s for both blank rows and columns while generating the report. I used below condition: and even tried hard coding 'ReportNoDataNumberFormat = #' in all blank rows and columns. Couldn't be able to resolve it. Any solutions to this are really appreciated. Thanks. If (RowName Contains 'Blank') And (ColName Contains 'Blank') ThenReportNoDataNumberFormat = #ElseReportNoDataNumberFormat = [$#,###,0.00;($#,###,0.00);0.00]End If

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

Dear Community  We want to update an application from the 6.8.1 version to 7.3.3 of OneStream.  Is there any possibility that the member ID could change from one version to another?  Thank you in advance 

When I develop cube views, is it possible to have the description in the header for the data in the rows, for instance first column might be Account, second column Customer.  When I extract the cube view the header for these is blank and I have to manually insert a description to the dimension is relating.  Same issue occurs with quickviews.   Any solutions

We in the process of data validation and are constantly getting  "Exception of type 'System.OutOfMemoryException' was thrown." I know in hyperion we should change the time out.  Is there something similar we can do with onestream?      

In the prior version of onestream we had configured AAD authentication, and we had a service principal that would be used to process REST API requests (aka the onestream "web api").  This service principal was simply to make all the requests for gettting data (cubeviews, adapters). However since we upgraded to 7.1, the REST API has stopped working.  Whenever we present the onestream-web-api with the access token from AAD, it simply generates a bogus error: No Supported Authorization Provider Configured.   The reason the error seems bogus is because the AAD authentication provider is working for all interactive users.  It is only this particular AAD service principal that fails (the one associated with this REST api). We noticed that the release notes for 7.1.0 says: Microsoft is ending support for Azure Active Directory Authentication Library (ADAL) in December 2022. As a result, we have migrated to the Microsoft Authentication Library (MSAL) for authentication

Dear Community Users, As you can see in the above image, last character of the data [i.e., ')'] is getting printed in the next row of the report. I have tried increasing the width of the row. But it's not working. Any solutions to this are really appreciated. Thanks. 

Hi I have a dashboard that executes an Import > Validate > Process using a business rule.In my workflow I am currently using Workspace, Import, Validate, Process, Confirm:I would like to just use Workspace, Confirm, but it gives me the following error: "Cannot execute step because the specified step classification doesn't exist for the workflow profile." Is there anyway around this? Thanks,Mark

We have a requirement to make all the negative value to encode in parenthesis () and to display percentage % for the column "Variance vs Prior year %" in the Cube View. Anyhow, we have written formatting condition as"If (ColName Contains '%') ThenReportNoDataNumberFormat = [#,###,0.00;(#,###,0.00);0.00], ShowPercentSign = TrueEnd If" and it works perfectly fine in the data explorer tab. But while running it in the report it displays only parenthesis () and the percentage sign is missing.  The above is the screenshot from data explorer tab.  The above is the screenshot from while running it in the report.  

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

Hello.  I have a user who is attempting to refresh his excel workbook using the Refresh Workbook button.  The file contains multiple tabs with XFGETs only.  He is returning the following error message.  I can re-create the error on my end, but the refresh workbook also appears to work intermittently.Has anyone come across this error before and know the cause/remedy? 

I have currently set up a new data source and associated transformation rules (and allocated to the appropriate workflow). Data importing is correctly working for 2022 time period, however I am getting the following error in any other time period......I have got the Scenario as 'Current Datakey' and Time as matrix datakey in my columnsSummary: No valid DataKeys (Scenario / Time) found in data source.  Review the source data load processing log and check one-to-one transformation rules to ensure that you have created proper Scenario and Time dimension rules for this data source. Any ideas? I am assuming this might be one simple setting change somewhere 

Hi,  Is it possible to create a dependent dropdown list using a SQL Table Editor? Example below: If I select Entity A in the Entity column, I would like PC1, PC2 to be options within the Profit Centre column. If I select Entity B in the Entity column, I would like PC3, PC4 to be options within the Profit Centre column.   I have tried using 'Selection Changed Server Task' to update a Literal Parameter that I can use as a basis for a Bound List parameter that I am attaching to the Profit Centre column , however this only appears to work after the row has been saved:   I think it may be possible if the user was to save the row after choosing the Entity and then selecting a Profit Centre, but this wouldn't be an ideal user journey.   Thanks, Mark

Hi All, Is there a possibility to update WFScenario for all users of the application from back end through a Business Rule? When moving the app from one quarter to another for Financial Regional planning, some of the not so tech savvy Sales users are forgetting to change their WFScenario and triggering the calculations which are erroring out due to older scenarios being locked. We would like to have Admin update WFScenario for all the users of the application as a maintenance task.  Please let me know if the below would work for all the users. Or any other leads would also be appreciated.  

A#Cash.TreeDescendantsInclusive.Where(Text8 = L1).I have used the above formula to display only level1 members of one account but now I want to like to display level1 members along with the parent members of L1.Help me out in reframing the above formula.Thank you.

Hi guys,I coudn't find the proper hint in OneStream.In my dashboards, I'm using several XFBR string rules or Dashboard extender rules. I would like to move some of them to Workspace assemblies, available starting version 7.4. If I do so, does anybody know how to call a function in there?Stupid example, I'm defining the position of a temporary file to download with an XFBR rule called MyXFBR, function CleanUsername.UrlOrFullFileName=[Internal/Users/XFBR(MyXFBR, CleanUsername)/Temp/FileToDownload.csv] Now I've created the same function CleanUsername in a Workspace assembly named MyAssembly, in a file named FolderManagement.vb. How this should be amended?XFBR(MyXFBR, CleanUsername)?? XFBR(MyAssembly, FolderManagement, CleanUsername) ?? it doesn't look very good.... That's pretty new, but I hope a few guys in this community have used it already. 

Hello,is there a way to grant access to unlock WFs by scenario. for e.g. we need the FPA team to be able to unlock budget WFs and the consolidation team to unlock actual scenarios. Currently, they both have access to unlock all WFs.Thanks for your help. Hadi 

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.        

I am having an issue where the the logo assigned in application properties is not appearing on exported PDF reports. I have sized the image to 50 pixels in height and have set the "ReportIncludePageHeader = True" on the cube view header format. The logo is still not appearing. Are there any other settings that need to be changed for it to appear on the reports?  

Hello, did anyone find the OneStream Foundation Handbook useful for learning the software?  the copy I see on amazon is from 2021.  Are there different editions available?  thank you.

I have a cube view that displays values that are entered monthly. For the months that haven't had any data entered yet, it automatically fills in a 0 in a greyed-out format. Similarly, if I display this same row in a YTD view, it shows the YTD value in the months that have not been entered in yet. My customer would prefer these cells display no value. I cannot find any setting or formatting that will display it that way.I've tried changing the number format to empty string ("") based on IsNoData or IsDerived but that has not yielded the desired result.  

This is OS v7.4.1It is running in a Cube View Extender Rule.I've tried both CubeViewGrid.ExpandedRowHeaders  and CubeViewGrid.AllExpandedRowHeaders    expandedRowHeaders = cubeViewGrid.AllExpandedRowHeaders; int rowNum = 0; StringBuilder sb = new StringBuilder(); foreach(CVGHeader cVGHeader in expandedRowHeaders) { List<CVGHeaderItem> headerItems = cVGHeader.HeaderItems; sb.Append($"Row[{++rowNum}]:"); foreach(CVGHeaderItem cVGHeaderItem in headerItems) { if(cVGHeaderItem.MemberInfo.NameAndDescription.Length>0) sb.Append($"{cVGHeaderItem.MemberInfo.NameAndDescription}|"); } sb.AppendLine(); }    Using cubeViewGrid.ExpandedRowHeaders yeilds :Using cubeViewGrid.AllExpandedRowHeaders yeilds (ironically none of the nested members on Column2): I'm not getting the members shown in the green boxes:  

Hello OS Team,I am testing a few things in the latest version 7.4.1 and noticed something changes from 7.3 but was not mentioned in the release note - so just want to double check in case I missed something:For this Import step, I don't have anything configured in "Calculation Definition", in 7.3 I am able to Load and Process cube without any error, however in 7.4 - the "Load And Process Cube" only did the "Load" and when clicked on "Process Cube", I am seeing the following error.I actually like this change - could you please let me know whether this is indeed one of the changes in 7.4?Many thanksWei

An allocation business rule is not allocating the rates properly . Hence we would like to debug the business rule and also figure out which intersections are passed and what is the value and allocation rate used in allocation calculation . This allocation process involves a formula in UD7 member . Please advise how to see the messages used in api.logmessage . Should we need to create a dashboard to capture the messages that are logged while running the allocations. Again, we are looking for which members used and the value / rate used to allocate.

Every dimension needs to be defined in each Transformation Rule Profile created. 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