FdxExecuteStageTargetTimePivot
- 2 years ago
Hey,
You can use,
Dim WFProfileName As String = BRApi.Workflow.Metadata.GetProfile(si,si.WorkflowClusterPk.ProfileKey).Name
Dim WFScenarioName As String = ScenarioDimHelper.GetNameFromId(si, si.WorkflowClusterPk.ScenarioKey)
Dim WFTimeName As String = BRApi.Finance.Time.GetNameFromId(si, si.WorkflowClusterPk.TimeKey)Dim ParentWFPRofile As String = BRApi.Workflow.Metadata.GetParent(si,WFProfileName).Name
Dim dt As datatable = Brapi.Import.Data.FdxExecuteStageTargetTimePivot(si,ParentWFProfile,WFScenarioName,WFTimeName,WFTimeName,True,True,"AcT= 'TestAcc' and Si = '"& si.UserName &"'",1000,True)
For Each Dc As DataColumn In dt.Columns
Brapi.ErrorLog.LogMessage(si,"NIKCLMN: " & dc.ColumnName)
NextColumnnames in the table to apply filter, Is tested this for 1 time period, Amount column will be with timeperiod as it is picvoted, So if we use
Brapi.Import.Data.FdxExecuteStageTargetTimePivot(si,ParentWFProfile,WFScenarioName,WFTimeName,WFTimeName,True,True,"AcT= 'TestAcc' and Si = '"& si.UserName &"'",1000,True) 'Use generic time columnnames boolean flag'Rt,Si,Lb,Tv,EtT,PrT,CnT,SnT,VwT,AcT,FwT,OgT,IcT,U1T,U2T,U3T,U4T,U5T,U6T,U7T,U8T,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A121,A14,A15,A16,A17,A18,A19,A20,Time1
if we use,
Brapi.Import.Data.FdxExecuteStageTargetTimePivot(si,ParentWFProfile,WFScenarioName,WFTimeName,WFTimeName,True,False,"AcT= 'TestAcc' and Si = '"& si.UserName &"'",1000,True) 'Use generic time columnnames boolean flag
'Rt,Si,Lb,Tv,EtT,PrT,CnT,SnT,VwT,AcT,FwT,OgT,IcT,U1T,U2T,U3T,U4T,U5T,U6T,U7T,U8T,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A121,A14,A15,A16,A17,A18,A19,A20,T2023M1