Discuss the features and functionality of OneStream.
Recently active
Is there a good resource that people use to explain what is contained in each version of OneStream. I read the release notes but I am looking for perhaps a good blog to help explain these features in detail. I typically meet with our Finance users before we upgrade to let them know any features that may be useful to them.
We are trying to load txt file to custom table using LoadCustomTableUsingDelimitedFile but when it runs we receive a "Data load file is invalid or missing" error. The file is manually selected from a folder. The file is correct, the number of fields in the file and in the table match, the values and the field type match and the field separator is correct. We are uploading the file from a Dashboard button component which calls a Dashboard extender BR. This is the BR code: Dim filePath As String = args.NameValuePairs.XFGetValue("FilePath") Dim tableName As String = args.NameValuePairs.XFGetValue("TableName") Dim loadResults As TableRangeContent Dim fieldTokens As New List(Of String) fieldtokens.add("field1") fieldtokens.add("field2") ... fieldtokens.add("fieldn") loadResults = BRApi.Utilities.LoadCustomTableUsingDelimitedFile(si, _ SourceDataOriginTypes.FromFileUpload, filepath, Nothing, ";", _ "Application", tableName, "Replace", fieldtokens, False)
Hi all, I am working with navigation links in my cube view. However, when I open the 'linked cube view' through my 'main cube view,' I get the member filter to show in the title of the dialogue box that opened. These are the bound parameters that I used in the 'main cube view.' Is there a way to remove the member filter from the title bar in the dialogue box? I've included below what I mean with the title bar and my issue. I appreciate any help you can provide. Kind regards, Floris van der Poel
Hi, Do we get to see the member updates made in Dimension Library in the Task Activity? I don't see a Task Type related to this in the Task Activity. It gets recorded when I use an XML file to update the dimensions, but not the manual changes made there. Is there any setting that needs to be made to get this information in Task Activity or should I be checking somewhere else? Please let me know. Thanks in advance, AK
Is there a way to get the list of components on the calling dashboard on load? Trying to use:args.ComponentInfo.Component.Name results in nothing, even though I have multiple components on my dashboard. I want to get a list of all components, particularly a label or 2, and based upon user settings/access/Text fields, set labels
When a translation or a consolidation is run, the AdjInput entries are rolled into the AdjConsolidated member. This rollup occurs as the data is moved along the Consolidation Dimension. Question Credit: Peter Fugere 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
Dear Community, There is a possiblity to retrieve parameters currently available in a dashboard using for instance : Dim str_myParam As String = args.SelectionChangedTaskInfo.CustomSubstVars.XFGetValue("MyParameter") However, this means that we need to know the names of the CustomSubstVars currently in the dashboard (in that case, I need to know that the parameter MyParameter is indeed available in the dashboard). In my use case the user can open several cube view hence the parameters will change from one Cube View to another. Is there a way to list all current CustomSubstVars available in the dashboard ? Regards,
I have created a Dashboard Dara Set BR and I am attached in the data adapter. When I am trying to execute the rule am getting 0 data. See below the entity is always passing as None but when I add a log message in the code the variable is passing based on the selection and printing the correct entity. in My CV i also have the FDXentity parameter. Any Idea why it is happening ? Original Query {FDX_CUbeView}{ExtractCubeViewTimePivot}{cvNameToExtract=Data,entityDimName=E#|!FDXEntity!|} Substituted Query {FDX_CUbeView}{ExtractCubeViewTimePivot}{cvNameToExtract=Data,entityDimName=E#None} Thanks Krishna
Happy New Year Everyone! I am hoping someone has an example of how to use the formatting rule in OneStream Dashboard Reporting to change the style of any row in table oContent where label13 (field OFCvRAVAR in my dataset) is not zero. I think it's also possible via a script ... Have been looking in Golfstream for an example, but no luck. Thanks!
Hi All, We are looking for a way to put a currency override on movement flow member (ex. dividends, redemptions, etc...). The current override logic which was provided was OneStream is leveraging the flow dimension to conduct the currency overrides so I am having trouble in determine the best way to work around this. If anyone has come across this before please let me know. I'm looking forward to hearing from you. Cheers!
I can drill from the Journal report Question Credit: Peter Fugere 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
If I like to migrate a HFM rules file, is there an equivalent to the HS.con function?
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
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
Is there an easy way to traverse with in a cube view like ctrl home, ctrl end, ctrl + up arrow, ctrl + down arrow in a Data explorer view. Need help.
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 guys! I would like some guidance on how to pull all children at the same level in a Quickview. Thank you. Oliveira, Vanessa
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
You cannot use OneStream to directly report on SAP data 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 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
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.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.