OneStream Platform Forums

In a Spreadsheet (TableView) business rule, I am trying to reference the view created during the load of a BiBlend Star Schema. In our case when I create the BiBlend Star Schema tables, I also see that a view is automatically created that links the dimension tables to the fact table. I would like to read this view as my datasource for my table view. I added the line the following line:     sql.AppendLine("FROM vBIB_OneStreamDevelopment_COPA_AnalysisImport_COPA_BiBlend_2023M6") When I open the Table View in the OneStream spreadsheet I get the error message "Invalid object name 'vBIB_OneStreamDevelopment_COPA_AnalysisImport_COPA_BiBlend_2023M6'. I can read this view using a Data Adapter without issue, but when I embed in a Table View rule I get the above error.

Hey All. I have a cube view for a client that contains a decently sized row count. I don't really understand why Data Explorer will only format the cube view to have 4 rows per page. Does the red paging mean anything?

Is anyone else seeing errors when compiling BRs that Imports the WinSCP assembly after the upgrades were applied today?Seeing this when compiling:1) Error at line 69: Reference required to assembly 'netstandard, Version=2.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' containing the type '[Object]'. Add one to your project. 

The below finance rule will sort the members in my case it is entity and it will take the parameters in the Cube view. '*******************************************************************************************************************'Parameters in the Cube View'E#Root.CustomMemberList(BRName=MemberSort, MemberListName=AscEntSort, Memlist=E#[Legal].DescendantsInclusive)'********************************************************************************************************************         Dim Memberlistname As String = "AscEntSort" Dim MemberListstart As String = args.MemberListArgs.NameValuePairs.XFGetValue("Memlist",Nothing) Case Is = FinanceFunctionType.MemberList If args.MemberListArgs.MemberListName = Memberlistname Then Dim objMemberListHeader = New MemberListHeader(args.MemberListArgs.MemberListName) 'members into the list Dim objMemberInfos As List(Of MemberInfo) = api.Members.GetMembersUsingFilter(

Hi All, We are trying to load more than 100 rows through a table view using the method NumberOfEmptyRowsToAdd in the Business Rule: tv is our table view object.  However, when we add a value bigger than 100 in the code, no rows are available to load data in the Spreadsheet. We think is an internal limitation from Onestream to optimize performance. Is there any way to increase this limit? Maybe is only possible with some additional admin privileges in OS?    

Is it possible to calculate slope, Correll and Intercept for a given factors vary by 12 periods using OS Finance Rules? If so, what are the libraries, I need to Import? Appreciate any suggestions how I can implement this in OS.      

Hihi, I am using a variant of the GolfStream finance business rule "XFR_MemberListAlphabetical" and need to pass an additional variable into the rule. For a Finance rule, is it possible for a CV or QV to pass the MF variable to the rule? Currently, the rule is setup statically on a starting entity:   Dim MemberListstart As String = "E#[Total GolfStream].base""   However, because our organization has thousands of entity, the finance rule passes all base entity into the QV. With suppression, I can arrive at the relevant members, however, it significantly slows down the rendering of the report. I've tried using the api.POV command, but it passes the user CV pov, which is not always relevant to the CV. Is there a way to pass a variable using something like an args.NameValuePairs()? I am having difficulty with the limitations of the finance rule VBA set. Essentially, I need the memberfilter builder of "E#[MyEntity].XFR_MemberListAlphabetical,Ent_Sort]" to use "E#[MyEntity] as

Hi All,  In OneStream there are many audit tables containing specific sections that can be audited. I'm looking for a detailed overall data audit showing which user changed which number at what time. Preferably combining loads with (Excel) input. Does anybody know which tables to join to get the good old HFM data audit table?   Thanks in advance,  Marc

Assuming data exists at every base account shown, the data will be accurate at the 69000 – Net Income level using the following account structure in a monolithic cube. 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

I don't know much about method queries, so I'm hoping to get some feedback on how to build off of or reference the data tables as well as where these tables are stored. The ICMatchingForWorkflowUnitMultiPlug method type used in the Intercompany Matching application reports returns the entities as "Name - Description," which causes a few problems for us considering our entity names' were created with an obscene number of characters and underscores. I've copied the reports and data adapters, but not sure how to write the script within the Report Designer or how to alter the data adapter... Any suggestions?

Workflow Profiles can only have dependencies through a Parent/Child hierarchy. Question Credit: Eric Osmanski 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

