Hi,
I'm trying to put together a report script in Essbase and am not
very familiar with the commands, etc.
I have a dimension called Projects that has an attribute associated
with it called Manager. The Manager attribute has many levels (VP -
Director - Manager)
What I'd like to get in a report is a hierarchical display of all
projects under an upper-level manager that also shows the managers
under with their respective projects:
EG. given director, the report should show:
Director (upper-level attribute selection)
Manager1 (bottom level of attribute)
Project1 (level 0)
Project2
Manager2
Project3
Project4
Project5
Manager3...
etc...

Any help or script examples would be great - thanks!

You need more clarity:

Are the "associated attributes" part of an Attribute Dimension or are they
UDA attributes?

Can you send me the outline?

I have a lot of experience with both modes, but it's been a while. I could
help you, but you would need to talk to me first. (416)724-9112.

Don't forget, if you're playing with report scripts in Excel, you must have
Free Form Retrieve / Template Mode turned on (see the Essbase Menu item
called Options).

In the meantime, experiment with this:

<SETUP{NAMESON}{SUPMISSINGROWS}{MISSING " ~"}{SKIPONDIM
MANAGER }{SUPPAGEHEADING}<END
DIM1NAME
DIM2NAME
DIM3NAME
MANAGER
<ROW (MANAGER, PROJECTS)
<DESC DIRECTOR
<DESC MANAGER
{SKIP}
!
{INCMISSINGROWS}
<ROW (PROJECTS, BLAH)
{SUPCOLHEADING}
FOO WHATEVER
<IDESC "WHATEVER"
{SKIP }

!


Robert

"Jefe" <jefejuevos (AT) yahoo (DOT) com> wrote

Further,

You can intersperse straignt dimension / member names in and amongst report
script commands like <IDESC, <ICHILD, <ROW(BLAH, BLAH).

Your member names / dimension names can be in different columns in the
spreadsheet too; that will alter the resultant layout. Also, keep in mind
that the same commands will work differently in the report write that it
would in the Excel Template Retrieve mode. That is an idiosyncrasy of Excel
/ Essbase AddIn (which is not a COM component).

Robert

"Jefe" <jefejuevos (AT) yahoo (DOT) com> wrote

Sorry, there was a couple of typos in my previous message.

I meant to say:

Also, keep in mind that the same commands will work differently in the
Essbase Report Writer than they would in an Excel worksheet set to Template
Retrieve mode. It's an idiosyncrasy of Excel and the Essbase AddIn (which is
not a COM component).

Robert
"Jefe" <jefejuevos (AT) yahoo (DOT) com> wrote