Essbase Studio: Creating Alias

Here is the next section in the sequence of cube designing using Essbase Studio, today we will concentrate on creating Alias! Below are the sequence of steps which are self explanatory:




Step 1: To start we need tables containing member name and respective Alias, we can have them in the same table or in a different one:





Step 2: Create alias set by right click on the folder in the metadata navigator or you can create one more folder under root folder and create alias set under it




Step 3: Give name to alias set as “Default” and then click on “+” sign. Though you can give any name, but if its other then Default then you need to go to properties and choose the Active Alias table manually

  


Step 4: Select “Product Name” from Product table in Binding source and select “Product Alias” from Product_Alias in Binding expression and then click “OK”






Step 5: Now you can see the created bindings in the “Bindings” and click “Ok”



Step 6: You can see the alias set on selecting Alias tab on double clicking “Product Name” under Product table as well





Step 7: You can see the alias set on selecting Alias tab on double clicking “Product Alias” under Product_Alias table as well





Step 8: Create Product hierarchy by adding “Product Name” and click “Save”

  


Step 9: Create measure hierarchy as “Accounts” by adding “Sales” and click “Save”




Step 10: Create Cube schema:






Step 11: Now right click on the created model and click “Essbase Properties”





Step 12: Click on the “Alias” tab and select the alias set “Default” in the selected tables by using “Add the selected alias sets to the model” option in the middle and click “Apply”






Step 13: Deploy the cube by right clicking on the created cube schema


  

Step 14: You can see the alias in Essbase outline


:

Comments

Post a Comment

Popular posts from this blog

Multiple Navigation Flows are Active

Image
We have witnessed an issue where application migration or sometimes service restart in PBCS/EPBCS activates multiple navigation flows.  If multiple navigation flows are active you wont be able make changes in any of them, because in order to make change in navigation flow you have to make it inactive. Typically you may end up in following situation:  Solution is pretty simple: 1. Create a copy of any of the existing navigation flow:  2. Give it any desired name:  3. Now, you will see one additional navigation flow, with inactive status: 4.  Make it active: 5.  At this point of time you will have one active navigation flow and two inactive  6. Select the additional navigation flow you have created and delete it  7. Now you are back in business: Rahul S.
Read more

The Member Does Not Exists For The Specified Cube

Image
The member "" does not exist for the specified cube or you do not have access to it. Issue:  If you are running into a issue, where for a RTP member selection is throwing an error for a missing member, this regardless of the member you have selected in RTP or regardless of rule. You may be able to execute the rule from Calc Manager and not from Planning. Reason: You may run into this issue if: 1. You have added members in Planning and have not refreshed the cube 2. For the default value of a RTP in calc member you have a member which is not valid any more for planning application 3. For the default value of a RTP in calc member you have a member which is not valid any more for a plan type Solution: 1. Refresh cube 2. Update Default value of RTP which is causing issue to member which exists 3. Deploy the rule Rahul S.
Read more

"Smart View handled an unknown exception thrown by Microsoft Office" Error on Vista, Windows 7, Windows 2008

My MS-Office Components are Crashing After Installing Smart View on Vista, Windows 7, Windows 2008! This is one more one pretty common issue,   "Smart View handled an unknown exception thrown by Microsoft Office."   This is actually a known issue in version 11.1.2.1. If you look at the read me of Smart View you will find bug# 11696583 "On Vista, Windows 2008, and Windows 7 operating systems, Excel may terminate abruptly upon launching after you install Smart View. Workaround: Turn off “User Access Control” in User Accounts, available from the Control Panel." Here is the link to read me: http://download.oracle.com/docs/cd/E17236_01/epm.1112/readme/sv_1112100_readme.html When the User Access Controls are on Smart View faces problem in registering, when you set it off Smart View register itself like a charm. To have more information on UAC: http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx Now, when y...
Read more