dbTalk Databases Forums  

retrieve an alias in an essbase report

comp.databases.olap comp.databases.olap


Discuss retrieve an alias in an essbase report in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
sy.mon
 
Posts: n/a

Default 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

************************************************** ************************************************


Reply With Quote
  #2  
Old   
abhi.10dulkar@gmail.com
 
Posts: n/a

Default Re: retrieve an alias in an essbase report - 01-10-2006 , 04:05 AM






use OUTALT or OUTALTMBR for that particular dimension. I guess OUTALT
"enseigne" should solve the purpose.
Abhijeet


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.