Quote:> Essbase Web Gateway does not allow remote calculations or outline
> modifications througt a internet architecture.
> Could anyone describe me an architecture/solutions allowing that kind of
> operation ? Thanks.
Lets say I have 20 departments and I am calculating Sales. I could use:
L Salesdept 1
L Salesdept 2
L Salesdept 3
But, I also want to know Gross Profit for dept 1 (a calculated account) .
Should I use:
L Salesdept1 (+) shared
L COSdept1 (-) shared
L GPdept 1 (Salesdept 1 - COSdept1)
L GPdept 2 (Salesdept 2 - COSdept2)
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.