OneStream Platform Forums

Hi all,I have a 'working' DrillBack script which connects happily to my SAP ByDesign system. However, I want to extend it's flexibility and get it to DrillBack to the active WF year and period which is not necessarily the current WF. However, regardless of me even hard coding a start and end date rather than receiving the WF settings, it will always take the year element from my BR script but the currently active accounting period in SAP ByDesign as the end month. Is it a OneStream issue or a SAP ByDesign issue that I am not understanding whereby it will ignore my web-request parameter and just go with the active period ? Example 1 of the WF timeDim wRequest As WebRequest = WebRequest.Create("https://my999999.sapbydesign.com/sap/byd/odata/FINGENERALLEDGER_analytics.svc/RPFINGLAU02_Q0001QueryResults?$select=CPOSTING_DATE,CCOMPANY_UUID,CGLACCT,TGLACCT,CFISCPER,CACC_DOC_UUID,TACCDOCTYPE,CNOTE_IT,TOEDREF_OBJ_TC,FCDEBIT_CURRCOMP,FCCREDIT_CURRCOMP&$filter=PARA_COMPANY%20eq%20%2

Hello, I have a requirement where I'll have to read the current month in XFBR rule and return a string based on a few conditions. The time filter in the columns is set to |WFYear|.Base. I've tried a few different variables, but they're all only passing on the year. When I divide the columns up into specific months, I get the required results, but I'm searching for a method that I can use when that's not the case. Is there something similar to api.pov.time.name that I can use in XFBR, or is there any other approach that I'll be able to use? Thank you, Manasa

Hello All, How to add validation for an account while importing TB. Condition is that, number should be > 0 then allow. If  'account code'  < 0 then throw error and validation should fail or show error message  Thank You. Regards, Yashwant

OSAdmin Is there a way through which OneStream user's ability to use/view the Lock/Unlock options on Workflow Profiles (Review, Base Input, Parent Input) Steps can be restricted/disabled, we have provided below application security roles to Admins Only, still users having access to their respective workflow have the right click - lock/unlock optionThanksVishal Pai

Hi all, I'm receiving the error in the subject when executing a MemberList. This is the ML code, it should retrieve base member of "TF" in the flows dimension with SwitchType attribute set to True. Dim objMemberListHeader As New MemberListHeader(args.MemberListArgs.MemberListName)Dim objFlowList As List(Of member) = api.Members.GetBaseMembers(api.Pov.FlowDim.DimPk,api.Members.GetMemberId(api.Pov.Flow.DimTypeID,"TF"))Dim FlowMemberID As IntegerFor Each FlowMember In objFlowList   FlowMemberID = api.Members.GetMemberId(api.Pov.Flow.DimTypeId,flowmember.Name)   If api.Flow.SwitchType(FlowMemberID) Then objFlowList.Add(flowmember) NextDim objMemberList As New MemberList(objMemberListHeader, objFlowList)Return objMemberList Any advice, really appreciated Thanks and regards Massimo

Hello!  Looking for some feedback on how your company records and reports on both IFRS and GAAP standards. Do you use a UD as a sort of data type to record adjustments where they differ between IFRS and GAAP? Or do you use different accounts with an alternate hierarchy? Or something different?  Interesting in hearing from anyone with any suggestions - thanks!

Hi, Can anyone help me how I can use this Selection Change server task I know how to run a DM Sequence from button but if I can directly run a custom calculate without a sequence that will be great. I tried these syntaxes, but it is not working.   Thanks  Omkareshwar    

Hi Everyone, In building out our financial reporting, I was seeking to get some opinions on best practice related to adjustments for financial statements when scaled and rounded to millions. We are coming from doing our consolidations and external reporting in Excel and reconciling to the external financials is always a challenge when pulling numbers out of our prior tool (TM1) as the quarterly adjustments never then add up to the full year adjustment.   We've been told that there are OneStream implementations where they have rounding done through business rules and account text fields. But have also been told that really the best practice is just to do rounding numbers in our filing tool, versus in OneStream.    As users and technical experts, what are the opinions on what the best practice really is for this stuff? Thanks! 

Hi Team,   I'm wondering if there's a parameter that can be used in OS for a new line? I mean there's already a |SPACE|, which works perfectly, but I would need such parameter for new line (like \n in VB.NET), any ideas?   Thank you!

Hi  I am trying to delete files saved in public folder via business rule. Below BusinessRule.Extender works fine to delete the files from share folder. Dim configSettings As AppServerConfigSettings = AppServerConfig.GetSettings(si)'*** First Delete files from username folder created under Data Management->Export folder****'------------------------------------------------------------------------------------------------------------Dim xfolderPath As String = FileShareFolderHelper.GetDataManagementExportUsernameFolderForApp(si,True, configsettings.fileShareRootFolder,si.AppToken.AppName)'**xfolderPath stores the path for DataManagementExportUsernameFolderForApp**Dim filesToDelete As String = "TRF_Rules_*.xml" '; // Only delete all files which starts with names TRF_Rules*Dim fileList = System.IO.Directory.GetFiles(xfolderPath, filesToDelete)For Each file As String In fileList'System.Diagnostics.Debug.WriteLine(file + "will be deleted");System.IO.File.Delete(file)Next   H

Hi    I want to read a text value from dashboard in finance business rule. I tried attaching a parameter to text box component and then read that parameter in the code but that is not working.   Thanks, Omkareshwar    

