Recent Discussions
Subtle bug in Example for Dynamic Dimensions
In the example code for the Dynamic Dimension Service there appears to be a subtle bug which will affect refresh of the dimensions. ReadDynamicDimensionInfo(...) returns DateTime.Now: ' This api method will build the required object, straight from an SQL query. Return api.ReadDynamicDimensionInfo(si, args, DateTime.Now, numSecondsBeforeCheckTS, _ dbConn, sql.ToString, Nothing, Nothing, _ "Name", "Description", "UniqueID", "Name", "Parent", "ParentID", "Parent", "AggWeight", True) BUT ReadDynamicDimensionContentTimestamp sets the Timestamp as DateTime.UTCNow: 'Refresh once per minute (note: frequent refreshes such As one minute could degrade performance). Dim utcNow As DateTime = DateTime.UtcNow Return New DateTime(utcNow.Year, utcNow.Month, utcNow.Day, utcNow.Hour, utcNow.Minute, 0, 0, DateTimeKind.Utc) This will matter if your refresh period is < 13(?) hours AND if your TimeZone is ahead of UTC...... It's an easy fix though! Steve
Purpose of itemName in Assembly Service factories?
Hi all I'm trying to understand the purpose of the string 'itemName' variable that is available inside the assembly service factories. Does anyone know the intended purpose of the 'itemName'? And does anyone have some best practice guidelines or examples of this variable in use? Thank you very much everyone! Thor
What 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!
is there a way to check the total value on each account in the staging?
Hi Community, We have a requirement to bypass lines from the source data for each account if the total equals to zero, regardless of the UD1 value. For example if these two lines are in the source data: Account 1, UD1_1, -100 Account 1, UD1_2, 100 we want to bypass account 1. Is there a way to achieve this result? in our case this is happening because we are adding UD1 in the source system and it's triggering a lot of unused accounts to now appear on our staging table because of the different UD1 members.
Periodic data copy from YTD scenario
i have blow code to copy the periodic values from YTD scenario but it didn't work Dim sourceBuffer1a As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(S#" & sSourceForecast & ",V#PERIODIC,A#Top.Base,O#AdjInput)", DataApiScriptMethodType.Calculate, False, destination) Dim sourceBuffer1b As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(S#" & sSourceForecast & ",V#PERIODIC,A#Top.Base,O#Forms)", DataApiScriptMethodType.Calculate, False, destination) Dim sourceBuffer1 As DataBuffer = sourceBuffer1a + sourceBuffer1b If (Not sourceBuffer1 Is Nothing) Then Dim resultBuffer1 As New DataBuffer() For Each sourceCell As DataBufferCell In sourceBuffer1.DataBufferCells.Values Dim resultCell As New DataBufferCell(sourceCell) If sourceCell.CellStatus.StorageType=DataCellStorageType.Input _ Or sourceCell.CellStatus.StorageType=DataCellStorageType.Journals _ Or sourceCell.CellStatus.StorageType=DataCellStorageType.DurableCalculation Then resultCell.CellAmount = sourceCell.CellAmount resultBuffer1.SetCell(si, resultCell,True) End If Next api.Data.SetDataBuffer(resultBuffer1, destination,,,,,,,,,,,,,True) End If is there any other code suggestion?
Determine 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 Next
