OneStream Platform Forums

Hi,We have installed ONC after upgrading OneStream to version 8.5. Before that, we were using the standard application reports and attached the Intercompany Matching Report as part of one of our workflow steps. Is there a way to replace that by the ONC Intercompany report instead? It seems like we can only add the Frame_ONC_OnePlace dashboard as when we add the individual interco report we get the following prompt: Any ideas would be very appreciated.Thank you for your help!

Hi All,I'm working with FdxExecuteCubeView and cannot export the dynamic calculations in V#Annotation even though I have includeCellTextCols as True. The OS documentation also says that it's possible to extract Dynamic Calc results.In my CubeView I have a dynamic UD8 which returns the value kilogram in this case:   Here's the code I have right now:Dim nameValuePairs As New NameValueFormatBuilder(String.Empty,customParams,False) Dim filter As New System.Text.StringBuilder Dim parallelQueryCount As Integer = 8 Dim logStatistics As Boolean = False Dim includeCellTextCols As Boolean = True Dim useStandarFactTableFields As Boolean = False Dim dt As New DataTable dt = BRApi.Import.Data.FdxExecuteCubeView(si, cubeViewFilter, "","","","","", nameValuePairs, includeCellTextCols, useStandarFactTableFields, filter.ToString, parallelQueryCount, logStatistics) Return dtAnd the resulting data table shows 0.0 instead of kilogram: &nbs

Hi, my company's OS data integration with the ERP system has been set-up to load monthly TB's into OS and for transactional tables to sit outside of OS but with the ability for OS to query and drill-back to view transactions. The transactional drill-back function is limited in that a drill-down first needs to be performed to get to the detailed dimensional intersections at the lowest UD level before a drill-back to view transactions (at that precise lowest level set of dimensional intersections) can be run. It is therefore easier to use a stand-alone BI viewer outside of OS to view transactions.Am wondering - is it possible to load ERP transactional tables into OS (this may contain millions of rows spanning multiple years) and for OS to then display transactional level detail across higher-level roll-ups (e.g. viewing transactions across a cost centre parent rather than only at an individual cost centre level), or even display transactional detail in quick views, essentially making OS

Hi Everyone, I know we can use culture settings to show users localized member descriptions, or XFStrings to change text in dashboards, but what defines the display language of the core UI? If I wanted the desktop or browser app's UI to render in another language (e.g. French for certain users), what options do I have? Thanks

Hi I have a derivate rule that I created that returns the absolute value of an amount based on column name. The column names are assigned in the data source and based on the data source column it will either assign an absolute value or a negative value. I want to be able to pull a column in my derivate rule that is a text attribute column and if the text equals something like "S5" it will do some type of conditional logic. With my limited experience with derivative rules and research it seems this cannot be done via a derivative rule. First question: Is there a way for me to do this? Second: If not, is there another alternative way that I can extract the text field of a column and based on that to do some type of additional logic? 

Hi All,I am working on a Cash Flow Cube View to show the beginning cash, ending cash, and change in cash (activity) in three separate rows. All the base cash accounts are under the new parents (beginning cash, ending cash, and change in cash) in an alternate account hierarchy for the Cash Flow. We are using the BegBal_Dynamic flow member from the Blueprint app for beginning cash, EndBal for ending cash, and Activity_Calc for the change in cash. Figures are flowing in, but for these accounts the columns have a view member set to Periodic, QTD, and YTD. The problem is that figures are not representative of the View member, that is to say that they are all the same on the ending cash. Below is a screenshot and the Cell POV for each of the members. I am happy provide any other screenshots or additional information to get a resolution on this.Thanks in advance!MTD (Periodic):Cb#Batesville_Cons:E#LE_TOT:P#?:C#Local:S#Actual:T#2025M5:V#Periodic:A#End_Period:F#EndBal:O#Top:I#Top:U1#CC_TOT:U2#P

Hello everyone, I'm just wondering if there's a method or a way to delete ALL Data with a click of a button.I know about data management steps and the use of it along with the finance BR.So my concept and idea is that, I allow the user to select the member (step 1) or list of members (if step 1 is good). Then the user can click one button to delete all data. Why I want to do this is because let say the user want to delete a certain member, it will be easier for the user to do so.I tried to retrieve all the cubes that I have in the application and changing it via the scriptbuilder/databuffer method and setting the cell to 0 but the concept of DataUnit do not allow us to do so. Thus, I am here seeking for guidance and wisdom from the community. :)Thanks! 

