Hello,
I work in Essbase 7.1.2
I created a script allowing to create or replace replicated partition.
The problem, this script does not create the partition. On the other hand, when the partition already exists, the script enables me to refresh the replicated partition correctly.
From where my question, how to create a partition?
The script:
create or replace replicated partition OC_OPEX.OC_OPEX
area '@RELATIVE (TOT_ANNEE,0),"REEL_N",@RELATIVE (REGION_DET,0),"SEC_20005410",@RELATIVE(PROJET,0),
"TOT_MARCHE","TOT_ACT", "RETR_IFRS_CHG_ACQ"'
to OC_CAPEX.OC_CAPEX at 'tramolay' as admin identified by 'password'
area '@RELATIVE (TOT_ANNEE,0),"REEL_N","AR_IMMO_EXERCICE", @RELATIVE (REGION_DET,0),
"SEC_20005410", @RELATIVE(PROJET,0), "RETR_IFRS_CHG_ACQ"'
mapped globally ("") to ("AR_IMMO_EXERCICE")
mapped globally ("TOT_MARCHE") to ("")
mapped globally ("TOT_ACT") to ("")
;
I work in Essbase 7.1.2
I created a script allowing to create or replace replicated partition.
The problem, this script does not create the partition. On the other hand, when the partition already exists, the script enables me to refresh the replicated partition correctly.
From where my question, how to create a partition?
The script:
create or replace replicated partition OC_OPEX.OC_OPEX
area '@RELATIVE (TOT_ANNEE,0),"REEL_N",@RELATIVE (REGION_DET,0),"SEC_20005410",@RELATIVE(PROJET,0),
"TOT_MARCHE","TOT_ACT", "RETR_IFRS_CHG_ACQ"'
to OC_CAPEX.OC_CAPEX at 'tramolay' as admin identified by 'password'
area '@RELATIVE (TOT_ANNEE,0),"REEL_N","AR_IMMO_EXERCICE", @RELATIVE (REGION_DET,0),
"SEC_20005410", @RELATIVE(PROJET,0), "RETR_IFRS_CHG_ACQ"'
mapped globally ("") to ("AR_IMMO_EXERCICE")
mapped globally ("TOT_MARCHE") to ("")
mapped globally ("TOT_ACT") to ("")
;