Hyperion Essbase Ad-In - Drill Down Behavior

B

bill_morgan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add-In Launch 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
New computer, how do i move outlook 365 ENTIRELY? 0
Pivot table drill down data 2
Hyperion Essbase Excel Add-in - returning text ("0") for null valu 5
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Hyperion Essbase add-in macro 2
Create Excel Add in for Essbase 1

Top