When a user clicks on a linked cell in a linked partition, a spreadsheet opens and displays the linked database. This process is called drill across. To facilitate drill-across access, you can use the following strategies:
Create accounts for each user on each database. For example, if Mary accesses data in a Company database and an East database, create an account with the same login and password for Mary on the Company and East databases.
See Managing Users and Groups in Essbase Native Security Mode.
Create a default account that users can use when accessing target databases. For example, if users access data through a data source named Company and a data target named East, create a guest account for the East database with the appropriate permissions. Use the guest account login and password as the default login when creating the linked partition.
When a user drills across on data to a data target, Essbase logs the user into the data target using the following steps:
Checks whether the user has an account on the data target with the same name and password. If so, Essbase logs in the user using that account.
Checks whether you specified a default account on the data target when you created the partition. If you did, Essbase logs the user in using that account.
Opens a login window prompting the user to enter a new login and password. After the user enters a valid login and password, Essbase logs the user in using that account.