Drill Across and Linked Partitions

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:

When a user drills across on data to a data target, Essbase logs the user into the data target using the following steps:

  1. 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.

  2. 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.

  3. 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.