How fetch slice of data from one database to other database

We can fetch a slice of data from one database to other database using XREF function which intern using Location Aliases,

Here is small information how to use @XREF function in calculation script and Location Aliases in ESSBASE.

How to create Location Aliases:

Right click on the Location Aliases option and there you can see screen as below

and fill all the required credentials and click on the Test button available in the same screen, if all the provided details are verified successfully then you can the screen as below.

 now click on Set button on the same screen to apply the changes.

now you are ready with the Location Alias for the server and application/database

Then how could I use the Location Alias in the XREF function to fetch a slice of data from other database,

here is the way

Create one calculation script as shown below to use the available Location Alias

The Location Alias Test1 targets another application database in which it takes the value for the combination ("Jan","Spent","Coke","India",500)

Here is the report which ran before the calculation script run

here is the report which ran after the calculation script run

Those two above pictures depicts the feature of XREF function which uses Location Alias.