Supplied parameter tied to Bound List not returning value
Hi community, I have an issue where i have a member list tied to a bound list. The bound list uses a SQL query to get the top member of a given dimension. I have this bound list tied to a supplied parameter that I have attached to a dashboard. The issue is that when I run the dashboard, it is not triggering the bound list, even though i am using the supplied parameter. If I remove the supplied parameter and run the dashboard, it prompts me with the bound list parameter showing the value i want to return, and thereafter, when i put the supplied parameter back it works. It seems like the system needs to trigger the bound list first, but I haven't found a way to do so yet. Any thoughts?Solved70Views0likes3CommentsWhat does api.Data.GetRelationshipChanges(dimensionName, startDate, endDate) return?
Hello, I already have a data file for cost centers and their Default values, but now I need to include the before and after changed values to the cost center member. I found this code: Function GetRelationshipChangesForTimeSpan(ByVal api As Api, ByVal dimensionName As String, ByVal startDate As DateTime, ByVal endDate As DateTime) As List(Of RelationshipChange) ' Initialize a list to store relationship changes Dim relationshipChanges As New List(Of RelationshipChange) ' Use the API to retrieve relationship changes relationshipChanges = api.Data.GetRelationshipChanges(dimensionName, startDate, endDate) ' Return the list of changes Return relationshipChanges End Function How can I tell what data it's actually returning, what columns? Is there a better way to do this? Any help is greatly appreciated! Thanks!38Views0likes2CommentsDetermine Workflow Profile Security Access in a Dashboard Extender Rule
I'm using the following code snippet in a Dashboard Extender Rule to loop through the list a of Workflow Profiles. However, the code fails, if the user does not have security access to a particular Workflow Profile, returned in the list. Is there a way I can get the list returned with security access applied, so the list only returns Workflow Profiles that the user has access to? Dim profile As String = "text1 tag to match" Dim wfProfileName As String = "" Dim cubeRootInfo As WorkflowCubeRootInfo = BRApi.Workflow.Metadata.GetCubeRootInfo(si, si.WorkflowClusterPk.ProfileKey, True) cubeRootCluster As New WorkflowUnitClusterPk(si.WorkflowClusterPk) cubeRootCluster.ProfileKey = cubeRootInfo.CubeRootProfile.ProfileKey Dim profileInfos As List(Of WorkflowProfileInfo) = BRApi.Workflow.Metadata.GetRelatives(si, cubeRootCluster, WorkflowProfileRelativeTypes.Descendants, WorkflowProfileTypes.BaseAndParentInputProfiles) For Each profileInfo As WorkflowProfileInfo In profileInfos Dim wfScenarioTypeID As Integer = BRApi.Workflow.General.GetScenarioTypeId(si, cubeRootCluster) If profile = profileInfo.GetAttributeValue(WfScenarioTypeID,sharedconstants.WorkflowProfileAttributeIndexes.Text1) wfProfileName = profileInfo.ToString ' brapi.ErrorLog.LogMessage(si," profileInfo.Name = " & profileInfo.ToString & " : Text1 = " & profileInfo.GetAttributeValue(WfScenarioTypeID,sharedconstants.WorkflowProfileAttributeIndexes.Text1)) End If Next434Views0likes6CommentsFileShare 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.Solved68Views1like3CommentsClearing 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 Sub39Views0likes1CommentMember 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 FunctionSolved43Views1like1Comment