Hello experts ,
I have the modele Purshase and Planning
Purshase have the dimensions:CENTRE_DE_COUTS(cost center),Artilce_SOCIETE(Material) , COMPTE(Account),TYPE_VALEURS(KPIS:Quantity, Price..)
Planning:CENTRE_DE_COUTS(cost center),COMPTE(Account),
CENTRE_DE_PROFIT(Profit center).
every material has an attribute (compte_A) wich is the purshase account.
every cost center has an attribute profit center
I have a script in my DEFAULT.LGF wich is
*SELECT(%CP%,[CENTRE_DE_PROFIT],CENTRE_DE_COUTS,ID=%CENTRE_DE_COUTS_SET%)
*SELECT(%CA%,[COMPTE_A],ARTICLE_SOCIETE,ID=%ARTICLE_SOCIETE_SET%)
*SELECT(%C%,ID,COMPTE,ID=%COMPTE_SET%)
*SELECT(%ARTICLES%,ID,ARTICLE_SOCIETE,COMPTE_A =%CA%)
*XDIM_MEMBERSET ARTICLE_SOCIETE = %ARTICLES%
*DESTINATION_APP = Planning
*SKIP_DIM = TYPE_VALEUR, ARTICLE_SOCIETE
*ADD_DIM CENTRE_DE_PROFIT = %CP%
*WHEN TYPE_VALEUR
*IS QTE
*WHEN COMPTE
*IS NA
*REC(EXPRESSION=%VALUE% ,COMPTE=ARTICLE_SOCIETE.COMPTE_A)
*ENDWHEN
*WHEN COMPTE
*IS <>NA
*REC(EXPRESSION=%VALUE% * [TYPE_VALEUR].[PRIX_UNIT] ,COMPTE=%C%)
*ENDWHEN
*ENDWHEN
*COMMIT
///////
but I want to automate the execution with /CPMB/DEFAULT_FORMULAS.
with the code :
PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%,"CENTRE_DE_COUTS_DIM"")
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,ACHATS.LGF)
but it's not working .
how can I achieve that ?
regards
Add comment