TI process skipping data section

Turbo Integrator

TI process skipping data section

Posted by Helen on 10-May-22 at 8:36 pm
Hi all. I’m brand new here so please accept my apologies if I don’t follow the expected protocols.

I’ve just created a new process to transfer data from one cube to another and it seems to be completely skipping the data section. I’ve never had this before. I’m sure it’s probably something really obvious but I just can’t get my head around it.

I’ve added ASCIIOutput procedures to the prolog, data and epilog sections to see if I can figure out what it’s doing. The prolog and epilog logs are generated but noting is even generated for the data section.

I’ve attached the procedure in a txt file.

p.s. I’d usually use rules for transferring data rather than a process but in this instance I couldn’t get it working with the mapping involved which uses a a matrix. Maybe I should just concentrate on getting that route working ?

Thanks for your help.
BFGLDataToPL_Report.txt 3 KB Text File - Click to view

Copy Download Link

#Section Prolog # ----------------------------------------- # BF.ActualDeliveredToKeySupplier # Author: Helen Heaton # # 1. Generates Specified Profit and Loss report from a combination of nominal code and cost centre # # Source: BF.GLData # Target: BF.ProfitLossReport # Parameters: # -----------------------------------------#****Begin: Generated Statements*** #****End: Generated Statements**** #log file variables nStart = now(); sStamp = getProcessName() | timst(nStart, '-\y\m\d-\h\i\s'); nDataRecs = 0; #nMinute = 1 / 24 / 60; fLog = 's:\prod\finance\logs\' | sStamp | '-Prolog.log'; sTime = timst(now(), '\d'|'-'|'\m'|'-'|'\y \h'|':'|'\i'|':'|'\s'); ASCIIOutput( fLog, 'Process started at '|sTime ); #Define source view cbSource = 'BF.GLData'; sourceview = sStamp; ExecuteProcess ('_bsl.CreateView' ,'CubeName', cbSource ,'Viewname', sourceview ,'Dim6Sub', 'All sub-analysis' ,'pDebug', 0 ); ViewSubsetAssign(cbSource,SourceView,'vActive','DataVersions'); ViewSubsetAssign(cbSource,SourceView,'tPeriods','@0'); ViewSubsetAssign(cbSource,SourceView,'BF.Nominals','@0'); ViewSubsetAssign(cbSource,SourceView,'BF.CostCentres','@0'); DataSourceType = 'VIEW'; DataSourceNameForServer = cbSource; DataSourceCubeView = sourceview; #Clear out target cube cbTarget = 'BF.PL_Report'; targetview = sStamp; ExecuteProcess ('_bsl.CreateView' ,'CubeName', cbTarget ,'Viewname', targetview ,'pDebug', 0 ); #ViewSubsetAssign(cbTarget,TargetView,'vActive','DataVersions'); #ViewSubsetAssign(cbTarget,TargetView,'tPeriods','@0'); ViewZeroOut(cbTarget, targetview); #Section Metadata #****Begin: Generated Statements*** #****End: Generated Statements**** #Section Data #****Begin: Generated Statements*** #****End: Generated Statements**** #Log File fLog = 's:\prod\finance\logs\' | sStamp | '-Data.log'; if (nDataRecs = 0); sTime = timst(now(), '\d'|'-'|'\m'|'-'|'\y \h'|':'|'\i'|':'|'\s'); ASCIIOutput( fLog, 'Data Processing started at '|sTime ); endif; nDataRecs = nDataRecs + 1; #Data Prep ASCIIOutput(fLog, numberToString(nDataRecs), 'Source data:', vActive, tYears, tperiods, vNom, vCC, vSA, NumberToString(Value)); CCGroup = ATTRS( 'BF.CostCentres', vCC, 'CCSubGroup' ); vPL = CellGetS('BF.PLMapping', vNom, CCGroup, 'Mapping' ); ASCIIOutput(fLog, numberToString(nDataRecs), 'Generated variables:', CCGroup, vPL); #Data Transfer ASCIIOutput(fLog, numberToString(nDataRecs), 'Output data:', vActive, tYears, tperiods, vPL, NumberToString(Value)); CellPutN(Value, cbTarget, vActive, tYears, tPeriods, vNom, vCC); #Section Epilog #****Begin: Generated Statements*** #****End: Generated Statements**** ViewDestroy( cbSource, sourceview ); ViewDestroy( cbTarget, targetview ); fLog = 's:\prod\finance\logs\' | sStamp | '-Epilog.log'; sTime = timst(now(), '\d'|'-'|'\m'|'-'|'\y \h'|':'|'\i'|':'|'\s'); ASCIIOutput( fLog, 'Processing completed at '|sTime );

Expand
Helen replied 10 months, 2 weeks ago 3 Members · 4 Replies
4 Replies

Vlad

Member
11-May-22 at 2:54 am

0 Diamonds

2 Gold

260 Experience

Scout

Hi @helen-heaton

Did you check if the SourceView contains any data? Does it include any rule calculated or consolidation elements?
John

Administrator
11-May-22 at 2:27 pm

2 Diamonds

14 Gold

1,970 Experience

Hiker

Just seconding @teamone‘s suggestion. You need to make sure that the source view actually contains data. So open it, suppress zeros and move everything except one dimension into rows. then select the lowest level of each dimension for all dimensions. You should have editable data there. If it’s not editable at the base level, you probably have rules that are calculating all the data in the cube. In this case please see this post https://exploringtm1.com/viewextractskiprulevaluesset/ that will explain how to extract rule calculated values. Cheers, John
- Helen
  
  Member
  13-May-22 at 9:00 pm
  
  0 Diamonds
  
  2 Gold
  
  160 Experience
  
  Scout
  
  Thanks both. I suspect the source data is rule based so I’ll check out that link.
- Helen
  
  Member
  13-May-22 at 9:29 pm
  
  0 Diamonds
  
  2 Gold
  
  160 Experience
  
  Scout
  
  Perfect!!!
  
  I just needed to add:
  
  ViewExtractSkipCalcsSet (cbSource , SourceView , 0);
  ViewExtractSkipRuleValuesSet (cbSource , SourceView , 0);
  
  to my source definition.
  
  Thank you so much guys!

TI process skipping data section

Vlad

John

Helen

Helen