I have 2 cubes where business wants to transfer the data from 1st cube(Salarycube) to 2nd cube(ExpensePlan cube) for a particular Month(user passed parameter) and its further future months in a particular year(user passed parameter).
Application has an existing TI process pCTSalaryToExpensePlan where in its prolog, Month subset is being created:
Code: Select all
vDimName = 'Month';
ExecuteProcess('Bedrock.Dim.Sub.Create.Leaf',
'pDimension', vDimName, 'pSubset', cSubsetName, 'pExclusions', ''
);
ViewSubsetAssign (cCubeName, cViewName, vDimName, cSubsetName );
At last, it is doing a zeroOut of the target:
Code: Select all
#================
#ZeroOut the Target
If(pDivision @= 'All');
ExecuteProcess (
'Bedrock.Cube.Data.ZeroOut',
'pCube', cTargetCubeName,
'pDelimDim', ';',
'pDelimElem', '|',
'pFilter', 'Scenario|' | pScenario | ';Year|' | pYear| ';Version|' | pVersion| ';ExpenseAccounts|600310|600300|604100|600320|610120|610170|610300|610310|610320|610200|610240|610280',
'pDebug', 0 );
Else;
ExecuteProcess (
'Bedrock.Cube.Data.ZeroOut',
'pCube', cTargetCubeName,
'pDelimDim', ';',
'pDelimElem', '|',
'pFilter', 'Scenario|' | pScenario | ';Year|' | pYear| ';Version|' | pVersion| ';Division|' | pDivision | ;ExpenseAccounts|600310|600300|604100|600320|610120|610170|610300|610310|610320|610200|610240|610280',
'pDebug', 0 );
EndIf
Code: Select all
CellPutn(vValue,'ExpensePlan',vScenario,vHRVersion,vYear,vCurrency,vDivision,vProject,vMonth,vHRAccounts);
1. Is carrying out a zeroOut of the target necessary? If we directly write into a new intersection value, will it not overwrite with each execution of the ti process?
2. How do i approach to implement the Month and Future months data transfer functionality- where business wants to transfer the data from 1st cube(Salarycube) to 2nd cube(ExpensePlan cube) for a particular Month(user passed parameter) and its further future months in a particular year(user passed parameter).?
Do i have to create a new subset for dimension Month where it has to store passed Month and its future months - how should i go forward?
A humble request for your help to a newbie. Please let me know your pointers and suggestions.