OneStream Platform Forums

Hello - we would like to move specific Forms and Adj data from one application to another - data are extracted via Data Export in DM, does anyone have an example of the Extensibility Rule (BRApi.Finance.Data.SetDataCellsUsingUsingCsvFile) to load the extract data? Many thanks - Wei

Hi, I have an application DB table with a date column and I am using the LoadCustomTableUsingDelimitedFile function to load a CSV file to the table. The xfDateTime# token is assigned to the column in the LoadCustomTableUsingDelimitedFile  function. The dates in the CSV file are in the dd-mm-yyyy format. However, the LoadCustomTableUsingDelimitedFile function assume the dates are in the mm-dd-yyyy format. Data is loaded but when querying the table using the Month() SQL function for example, the day is return instead. Is there a way to make sure LoadCustomTableUsingDelimitedFile  knows the date column in the data file is in the dd-mm-yyyy format? Thank you

Whats the Table name where all the Dimensions are stored ? I need to generate/Automate a report which will give me a list of all Dimensions setup in our system. I can do it using the Extract process But I need to write a business rule to SFTP the output of the dimensions data

  If you’re using a dimension for only dynamic calculation members, it needs to be enabled on the cube where you want to use that dimension. 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

Hi all, I'm still new to Cube Views and how dynamic they can be.  We currently have 3 separate Cube Views, call them Canada_Results, US_Results, and UK_Results that are run independently by different users. These each have their own unique Account and UD intersections in each row. Our corporate group would have their own Cube View, call it Global_Results which displays the total results.  Is there a way to build our rows in Global_Results to simply "grab" the row results from these existing Cube Views using a function like GetDataCell? We'd like to avoid creating calculated accounts or re-entering our Account/UD intersections as a formula for each row in Global_Results as that would get tedious for us to maintain.  Thanks!

Hi, I have a data management step/data management sequence that use member dialog parameters, which means users are prompted for the parameters selection when running them. I have attached the data management sequence to a Pre-process step of a workflow (via calculation definition, setting the filter value equal to the data management sequence name and using a DataQualityEventHandler rule). However, when running the Pre-process step the data management sequence runs using the default values for the parameters and users are not prompted for the parameters selection. How do I make so that users are prompted for the parameters selection when running the Pre-process step?

My Cube view has entities in rows. One of the rows is a sum of several entities ( E#A1+E#A2+E#A3). In the 4 columns I have Actual, Budget, Variance and Variance%. Variance and Variance % being calculated from the two first columns. Works fine except for the row that is a sum of several entities. For this row I believe the variance-columns displays the variance for the first entity (E#A1). How can I solve this? Can I set calc order anywhere?

Hi,  I'm trying to look up values from a VLookUp table (previously made in the Transformation Rules) within a Complex Rule in my Data Source, MMomentoff how could I this? Thank you very much in advanced.   Best, Nieves

How do I combine XFMemberProperty with Dynamic expansion in a cube view?  E.g. I want to expand Entity and account on Rows. Row1: E1 =E#Total.Base, E2=A#FinancialAssets.Base in columns I have transaction and ledger amounts (UD5) and then I want to add one column with entity currency and one with Text8 which we are using for region. Based on the entity on each row. So the XFGetMembers should reference to Row1 Expanion 1. Col1E1: U5#DS_Trans_CCY Col2E1: U5#DS_Ledger_CCY Col3E1: XFMemberProperty: Currency Col4E1: XFMemberProperty: Text8   Entity.Base Account.Base Trans CCY (UD5) Ledger CCY (UD5) Currency Text8 Entity A Account 1 10 100 EUR Germany   Account 2 15 150 EUR Germany Entity B Account 1 23 56 DKK Sweden Entity C Account 1 78 78 SEK Sweden  

I am trying to create a form template using all base and Origin as form.When I am running the form through WF,i get a light green shade in the fields where I need to key in data.Any suggestion as to why I am unable to see the white cells?

Hi, We have a cascade entity structure, where one of the sub-elements consolidates up to a certain period, and after that period the other begins to consolidate. Entity A1 has an investment in Entity B11. Consolidating 2019M12, the application calculates an elimination of consolidated reserves in both parents Entity B1 & Entity B2, regardless of the fact that Entity B2 does not consolidate until 2022M8. I would like to know if anyone else has had a similar problem and has been able to solve it. Thank you, Sara

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?

Hi Experts, i am trying to read the line items from celldetails. I think i get the sytax of BR functions it compiles fine but getting  "Object reference not set to an instance of an object." error so something is wrong with script? I am able to read Cellamount just fine using the Member Script. Requirement is to get the cell detail in the report along with amount.    Below is the line from the code: LineItem = BRapi.Finance.Data.GetDataCellUsingMemberScript(si,"AUM","Cb#AUM:E#RevAccComments:C#USD:S#RevAccRecon:T#"+ FYQ +": A#MGMTFEES:F#CQ_MGMT_FEE_REV:O#Top:I#None:U1#None:U2#None:U3#None:U4#"+ Product.Member.Name +":U5#None:U6#None:U7#None:U8#None").DataCellEx.DataCellDetail.LineItems.LineItems.Item(0).Classification   any ideas on why this is not working? 

I am working with a client the requires the first row of each section of their reports to have a dollar sign.  No other rows in the section (outside of the total) need a dollar sign.  The cube view also has row supression on which means the row can and will change depending on the account, time and entity. Has any one encountered this before?  

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. 

Hello All,    I am trying to create a cube view or report if necessary to list our active Entities. I've been able to filter by "In Use", but we also need to include the Member Property of "ReadWriteDataGroup" where its set to "Administrator".  Is that even possible or would a Business Rule Member List contain the arguments necessary? Thanks for any suggestions!

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

Hello, We are in the process of building workflows . During the demo of required workflow forms, there are some check reports built for users to verify their data and add comments. When the user switches between report tabs in the workflow, the refresh takes approximately 20 seconds to a full minute depending on the report. Our implementation partner suggested reducing the number of columns. We do have several columns of data, however this is needed for a proper review, and would like to review alternatives before reducing the reporting content. Is there anything else we can do to increase report refresh speed when there's multiple columns? Thanks, Will

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?