Databases Reference
In-Depth Information
If
GenlevNum (the specific generation or level number)
is:
°
> 0
then it is using Generation reference
°
<+ 0
then it is using Level reference
Example:
@ANCESTVAL ("TOTAL VEHICLE",2,"TOTAL SALES")
: If current member
being calculated is the STINGER COUPE, then the returned member is
TOTAL SALES
at the
CARS
level.
@PARENTVAL
and
@ANCESTVAL
are used for one dimensional value swapping.
If you want to return values from another member based on multiple
dimensions, then you will use the
@MDPARENTVAL
and
@MDANCSETVAL
functions. For more information, refer to the online technical reference
included with your EAS software.
@XREF
: This function is used to reference data in another Essbase database.
The XREF requires you to define a location alias to another database. The
other database can be similar to the original database or should at least
have some similar dimensions.
@XREF(LOCATION ALIAS, [MEMBERLIST])
:
For more information,
refer to the online technical reference included with your EAS software.
LOCATION ALIAS
—you need to set a location alias as shown in the
steps below.
MEMBER LIST
—this is optional, you can give the list of the member
names for which you need the data.
The following are the easy steps required to create the very useful location alias:
1. In EAS, select your application and click on
Action.
2. Select
Edit
and click on the
Location Alias for "ESSCAR" (Your Application).
3. In the
Location Aliases
screen, give an
Alias name
. Select the
Essbase
Server
,
Application
,
Database
,
User name,
and
Password
and click on
the
Test
button.
4. Once you click on the
Test
button, it will verify your existence on that Server
or Application and the
verified
checkbox will be checked. Now, click on the
SET
button to save the information as shown in the following screenshot.
5. You can click on the
Delete
button to delete an existing Location Alias.