Discuss the features and functionality of OneStream.
Recently active
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
Hello; Im crating a cube view with 2 rows (maybe more) that one of them is a result of a complex function: "A#INCOME_STATEMENT.Base.Where(Text1 Startswith On-Campus)" and shows several rows qualified as Text1, now I want to sum those Accounts but don't like to use each Account; it could be possible to use a function in a 2nd row like this: GetDataCell(A#INCOME_STATEMENT.Base.Where(Text1 Startswith On-Campus))::Name(On-Campus) is that possible? Thanks in advanceand best Regards. Mario GV
Hi,Is there a report to check how data was entered into OneStream i.e. through Forms or Imports ? We are using cloud version of OneStream.Regards,Avijit
If you encounter an Amount field that has spaces as the thousands separator AND includes a DR/CR indicator (e.g. 12 345 678 D) then you'll need this to parse the value: Dim strRawAmount As String = api.Parser.DelimitedParsedValues(4) ' Zero-based and adjust for your columns! '----------------------------------------------------------------------------- ' If not empty then remove space separator and interpret D/C indicators If Not String.IsNullOrEmpty(strRawAmount) Then Dim strAmount As String = strRawAmount.Replace(" ", "") ' 12 345 678 D becomes 12345678D Dim strDRCR As String = Right(strAmount, 1) ' D or C on end of string? Dim dAmount As Decimal = Left(strAmount, len(strAmount) - 1).XFConvertToDecimal ' Strip D or C and convert to Decimal '----------------------------------------------------------------------------- ' Did conversion to Decimal work? If IsNumeric(dAmount) Then '
How to customize the OneStream Excel Addin Ribbon. In Excel, go to File > Options Select Customize Ribbon Select Main Select the OneStream Tab on the left – that is the source of all the buttons Select the Onestream Ribbon on the right – that is your target customization Move the buttons you need from left to right. You can create groups for your menu too. If you want to separate the Save and Refresh, you first need to Remove it and then recreate it. Like shown in the screen above. You can then create a ribbon like below where I separated the Data Refresh vs Data Save. Unfortunately each user has to do that.
Im trying to create a workflow Event Handler that kicks off when lets say a period is locked April 2023 will then kick off a stored procedure that copies data from a table leveraging the wtk of the locked period.
Summary Is there any documentation and/or sample code showing how to use the new "dbWheres" argument in a LookupRowFieldValue() function? Detail In version 6.8 (maybe earlier), if you use .LookupRowFieldValue() with your criteriaExpression (i.e. - your where clause) as a string you get a warning that this syntax is obsolete. It still runs, but obviously we shouldn't use it going forward. So, something like this now throws an warning: .LookupRowFieldValue(si, dbLocation, tableName, criteriaExpression, fieldToReturn, defaultValue) .LookupRowFieldValue(si, dbLocation.Framework, "SecUser", Name = 'Phil Brosnan', "Email", String.Empty) OneStream wants you to use a new Syntax that replaces the criteriaExpression with a list of where clauses in a dbWheres object. .LookupRowFieldValue(si, dbLocation, tableName, dbWheres, fieldToReturn, defaultValue) Unfortunately, there is no documentation or examples on what a dbWhere object is, how to create one, or how to pass that dbWhere object into your
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
I have a BR that copies Actuals scenario data to a planning scenario (Mgmt_Actual). It copies Post close adjustments that only exist for USD->AdjInput in Actuals from/to the USD->AdjInput and like Actuals there is no local data in the Mgmt_actual scenario. I then try to copy the same data from the Mgmt_Actual to a forecast scenario. But the calculate data writes to the Local->AdjInput (consolidation/Origin) member, not USD. And when I run a consolidation it calculates USD with the Origin member AdjConsolidated. I'm using the exact same code to copy (calculate) the two scenarios. Any ideas why one calculates USD->AdjInput, yet the other lands at Local->AdjInput?
Does the api.Data.GetDataBufferUsingFormula("FilterMembers(...)") only get cells that have values? Is there a way to create a data buffer with empty cells? Use case: We need to to cycle through an account hierarchy and populate each base account with data from an intersection of a specific Account, UD2, UD3, and UD4 that are defined in the text fields of the particular account that is being populated. The other dimensions of the data buffer are limited to a single member (i.e.":V#YTD:F#End_Bal:O#Import:U2#000:U3#0000:U4#0:U5#None:U6#None:U7#None:U8#None")
Hi All, We have 8 sibling Import workflows under one parent(Base Input Type Parent). We have one entity that's being used to load data in all 8 import workflows. Because we have good volume of data and multiple users loading the data to each workflow, whenever someone try to load the file through any workflow it is processing Load Cube for all remaining workflows as well and this process taking long time. It seems to be expected behavior of workflow design but Is there any recommendations that I can try to reduce the processing time ? Any suggestions would be much appreciated.Thank you.
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.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.