When I generate the report using the SET BLANKINDENT option and only displaying the sons of the member I’ve no problem, the right column is used to realized the “drill down”


When i click to a member of “ACTFID”, I want to show only the sons of this member conserving the indents of its brothers and fathers, for example



The problem is that when I obtain the report shown in the next figure
In this case I programmed the condition to show the data I need and the data that I don’t need are shown with a “point” by default.

http://mx.geocities.com/visual_x1999/Focus/d3.JPG

I tried to get this using the next commands:

ENGINE ESSBASE SET SUPMISSING ON
ENGINE ESSBASE SET SUPEMPTY ON

But i obtain an error and the next message

An error has been detected during server to client data transfer.
ERROR: -12: Pcb2.: java.net.SocketException: Connection reset

The code I’m using to generate the report is:

-SET &ECHO = ALL;
SET ASNAMES = ON
SET HOLDLIST = PRINTONLY
SQL ESSBASE SET USEALIASNAME ON
SET BLANKINDENT = ON

-DEFAULT &Escenario = 'Saldo acumulado';
-DEFAULT &Bancos = 'Santander_Serfin';
-DEFAULT &Tiempo = 'NOV';
-DEFAULT &Anio = 'Real 2005';
-DEFAULT &Formato = 'HTML';
-DEFAULT &MEMBER= '';
-DEFAULT &CADCOMP= 'COMNET';
-DEFAULT &CADCOMPREL='';
-DEFAULT &Nivel='';

TABLE FILE CG_COCOM1
SUM
SALDOS
MEZCLA
COMPUTE NOMBRE/A400 = FMLINFO('FORVALUE','A50');
FOR
PRODUCTOS_MEMBER
'COMNET' &Nivel AS CAPTION LABEL R1
WHERE ( TIEMPO_CAPTION EQ '&Tiempo' )
AND ( ESCENARIO_CAPTION EQ '&Escenario' )
AND ( ANIO_CAPTION EQ '&Anio' )
AND (BANCOS_CAPTION EQ '&Bancos')
AND (SALDOS NE ' . ')
AND PRODUCTOS_MEMBER IN ('&CADCOMP') ;
END

I´m using Essbase 6.1.4
Thanks

This message has been edited. Last edited by: RAMM,

RAMM

Please edit your post and put Code tags around the code or at least those bits containing html code.

{CODE} {/CODE} (switch { for < and } for >)

Or use the nice little button above (when in write mode) and paste between.