NEVERSHARE & ALIASES in EssBase

NEVERSHARE:-

tag the parent member , never share , when you don’t want the value of to be implicitly shared with the parent member . in the above example , quantity is tagged as never share and it has it’s own storage space .or we can write formula also or we can set it to missing .

ALIASES:-

Aliases are alternate   names for a member . To create aliases on a member .right click and edit member properties button . click the text box next to the default . enter name Usually aliases are used for creating long names . when a database is created . we can create 9 more aliases table in the outline . the aliases table contains information about member name and aliases name as in the example $ALT_NAME ‘default’ “JAN 2007” “jan regular” “si” “south india ” “ap” “Andhra predesh” “tn” “tamilnadu” $END An alias table name can take maximum of 30 characters . an alias name can take maximum of 80 characters .  

To create alias table:-

• Double click the outline and click properties tab .
• Right click on the alias table click create alias table and enter the name of the alias table.
• Only one alias information can be seen in the outline , the alias table should be activate. To make an alias table active, right click on the alias table and select set activate

Alias tab backup:-

To take backup of alias table, right click on the alias table and click export select alias table and click browse and folder to export . the alias table can be exported with .alt extension and it can be opened with note pad . To restore the alias table right click on the alias table and click import and locate the exported file from the above step . click OK. Alias table gets created. To create aliases using rules files:- INDIA SI   AP   ANDHRA PREDESH INDIA SI   TN   TAMILNADU

• Open data prep editor
• Open data source file (or open SQLDB and enter the required SQL)
• Map the first column to generation for geography enter 2 in the member field. Map the 3^rd column to GEN 4 . for the last column , select the dimension. Select . select alias under field type . the number will be same as previous column .
• Click options , dimensions build settings , dimensions build settings tab. Select ‘allow property changes ’ .
• Validate and save the rules file (these steps are with respect to the above data)