I would like ask about culture settings and how it influence casting from text value to decimal number. We have an automated import from external system using delimited files and pre-stage table in application database. From the file the data is loaded as a string and from the string it is translated to the decimal value in connector. We use the query here (see that there is explicitlely specified a culture to be used for a casting): selectIFRS_account, ledger_id, currency, pairing_code, ICS_code, Partner_description, PARSE (local_ccy_amount as decimal(26,5) using 'en-US') as local_ccy_amount, PARSE (transaction_ccy_amount as decimal(26,5) using 'en-US') as transaction_ccy_amountfrom [dbo].[MyExternalTable]where importGUID = '{import_GUID}'and _tbValid = 'Y'and coalesce(ICS_code, '') = '' During the testing we found that culture settings for user have an influence on the results. How is that possible? I thought this is a job for a server side and there should be no effect of client app

Hi all, In our OneStream environment, we have few hundred users and few thousand groups to which these users are assigned to for granular access. Want to check these with OneStream admin Gurus:1) Currently the semi-annual user re-certification exercise is done manually by extracting the OneStream user/group access reports and asking the approvers to re-certify. This is proving to be cumbersome exercise. How do you all do this in your environment?  Are there any best practices about this?2) Have you used or seen/heard about a third-party tool like SailPoint being used to manage OneStream user / group access and resulting re-certification activities? How difficult it was to build integration between a tool like SailPoint and OneStream?I would love to hear your experiences.Thanks in advance for any experience sharing.

I am modifying a business rule that uses the entity name to search a similarly named (Entity_Acct_Description) table and return a value.  I want to verify that the table exists before attempting the TransformText to prevent errors in the case of new entities or name changes.  Is there a way to verify the named object exists before executing the code?   ElseDim LookupTable As String = TEntity & "_Acct_Description" ''''IF Lookuptable exists do this''''SAccountDesc = BRApi.Utilities.TransformText(si, SAccount, LookupTable, True)

Hi, Is there an easy way to get MemberScript from the DataCellPk? I can see a method called 'GetMemberScript' (what a surprise) on DataCellPk object, but it doesn't work (or I cannot figure out how it works) in Extensibility Rule. The goal is to take the details of one DataCell, replace one of the members and process (validate) such created reference to another DataCell. Any tips? Best, Karol

Hello team,has anyone implemented the drillback functionnality in onestream ?I need help to build it ? Is there a pre-build module ? Or what are the steps to put it in place ?Thanks in advance !!

Hi, I'm currently using a FDX query to create an automated Journal. Works basically fine but when the FDX query is completely empty it throws an exception error message. Not a very big deal but the users experience this as a failure of the system. Does someone know a way to avoid this throw or to customize the exception error message in case of an empty datatable? FYI a check on the datatable (f (Not dt Is Nothing) And (dt.Rows.count > 0) Then) still gives the throw.   Thanks!  

Hello,I am wondering if it is possible to open the Data Attachments box by clicking a button on a dashboard instead of right clicking on the cell and selecting Data Attachments for Selected Cell and then clicking the Create Data Attachment button?Thanks!

Hello, I am looking to connect with folks who have implemented specialty cubes to manage data for sales, HR, Projects, Treasury, etc. We are exploring the capability of building a digital transformation roadmap using a cube approach, similar to how Essbase can be used. We are considering using the register to utilize larger data sets and other functionalities. Would love to hear your experiences. Thanks! Regards, Ronnie

You cannot change BiBlend configuration if a Workflow “Blend” step has already been executed Question Credit: Jack Lacava 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 Everyone, I hope all are well.   I am trying to use the GetICMemberFilter function in a business rule but I don't know how to get the VarybyCubeTypeId.   Does anyone would know how to obtain the VarybyCubeTypeId using a XFBR?   Thank you for all the help.

Hi All, I am trying to find the best way to load my budget day. I currently have 22 departments, 207 accounts and 100 facilities that I need to load too. Do either of you have any suggestions on what's the most effective way to get my data loaded in OneStream that will take the least amount of time? I greatly appreciate your input.   

Hi all,In our use case, users are uploading data through files into OneStream. Is there a possibility to check if the file have 1000-seperators in the file and block the upload if this is the case? Reason is that within one workflow the 1000 seperators could differ between users and we want to avoid issues in this instance. Ideally we have a parser rule that checks the amount column.With kind regards,Tim Vierhout

Hi,I wonder what's the difference between IsConsolidated member property and Aggregation Weight which is relationship property? When one's usually set IsConsolidated to False? I can imagine that it make sense for non-additive values (like KPI's), but I'd rather use for that Aggregation Weight, so not sure what for is that differentiation. Any tips, example use-cases?

I have two questions: ud3 text2 has text which is the entity on where we are going to seed to..  1) I want a memberlist where Text2 is not blank or has no data. I am wondering if Text2 <> '' is the correct way to go? 2) What is the syntax of brapi or api.logmessage to see what is in the memberlist?   'Dim memberFilter_UD3 As String = "Cb#CONCUBE:U3#PCHEAD.Descendants.Where(Text2 DoesNotContain '')" Dim memberFilter_UD3 As String = "Cb#CONCUBE:U3#PCHEAD.Descendants.Where(Text2 <> '')"Dim UD3List As List(Of Memberinfo) = api.Members.GetMembersUsingFilter(api.Pov.UD3Dim.DimPk,memberFilter_UD3)   'api.logmessage("UD3List", String.Join(vbnewline, memberFilter_UD3.Select(Function(x) x.GetType.FullName))) BRAPI.ErrorLog.LogMessage(si,"1_Target_ " & UD3List)   For each UD3 as Memberinfo in UD3List etc. etc. BRAPI.ErrorLog.LogMessage(si,"Test " & UD3.NameAndDescription)' &" " & UD3.Properties.GetUDProperties.Text2.GetValue())