I have Import/validate/Load workflow.After the validation step , I want to run a business rule that can do the following -1. Sum up the amount for all records with the same Product code in the transformed table.2. Check if SUM = 0 for individual product code.3. If step2 is validated for all product code , then proceed for LOAD step, else error out.PS- I know this can be achieved via a confirmation rule but i want to validate before loading to the cube.One idea that i thought is to execute a validation in the transformation rule but that validation limits to record by record whereas I am looking for validation post all transformation.Thanks! 

Hi, AllWhat's the best way to ensure a specific tree within the account hierarchy has only one member within it.   Would like to have a "count greater than one" alert or a report we can run, as inadvertent accounts affect data integrity.TIA!

My requirement is to load 50 users in Onestream application, instead of manual updating , is it possible to load users in Onestream application ? and please let us know the steps. thank you

hi , i am trying to add the users in OneStream planning application, how to add the bulk users in OneStream, tried with extract xml file and copied that in Excel but formatting is not supporting.  Note: External authentication Provided is AzureSSO Thanks in Advance

When mapping an item from the "Validate" step in the workflow, it is possible to save the mapping to an "(unassigned)" item.Is it possible to restrict the storage of the mapping so that it cannot be mapped to "unassigned"? Thank you

We created Extensibility BRs that leverage WIN SCP commands to send data from OneStream to an internal directory using an SFTP connection setup with OneStream.  The data files are being received with a .filepart extension.  We were able to get the .filepart feature disabled in our OneStream environment; however, the csv files are continuing to be received with the additional .filepart extension.  Any suggestions on how to eliminate .filepart extension when files are sent / received?

With SQL Connector as Data Source, can we automate to Import, Validate and Load multi period and multiyear data (Ex: Jan 2023 till Jan 2026) in such a way the Import, Validate and Load occurs one period after the other sequentially?Query execution times are much lesser when pulling one period at a time Vs pulling ALL 36 periods together, so I want to explore this option.   

Can you please guide me the definition for the below points - 1) What is number of NODATA,Zero,Real,Derived cells ? And why are they all under NODATA Status ? 

I am trying uploading a .csv file but i am getting transformation errors. In the source file the 3 rows are blank. How should I set the criteria value text anywhere within a line that triggers the lines to be bypass  

Dear Community, For one of my project I need to get the values of a given cube view as a data table within my business rule. I can fairly use the FdxExecuteCubeView which will give me this kind of output :   Cube Entity Local Scenario Time YTD Account None Top None None None None None None None None None 22.86874 21.68644 1.182297 5.451777   while my cube view is only showing accounts in rows and time in columns. One of the problem here is that I don't get the columns headers for the values ... So my question is : is there a way to get an data extract in a form of a data table directly from a cube view with the same rows & columns headers only ?   Many thanks and happy holidays !

Been searching for a while on the forums and knowledge base and documentation - maybe I'm not searching with the right text because I'm sure we can't be the only ones to deal with this. In a multi-tabbed dashboard, we have a button on each tab to 'Refresh CubeView' which is supposed to refresh the current cube view. The button is connected to a "Selection Changed User Interface Action" and the action selected is "Refresh" with a number of dashboards listed to be refreshed. Our problem is that when the Refresh Button is clicked on, after refreshing, the focus takes the user away from their current tab and re-selects the first tab in the dashboard. Does anyone know if there's a way to control this so that the focus remains on the current tab?

Hello, Has anyone used the DataManagementEventHandler business rule before and identified the CalculationType of the DM (i.e. Force Calculate, Consolidate...)? And also the Data Unit and the POV of the DM? Colud anyone share an example? Thanks in advance,

I have a dashboard that has 2 components,. 1. A Combo Box that is populated with a sql query in a Bound List Parameter. 2. A Spreadsheet that is populated with a Table View.   The table view is generated using a Spreadsheet Business Rule. How do I pass the selection from the combo box to the table view?   Thank you for any suggestions.

I am having an issue with cash flow report taking last month's (ie Dec 2022) value to aggregating it to the year to date (ie 2022), ignoring other months (... Oct, Nov, ). Does the account type get affected by the view dimension, whether periodic or YTD?  Or this might be affected by other settings in the dimension. The scenario settings for the Forecast for Input View for Adjustment are periodic, similar to No Data Zero View for Adjustments and Nonadjustments.