• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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 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)
Summary
Review Date
Reviewed Item
NEVERSHARE & ALIASES in EssBase
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on NEVERSHARE & ALIASES in EssBase"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.