To create a Personal Variable, use this file format:
<?xml version="1.0" encoding="UTF-8"?> <AnalyzerAdmin> <ModifyUsers> <User LoginID="hyper1"> <AddPersonalVariable Name="MarketPV" Database="DB_connection_name" Dimension="Market"> <Member Name="Market" SelectionMode="CHILDREN"/> <Member Name="East" SelectionMode="CHILDREN"/> </AddPersonalVariable> </User> </ModifyUsers> </AnalyzerAdmin>
User and LoginID define the user login for which the Personal Variable is added. If a database connection exist with a specified name (see Database) for a specified user, a Personal Variable is added. The database connection file name is formed from the Database property by replacing «:» on «_». The connection file is searched in the Database folder of the specified user. If a connection file does not exist, the operation aborts. If a Personal Variable exists for the database connection, it is replaced by the new definition.
AddPersonalVariable initiates a request to create a Personal Variable. Member identifies the members within the dimension that make up the Personal Variable, and the selection mode for each member. Selection modes are: MEMBER, CHILDREN, DESCENDANT, PARENT, ANCESTOR, SIBLING, DIMBOTTOM, DIMTOP, LEVEL, GENERATION, and PREVIOUS. Default selection mode is MEMBER.