Hi All,There are two files. I can decrypt one file but unable to decrypt the second file during the integration stage, getting this error:Session details have been confirmed. No changes there.Any thoughts how I can troubleshoot this?

I have a dashboard that uses a Tree View.  Its in a named workspace.  The only way I can get images to work with it is to upload the images to a Default Workspace.  Is there a way to reference my images in the workspace where the Tree View is?  

When the Flow Processing Type "Is Alternate Input Currency for All Accounts" is enabled on a Flow member (as shown below Data Intersections become invalid for that Flow member and Foreign Currencies (USD, CAD).Entity BU_200 default currency is EUR. Note that when this property is not enabled the foreign currency cells are valid.My understanding is when this setting is enabled the foreign currency data cells should be enabled for data load or input. Appreciate any clarification on this.

 In the world of Enterprise Performance Management (EPM), clean and accurate dimensional mapping is essential for a reliable reporting process. Fortunately, OneStream makes this easier through its robust Transformation Rule framework, which intelligently handles new dimension members automatically.Whether it's a new GL account, cost center, or entity, OneStream’s transformation engine ensures that new data doesn’t derail your process, even before user intervention.🔍 Key BenefitsDynamic Member DetectionWhen a new source member enters the system—say, a newly created account in the ERP—OneStream flags it immediately as “Not Mapped” in the staging area. This provides the user or administrator with a clear indication that attention is required. Mapping can then be quickly added or adjusted to keep data flowing seamlessly.Centralized and Flexible MaintenanceTransformation rules support Wildcard and Dynamic Mapping, making it easy to set default routes for unknown members (e.g., directi

Has anyone built a cube view, or more likely a dashboard, that can automatically compare the base level members of 2 or more hierarchies in a dimension to identify exceptions?  We do this manually now in Excel but was asked by the users to put this comparison in OneStream. I thought this might be an application report, but I don't see anything close.  Also, we are currently on v7.4, so if there is a feature in the latest version please pass along. Thanks!  

Hello OneStream experts, We are trying to extract a maintenance unit and all it's components underneath it using a BR/Extensibility rule with the latest OS version - 9.0.1. But, however after the run we could able to see a empty xml in the fileshare folder. Below is the snippet of code which we are using. Any suggestions or help would be greatly appreciated. Thanks!Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As ExtenderArgs) As Object Try Select Case args.FunctionType Case Is = ExtenderFunctionType.ExecuteDataMgmtBusinessRuleStep, ExtenderFunctionType.Unknown 'Get Configuration Settings Dim configSettings As AppServerConfigSettings = AppServerConfig.GetSettings(si) 'Data Management extract location Dim folderPath As String = FileShareFolderHelper.GetDataManagementExportUsernameFolderForApp(si, True, configSettings.FileShareRootFolder, si.AppToken.AppName

Hi Everyone, Is there any possibility not display Dimension icons in the cube view reporting?   

Hi, while reviewing the Workflow status view in the Cube root profile, I noticed a second tab called Cube that I hadn't previously paid much attention to. The tab appears to be empty. Does anyone know if this tab can be customized, for example by adding reports? What is the purpose of this page? 

We have an Excel workbook with a *lot* of embedded cube views and table views. Some sheets have two Cube Views with Excel formulas showing significant differences. Others have stacked Cube Views showing Import, IFRS Adjustments and Total. We cannot use Books because of this. It takes about an hour to refresh the workbook so we want to automate the refresh somehow.Anyone have any suggestions about how to automate the refresh?ThanksMarcus

Has anyone seen the above error message or have thoughts on what it might pertain to.  I am trying to load a delimited file to a BI Blend table. My test file only has 5 records. When I import the data it gets to 12% Complete - Translating Cache step. The only place I can find a reference to this field is on the file suffixed with '_RS'. BI Blend definition  Error Msg:  

Dear community,We are using a Dashboard Extender Rule to trigger a ExecuteCustomCalculateBusinessRule.The business rule that we are running is a finance business rule that contains databuffer formula's.Since we can only run a finance business rule for one entity, we have created a MemberList that is running the Finance Rule each time for one of the 1500 legal entities that we have.This caused a Server Timer Out error.Do you know if  the ExecuteCustomCalculateBusinessRule runs for each entity separately or for multiple entities in Parallel that is  causing this TimeOut?  

I'm building a cube view with the above requirements. It should should something like A#Net_Income.Tree, but in reverse and it should also exclude base members. I've tried a few combinations like A#Net_Income.TreeDescendantsInclusiveR.Where(HasChildren = True) (no results) A#Net_Income.Tree.Where(HasChildren = True) (only shows top member) A#Net_Income.ChildrenInclusiveR, A#Net_Income.Children.Children (wrong sort order) I've also tried including the .Remove() function in a few different ways with no results. Manually specifying the base members is not an option. I believe the issue is that the .Where(HasChildren = x) function is not compatible with the .tree expansion. Has anyone built a report with these requirements that could guide me in the right direction? Thanks in advance.

Hello,I'm using OneStream version 9.0 and have built a dynamic dashboard that serves as a container to display other dashboards. The dashboards being displayed were created in older versions of OneStream and use parameters to define embedded dashboards.When I try to open these dashboards within the dynamic dashboard, I get the following error message:#ERROR: Unable to open embedded dashboard '[dashboard to display name]' while processing component '[my embedded dashboard component]'The dashboard to display name is correct, so the parameter seems to be working. Also, when I open these dashboards directly (outside the dynamic dashboard), the embedded dashboards display correctly.Is it still possible to use parameters to define embedded dashboards within a dynamic dashboard in version 9.0?

Hi Everyone, I have a requirement to pull the data in a particular format in my cube view. I have entity dimension members in a row which gets pulled from the cube. I have to pull the respective opening dates of the stores from the custom table in the cube view as a column. I have created the custom table (with store and opening date) and used a business rule to pull the opening date from the custom table. Now I want to display this in the cube view w.r.t the stores we are pulling in rows. For ex if we have a row with Entity (store) tx0001 in the cube view which has an opening date for the store in the custom table. This opening date needs to be displayed in the column w.r.t to the store in the row. How to achieve this?    Thanks, Jeevan  

Using an expansion such as .Tree is there a way I can have the header text display the member description for parents and the name & description for base members?

HI Experts,  I have a parser rule that looks at current attribute 9 and compares it with attribute 9 of last year December load and returns it as attribute 10 which helps me map the differences in Tiering. My issue is - the file is huge around 15k lines and its taking ages for this comparison. How can i make it run a bit faster ? Any help would be appreciated.   PARSER RULE BELOW FOR YOUR INFORMATION: Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As ParserDimension, ByVal args As ParserArgs) As Object Try     Dim Time As String = BRApi.Finance.Time.GetNameFromId(si,si.WorkflowClusterPk.TimeKey) Dim WfYear As String = Time.Substring(0,4) Dim WfYearPrior As Integer  = WfYear - 1 '   'Get the fields for comparison Dim AttrColPosition As Integer = 97 Dim CurrString As String = api.Parser.DelimitedParsedValues(AttrColPosition) 'Brapi.ErrorLog.LogMessage(si,"My Currr A8  is " &CurrString) &nbs

I am trying to create a fx account that would dynamically pull based on scenario.  Below is the code I used for actuals and budget rate and it works great, however, for our forecast rates it does not pull any data.  The picture below shows the names of our fx rates, ie FCST_111 etc.  How do I create an account that would pull Fcst rate associated with the relevant scenario, ie S#fcst_1_11 = fX RATE = FcstAvgRate_1_11   Dim viewMember As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId) If viewMember.IsAnnotationType Then     'Return an empty string if this is a text-based dataCell.     Return "" Else     Dim destCurrId As Integer = api.Pov.Cons.MemberPk.MemberId     If destCurrId = Currency.USD.Id Then                     Return 1.0     Else&nbsp

Is it possible to create a data source to load annotations only from a flat file.I am tagging the annotations in the flat file with the View dimension.It seems like the data source always wants an "Amount".  Is this case I have no amount so when I Ioad the data file, I get an error that "No Valid Data Keys in File".  It seems that this should be possible.  Maybe I should do this via Excel loads.