Very Computer

1. Essbase Outline Calculation

Lets say I have 20 departments and I am calculating Sales.  I could use:

Sales
  L  Salesdept 1
  L  Salesdept 2
  L  Salesdept 3
  L  ...

But, I also want to know Gross Profit for dept 1 (a calculated account) .
Should I use:

GPdept 1
  L  Salesdept1 (+) shared
  L  COSdept1 (-) shared

     OR...

GrossProfit
  L  GPdept 1   (Salesdept 1 - COSdept1)
  L  GPdept 2   (Salesdept 2 - COSdept2)
  L  ...

So, I could either duplicate members, labeling them as "shared", or I could
create calculations.  What are the pros and cons of each method?  I know
that calculations take more time to calc than just the natural rollup.  But
do shared members increase the size of the cube?

Thanks for your input.
Jack

2. Users to Logins?

3. SQL server versus Essbase : buiding outline members

4. Cancel edit record

5. Hyperion Essbase Outline editor Copy

6. Using ADO to create/modify tables

7. Q RE: Essbase Outline "Batch" Build

8. Moving Access view to SQL Server

9. essbase outline api

10. Optimizing Outline Restructures using Essbase 5.01

11. Essbase 'C' Outline API problem

12. Essbase Outline Design