Hyperion Essbase Ad-In - Drill Down Behavior
 

Hi ....

I am using the Hyperion Essbase Excel Add-In to interface with an Essbase
cube. I am puzzled by the drill down behavior (it is different from a pivot
table) and wonder if someone out there can help me.

Assume only 3 dimensions: Years, Department, Account. Years is set to 2005
and is in the page section. Both Department and Account are in the row
section, and assume 5 member levels for each of these Dimensions.

Problem: I want to drill down so that: 1) I get only zero-level Accounts AND
zero-level Departments; 2) for each Department I want to see all zero level
accounts. In other words, I need to see Department_1 on the left, and then
all 50 Departments on the right (accompanied by Account balace) - one row
perAccount, then the next Department (and all Accounts), etc. etc. for all
zero-level Departments and Accounts.

This is a simple feat for an Excel pivot table, but I keep getting duplicate
rows when I try to get the job done in essbase.

Anybody know the solution?

Thanks for your help ...

bill morgan