I want to design a report like below:



class class01
class02

area sum vertical-percent horizontal-percent sum vertical-
percent horizontal-percnet

area01

area02

area03

...



Outline like



Database:test

area0

area01(+)

area02(+)

...

class0

class01(+)

class02(+)

...

num(Accounts)

How can I add other member under the "num" dimension?


--
Posted via http://dbforums.com

Note (see your note below) that your report layout got broken up such that
it is difficult to tell what you want across.
However, your outline is fairly clear. Are you just interested in adding
more "Accounts" (a.k.a measures) to the "num" dimension. Without much
information to go on, it would seem that you just need to add children to
the num dimension and put in the rollups or member formulas as needed
defining the relationship between the measures. To do this you can use a
dimension load rule, but if these measures are not changing constantly as
determined by a source system, then just use Essbase Application Manager and
you can do it in a few minutes.

I gather that you are new to Essbase, or I did not understand your question.

Fred Watkin
www.advanceinfo.com

"zhouhaiming" <member22054 (AT) dbforums (DOT) com> wrote