retrieve an alias in an essbase report -
12-21-2005
, 04:48 AM
Hi,
I would like to modify this report and retrieve the alias from the
table "Robert" for the dimension "enseigne" instead of the name of the
member.
Can someone help me?
here is the report script.
thank you.
Sy.mon
************************************************** ************************************************** **************
{ TEXT 0 "Periodic,Local,VO,Budget Initial N,Total.Produits" }
//----------------------------------------------------------------------------------------------------------------------------------------------------------
// Initialisation des formats
//----------------------------------------------------------------------------------------------------------------------------------------------------------
<SETUP { TabDelimit } { decimal v } { IndentGen 0 } <ACCON <SYM <QUOTE
<END
{SUPBRACKET
SUPMISSINGROWS
SUPCOMMA
MISSINGTEXT " "
NOINDENTGEN
SUPHEADING
SUPFEED
ROWREPEAT }
//----------------------------------------------------------------------------------------------------------------------------------------------------------
// Définition des axes dans le rapport
//----------------------------------------------------------------------------------------------------------------------------------------------------------
<PAGE("VUES", "DEVISES", "TYPE DE DONNEES", "PHASES", "PRODUITS" )
<COLUMN("PERIODS")
<ROW( "ENSEIGNES" , "INDICATEURS")
//----------------------------------------------------------------------------------------------------------------------------------------------------------
// Description des éléments sélectionnés dans le rapport
//----------------------------------------------------------------------------------------------------------------------------------------------------------
// >>>>>>>> Page Members
"Periodic"
"Local"
"Non Converti"
"Budget Initial N"
"Total.Produits"
// >>>>>>>> Column Members
"Total_Annee" "Janvier" "Fevrier" "Mars" "Avril" "Mai" "Juin" "Juillet"
"Aout" "Septembre" "Octobre" "Novembre" "Decembre"
// >>>>>>>> Row Members : Enseignes
<DESC "Pays"
// >>>>>>>> Row Members : Indicateurs
{ SCALE 0.001 }
<DESC "Valeurs Cpte d'exploit"
<DESC "Activités (valeurs)"
{ SCALE 1 }
<DESC "Pourcentages Cpte d'exploit"
<DESC "Activités (hors valeurs)"
!
// End of report
************************************************** ************************************************ |