mobileNavlogo
headerlogo

NEVERSHARE & ALIASES in EssBase

21 September, 2018

Ratings

Related Blogs

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 3rd 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)
About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .