Exporting Account Type
I'm currently trying to export the account dimension members and their properties through a csv file. I can get all the properties necessary, but I can't get the "Account Type" property through the extender rule. I'm currently using Account_Type= Brapi.Finance.Members.GetMemberInfo(si,dimTypeId,stkItem.Name,True,Nothing,MemberDisplay).Member.GetType.FullName , to get the account type in columns but it isn't returning the correct account type of the member and instead returning " OneStream.Shared.Common.Member " in the columns.6Views0likes1CommentReturning a success or failure message from DM via REST API
Hi all, I'm triggering a DM job using the REST API. The job is running a business rule. I handle errors in the BR but I need to actually return the success or failure as a response to the postman request. Right now, I get a success message no matter what happens in the BR. Thanks in advance!3Views0likes0CommentsSupplied 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?Solved72Views0likes3CommentsWhat 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 Next435Views0likes6CommentsFileShare 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 Sub40Views0likes1Comment