OneStream’s Network of Experts

Connect. Share. Discover.

Announcement

ABC

Recent 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?
matthewsb419
New Contributor
9 hours ago
annotations
Reports
11Views
0likes
1Comment
Derivative rule based on time
Hello all, I am looking to spread budget data across 12 months evenly, however my source is only designated one time. I am looking to split time into all twelve months of the year and divide the amounts accordingly. Is this possible?
Jacob
New Contributor
12 hours ago
Data Sources
Import
Transformation
1KViews
0likes
2Comments
Smart Integration Connector remote query failed.
I am trying to query the data from the client source database through a Data Adapter, but it is returning this error: Is this an issue with our setup on the OneStream end or something with the database configuration on the client side?
danszczepanski
New Contributor III
14 hours ago
Data Integration
10Views
0likes
1Comment
Customize scenario visibility for some entities
Can someone help with creating a BR to customize scenario visibility for some entities using .NET ? I have a list of entities that don't share a common parent and want them to not be visible in the budget scenario.
jaideepk
Visitor
15 hours ago
Extenders
Finance
XFBR
11Views
0likes
2Comments
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?
sylvainremy
New Contributor II
17 hours ago
BI Viewer
Dashboards
18Views
0likes
0Comments
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
BenEppel
New Contributor III
22 hours ago
Extenders
10Views
0likes
1Comment
Member Description using FdxExecuteDataUnitTimePivot
Hi. I am using the FdxExecuteDataUnitTimePivot to pull data through a Data Adapter. My Setup now is only pulling the Names of the dimension members. Is there any way to get the descriptions as well? My Code: Public Function ToNexusSalaryBridge(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardDataSetArgs) Dim sScenario As String = args.NameValuePairs.XFGetValue("myScenario", String.Empty) Dim sYear As String = args.NameValuePairs.XFGetValue("myTime", String.Empty) Dim sWorkspaceID As Guid = BRApi.Dashboards.Workspaces.GetWorkspaceIDFromName(si, False, "Default") Dim sRootEntity As String = "MyRootEntity" Dim cubeName As String = "Test" '# data unit dims Dim consName As String = "Aggregated" 'member name only, no dim token Dim scenarioTypeId As Integer = ScenarioType.Budget.Id Dim viewName As String = "Periodic" 'member name only, no dim token Dim entityDimName As String = "E_ELTBU" Dim entityMemFilter As String = $"E#[{sRootEntity}].Base" Dim scenarioDimName As String = "S_ReportingScenarios" Dim scenarioMemFilter As String = $"S#[{sScenario}]" Dim timeMemFilter As String = $"T#{sYear}.Base" Dim suppressNoData As Boolean = True Dim parallelQueryCount As Integer = 8 Dim logStatistics As Boolean = False ' '# SQL like filter on output table Dim filter As String = "Flow='DKK_Input' and UD2='member1' and IC='None' and UD6='None' and UD7='None' and UD8='None'" Dim Dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnitTimePivot(si, _ cubeName, _ entityMemFilter, consName, _ scenarioTypeId, scenarioMemFilter, _ timeMemFilter, viewName, _ suppressNoData, False, filter, parallelQueryCount, logStatistics) If Dt IsNot Nothing Then Return Dt End If End Function
Solved
josrisager
New Contributor
2 days ago
Dashboards
Extenders
21Views
1like
1Comment
How do I return a range of Members?
We have a large flat hierarchy, members starting with Px_1000 to Px_9999. For example, P1_1000_27 Project 1, P5_1001 Project Yellow.... P7_9999 Project Bob. The numbers are unique (no two same number). We want a report that allows users to enter a "From" - "To" to pull back members in that range. For instance, only pull back members in the range "From" 500 To "532". Have an XFBR where I'm parsing the string, that's working, looping through and but only returning the number. The issue is that I need the entire string and description of the member. That's where I'm stuck. If anyone has done this before, would very much like know how you coded the XFBR. Thank you!
Solved
jayaleck
New Contributor II
2 days ago
Cube View
Dashboards
Parameters
Reports
45Views
0likes
4Comments
Public Overloads Function GetCalculatedFxRate... is obsolete
Is someone able to assist me with an alternative method for GetCalculatedFxRate on line 14 of the code below? We just upgraded to 8.5.1 and this is no longer being supported. In 8.2.3 it was still working. This is a parser business rule that is being applied to a data source and calculation happening when data is being imported. '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 'Purpose: Get Translation rate for To/From currencies on current record. ' Store translation rate in global variable to use with subsequent records for performance improvements. '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Dim time As String = api.CurrentDataClusterKey.TimeName 'Get current time. Dim currencyRate As Decimal = globals.GetDecimalValue(fromCurrency & "-" & toCurrency & "-" & time) 'Check Global variable for current translation rate. If Not currencyRate = Nothing Then 'If Globals is populated, return rate from global variable. Return currencyRate Else 'Else, get translation rate from Database and store in Global variable. Dim rateType As FxRateType = BRApi.Finance.Scenario.GetFxRateTypeForRevenueExpense(si, api.CurrentDataClusterKey.ScenarioID) 'Get Revenue rate type for current scenario Dim defaultCurrencyId As Integer = BRApi.Finance.Cubes.GetDefaultCurrencyId(si, 0) 'Get Cube's default currency ID Dim objActFxRate As New FxRatePkUsingNames(rateType.ToString, time, fromCurrency, toCurrency) 'Get rate information for current translation. Dim rate As Decimal = BRApi.Finance.Data.GetCalculatedFxRate(si, defaultCurrencyID, objActFxRate) 'Get translation Amount Globals.SetDecimalValue(fromCurrency & "-" & toCurrency & "-" & time, rate) 'Store current translation amount in global variable. Return rate 'Return Translation Rate. End If Thank you, Denise
Solved
denisefockler
New Contributor III
2 days ago
Parsing
41Views
0likes
5Comments
Get member description in user's culture code using excel add-in
Hi all, Do you know how to get the member description in a scpecific language using the Excell add-in? I suppose that it can be done using the "XFGetMemberProperty" but I can't find an example. Thank you. XFGetMemberProperty This function retrieves any Dimension Member property from the Member Properties tab in the Dimension Library. Note there are no spaces used when defining property name. XFGetMemberProperty(“DimTypeName”,“MemberName or Script”,“PropertyName”, “VaryByCubeTypeName”,“VaryByScenarioTypeName”,“VaryByTimeName”) As a reference when using BR: Get member description in user's culture code | OneStream Community Best regards, Carlos
Solved
CarlosAlvear
Contributor
2 days ago
Excel Add In
Reports
25Views
0likes
4Comments

Getting Started

Learn more about the OneStream Community with the links below.

Community Code of Conduct

Terms of Service

Featured Content