Hi,

Want to know how to hold value of previous levels in olap reports

Please find the fex used

-OLAP ON
-* File CAR_TABLE_OLAP_TEST.fex
OLAP DIMENSIONS
-* DIMENSIONS FILE CAR
CAR: CAR, BODYTYPE, SEATS, LENGTH;
END


TABLE FILE CAR
SUM
RETAIL_COST
DEALER_COST
BY CAR

FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET AUTODRILL ON
-*ON TABLE SET OLAPPANE CONTROL
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$

TYPE=DATA,
COLUMN=LENGTH,
TARGET='_blank',
FOCEXEC=print_car_parametres(CAR=CAR BODY_TYPE=BODYTYPE SEATS=SEATS LENGTH=LENGTH),
$
ENDSTYLE
END

-* File PRINT_CAR_PARAMETRES.fex
-TYPE CAR=&CAR
-TYPE BODY_TYPE = &BODY_TYPE
-TYPE SEATS = &SEATS
-TYPE LENGTH = &LENGTH


In the above code after drilling down to the last level I.E. from CAR to LENGTH , we try to call another fex (on click of length value )

Here we need to pass the values which were used for drill down. But only the values at the last level i.e length is passed on to the next fex.

How do we get the other values passed ? Any idea?

Please let me know if the requirement is not clear.

Thanks in advance

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

Can any body respond to this query...

Yes,

pass the variables

JG,

Passing variable between ordinary reports is working fine.
I want to know how to pass value from OLAP fex to ordinary fex.

Sridevi,

What happens is that in the AUTODRILL the previous sortfields are replaced by IFs.
I suggest that you add the sortfields after the verb:

-OLAP ON
-* File CAR_TABLE_OLAP_TEST.fex
OLAP DIMENSIONS
-* DIMENSIONS FILE CAR
CAR: CAR, BODYTYPE, SEATS, LENGTH;
END


TABLE FILE CAR
SUM
RETAIL_COST
DEALER_COST
-*
-* see here the added fields:
CAR NOPRINT BODYTYPE NOPRINT AVE.SEATS NOPRINT 

BY CAR

FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET AUTODRILL ON
-*ON TABLE SET OLAPPANE CONTROL
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$
-*
-* Notice that for the SEATS field one should use AVE.SEATS (or MIN or MAX or FST or LST) in case there is more than one record in the last BY.

TYPE=DATA,
COLUMN=LENGTH,
TARGET='_blank',
FOCEXEC=print_car_parametres(CAR=CAR BODY_TYPE=BODYTYPE SEATS=AVE.SEATS LENGTH=LENGTH),
$
ENDSTYLE
END

TABLE FILE CAR
SUM
RETAIL_COST
DEALER_COST
-*
-* see here the added fields:
CAR NOPRINT BODYTYPE NOPRINT AVE.SEATS NOPRINT

BY CAR

In olap, if we give NOPRINT means.. they come under measures..
without using NOPRINT options.. Do we have any other method.???

Not that I know of.
It is a thought: a new feature "NOMEASURE", where the field would exist but not shown in OLAP.

In OLAP we have one tab called measures, when we click on that whatever column you have given as NOPRINT that comes under that.
But i don't want to see under measure tab.
Is there any alternate for that?