OneStream Platform Forums

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 We are getting the following error message on a new data source load' Detail Cache summarization did not produce any Summary Data Rows.'Can anyone share any light on what this might indicate?

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!

Hello, Is there a way to export multiple pages of the drill down in a single csv?  It seems like each page of the drilldown must be exported separately, which is very time consuming.  Thanks!

Hello - Wondering if anyone has come up with a efficient way of providing visibility for end users into the calculation logic and/or equations that are being used by dimension members. For example: End user pulls up a Cube View The Cube View is a mix of base members, calculated members, and dynamic calc accounts How can they see the equations impacting the various members? I'm hoping there is a better way than manually documenting it during system set-up and updating with each change. Any input appreciated.   Thanks,Bil

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?

I am getting an error while trying to access the file from the BR . The process cannot access the file '\\XXXXXX.file.core.windows.net\onestreamshareprd1\FileShare\Applications\XXXXXXX\Groups\Everyone\XXXXXX\File_XXXXX.zip' because it is being used by another process.

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

When trying to format the report and create a space between sections users are seeing random numbers pulled from the formula. The XFGetCell is referencing blank cells, but somehow is still pulling in a number when trying to drag down formulas. This causes users to have clear out the formulas when copying down the xfgetcell. I would expect this to give an error, but not a number. Anyone else see this and know of a way to get around it? Added a screen shot below for reference.    

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

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!

Hello  I have a requirement where i need to join the framework database and application database in the same dashboard . We have created data adapter individually one for framework and one for Application databases but that is not solving our purpose.  

Hi,  I have an cube view that is used by many entities. There is one row/account in this CV where we would like data to be shown only if the user is in a specific workflow entity. If not in that entity the row should be blank.  I know I can build a new cube view only for this specific entity but would rather use the overwrite function for this specific row.   

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    

is it possible to get column E to show YTD values? if i change the view to YTD everything else changes to YTD. i tried using the getcelldata(#2022M1+2022M2 ......#2022M12) it works if i stop at #2022M6 but when i add the future months everything goes blank.is it possibly to get YTD and MTD numbers in a QV?   

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 guys! I would like some guidance on how to pull all children at the same level in a Quickview. Thank you.  Oliveira, Vanessa

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 all, very new to OS and am having some issues using the XFGetCellUsingScript() function and UsingScript functions generally. Specifically, the GetCellUsingScript function can't seem to handle more than 2 POV changes to an original POV but using the XFGetCellUsingScriptEx() which has 16 POV arguments doesn't seem to work at all, it just returns #VALUEs. The XFGetCell function is comically long and inflexible (doesn't work with any arrays or text joining functions that I've tried) so [...]UsingScript[...] functions seem like a much cleaner way to go but I'm having serious difficulty learning to use any of them because the documentation for the add-in functions isn't very good. The descriptions of the functions under the Retrieve Functions section is not complete and it doesn't define the function arguments or give examples. Any thoughts, best practices or helpful blog posts you could share would be much appreciated.