on 09-19-2014 3:03 PM
is it possible to aggregate results data in chain /CPMB/EXPORT_TD_TO_FILE?
One of my packages uses this chain - it exports several fields from BPC model. Model has 8 dimension, but only 4 are used in export process - it causes many combinations are repeated in file.
Off course sum of values is correct, but it would be better to have a choise whether to aggregate data or not.
Hi Michal,
You have 4 unused dimensions - do you have a root parent member for each unused dimension?
If yes - just export the root members for unused dimensions...
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Vadim,
Weve tried to use some aggregation levels but the problem concerns bpc behaviour when you want use conversion file.
Bpc do the conversion on exported data, I think as the last step. If there is more than one internal mapped to one external, more than one line can have same attribute value.
We thought about creating hierarchy to replace conversion file, but its impossible because externals have same value as base members in dimension... one of solution could be routine I believe...
Hi Michal,
I just tested custom process chain approach - first run script then export to file (with the same scope):
The new chain was created based on the copy of standard chain
The advanced script for the package was:
PROMPT(MEASURELIST,%MEASURES%,"Please select measures")
PROMPT(SELECTINPUT,,,,"%DIMS%")
PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)
PROMPT(OUTFILE,,"Please enter an output file",Data files (*.txt)|*.txt|All files(*.*)|*.*)
PROMPT(RADIOBUTTON,%ADDITIONINFO%,"Add other information(Environment,Model,User,Time)?",1,{"Yes","No"},{"1","0"})
INFO(%DIMVALUE%,E=24)
INFO(%TEMPNO1%,%INCREASENO%)
INFO(%TEMPNO2%,%INCREASENO%)
TASK(/CPMB/SCRIPT_LOGIC,SUSER,%USER%)
TASK(/CPMB/SCRIPT_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/SCRIPT_LOGIC,SAPP,%APP%)
TASK(/CPMB/SCRIPT_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/SCRIPT_LOGIC,LOGICFILENAME,PREPEXPORT.LGF)
TASK(/CPMB/APPL_TD_SOURCE,SELECTION,%SELECTION%)
TASK(/CPMB/APPL_TD_SOURCE,DIMENSIONVALUE,%DIMVALUE%)
TASK(/CPMB/APPL_TD_SOURCE,MEASURES,%MEASURES%)
TASK(/CPMB/APPL_TD_SOURCE,OUTPUTNO,%TEMPNO1%)
TASK(/CPMB/EXPORT_TD_CONVERT,INPUTNO,%TEMPNO1%)
TASK(/CPMB/EXPORT_TD_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)
TASK(/CPMB/EXPORT_TD_CONVERT,SUSER,%USER%)
TASK(/CPMB/EXPORT_TD_CONVERT,SAPPSET,%APPSET%)
TASK(/CPMB/EXPORT_TD_CONVERT,SAPP,%APP%)
TASK(/CPMB/EXPORT_TD_CONVERT,OUTPUTNO,%TEMPNO2%)
TASK(/CPMB/TD_FILE_TARGET,INPUTNO,%TEMPNO2%)
TASK(/CPMB/TD_FILE_TARGET,FULLFILENAME,%FILE%))
TASK(/CPMB/TD_FILE_TARGET,ADDITIONALINFO,%ADDITIONINFO%))
The scope prompt was filled only once:
The script successfully processed scope data and then the processed data was exported to the file.
B.R. Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Michal,
May be it's better to aggregate data by some simple script on some dummy members of unused dimensions and then export?
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Michal,
You can use end routine in your transformation file (BADI) to sum it up for you.
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.