Announcement
ABCRecent Activity
V#VarianceExplanation - Best Ways to Use
Hi, I'm trying to understand the best way to add annotations and comments in OneStream to explain variances. Last week at splash I was advised to use V#Annotation or V#VarianceExplanation. But what I'm confused about is how do you actually get it connected to the calculated variance (red box), versus only being able to connect it so the actual reported number (yellow box). Right now I'm using a get data formula in my quick view to calculate the variance (GetDataCell(S#Actual-S#AOP):Name(Variance)). What are other people doing when trying to provide commentary on variances? Whats the best way to use this view?
BI Viewer component and OneStream 9.0.0
Hi all, We upgraded one of our OS instances to 9.0.0 After a first look, it seems BI Viewer does not work anymore from Desktop app, but charts are showing from Modern Browser interface, any idea? Can't find a clue on Know Issues. On Desktop app, only the layout shows, no content: Same Dashboard from Modern Experience shows fine (I blurred data here) Any advice?Clearing Files in User Temp Folder as Non Admin
Good afternoon, Does anybody know which security setting would allow a user to delete files from their Temp Folder? I have tried changing the below System and Application Security Roles with no luck. Each time i get an error saying the User does not have permission to write to that folder. Private Sub ClearUserTempFolder(ByVal si As SessionInfo) Try Dim userName As String = si.UserName.Replace(" ", "") Dim location As FileSystemLocation = FileSystemLocation.ApplicationDatabase Dim folderPath As String = $"Internal/Users/{userName}/Temp" Dim fileTypeFilter As XFFileType = XFFileType.All Dim contentFileExtensionFilters As List(Of String) = Nothing ' Get list of files Dim objList As List(Of XFFileInfoEX) = BRApi.FileSystem.GetFilesInFolder(si, location, folderPath, fileTypeFilter, contentFileExtensionFilters) If objList IsNot Nothing AndAlso objList.Count > 0 Then For Each file In objList Try BRApi.FileSystem.DeleteFile(si, location, file.XFFileInfo.FullName) BRApi.ErrorLog.LogMessage(si, $"Deleted file: {file.XFFileInfo.FullName}") Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try Next Else BRApi.ErrorLog.LogMessage(si, $"No files to delete in {folderPath}") End If Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try End Sub
FileShare Harvest Folder view and deletion
Hello All, Our initial setup had everything copying data files to Application/Batch/Harvest folder. There has been multiple years of files stored in this location making it unable to open. I am trying to create something to pull the files and if folders are created to delete the stored files. I am uable to open the path and the clean up business rule fails to run due to the size. I spoke with some developers at Nashville Splash and am reaching out on here as well.
New Episode of The OneStream Podcast now Available!
On the latest episode of The OneStream Podcast, Peter Fugere is joined by David Lickwar and Nick Bollinger to discuss the OneStream Certified Specialist (OCS) – Reports and Dashboards exam. Learn how this certification, and all the OneStream exams, provide OneStream users a way to demonstrate the highest levels of technical competency, productivity, and industry recognition.
Quick OneStream Rule Behavior Check – O#Top Returning O#Import Value?
Hi Team, Quick question — has anyone else encountered this behavior in rule logic? I’m working with a standard api.Data.GetDataCell(...) call that includes the O#Top member in the POV. Here's the line I'm using: Dim baseValue As Decimal = api.Data.GetDataCell("C#Local:A#1104000000:F#CLO:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:U7#Top:U8#Top").CellAmount. BRApi.ErrorLog.LogMessage(si, baseValue) On the Cube View, this correctly returns -501 under O#Top. However, when I log the value in the rule using: - It outputs the value from O#Import, not the aggregated O#Top result I expected. This rule worked flawlessly for 3 years until now on Version 7.4. As a workaround, I manually aggregated the base origin members in the rule, which produced the expected result. However, I’m still unclear why O#Top didn’t aggregate properly in this case, given that it functions as expected in Cube Views. I checked and compared with several other apps, including Golfstream, in which this rule worked. Environment: This behavior was observed in 7.4. After upgrading to version 8.4, the issue was resolved. I’d like to understand what may have caused this inconsistency, particularly: Could a bug affect the Origin dimension, which was resolved in 8.4? Has anyone experienced this behavior before? Appreciate any insights or similar experiences the community can share!
Return to Admin's Paradise Replay now Available!
Tech Talks: Return to Admin's Paradise is now available for replay. Watch as Teresa Kress highlights and demonstrates OneStream solutions available for administrators that will increase productivity and efficiency and make your workflow a paradise! This replay is available on Navigator as part of your Passport subscription.
Dynamic Calc UD8 Dimension to Filter Account Dimension?
Is it possible to create a dynamic calc UD8 dimension, that then filters down the members on the Account dimension at a base level? (and if so, how?) For example, within the Account dimension, I have Member A, Member B, Member C and Member D. Can I create UD8 dimensions of "Group 1" and "Group 2" where if Group 1 is selected, it filters down Account to only show Member A and Member B. And if I choose Group 2, it filters Account to only include Member C and Member D. I know this can be accomplished with an alternate hierarchy on the Account dimension but just checking to see if this can be done alternatively. Thanks in advance!
