Hello,
I have a chart with a hyperlink, when i configure the hyperlink i don´t see three fields i need to sent as parameter.
I understand the fields must be on the chart, but i don´t need drawing them.

My chart is a circular ring diagram.

How i can do this? i need sending the fields as pararameters for the drill down.

Thank you.

This message has been edited. Last edited by: FP Mod Chuck,

Try using NOPRINT on the fields

Sorry Waz,
I tried select the fields on the graph and making them no visibles, but my chart changes.
Is that what you mean as NOPRINT?

I would appreciate if you give me a link where I can see how to do it.

Hi SPPC

Yes that is what Waz meant. Makeing them not visible adds the NOPRINT syntax under the covers. The data will not be displayed on the chart but those fields will be available to use as parameters in the hyperling (Drill Down).

Hope that helps.

OK, my chart is a circular ring diagram, i only can adding one field as measure, one as piece and one as multi-graph.

The only one that i can adding more fields is the category, no shows the hide field but the chart changes.

I need three new fields available to use as parameters in the hyperling (Drill Down).

Thanks for your help.

Hi SPPC

I now understand your dilemma. Prior to the graph create a TABLE request with the same data and filters and HOLD to foccache/drilldownparms.ftm. Then in the drill down do a -READFILE foccache/drilldownparms and the &variables will be created based on the fieldnames of the hold file.

Regards,

Chuck thanks for your answer, i'm new in appstudio and i don't understand what you suggest.

Could you give me a link where i can see the concepts you say?

Thanks again.

Hi SPPC

I missed seeing your reply until today. I have one more question before I provide an example. Is there a parameter limiting the results of the graph displayed before you do the drill down.

Thanks

SPPC

Can you please post your current code so I can see what syntax is in place.

Thanks

Thanks Chuck for your answer, but i could resolved it.

Yes, there are parameters limiting the results of the graph displayed before the drill down; then i used a parameter simple in the filter making reference to the name of the parameter to which corresponds each of my three attributes to send in the drill down.

Although I wonder how it would do if i did not have them as parameters.

This is the code:

-*IA_GRAPH_BEGIN
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9Im5vIj8+DQo8IS0tMS4wLS0+PFJvb3QgdmVyc2lvbj0iMS4wIj4NCiAgICA8T2JqZWN0IG9iamVjdElkPSJDaGFydF8xIj4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkxpbmtlZFNvcnRzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIi8+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJDcm9zc1RhYk1vZGUiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIj50cnVlPC9Qcm9wZXJ0eT4NCiAgICA8L09iamVjdD4NCiAgICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiPg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iU2FtcGxlRGF0YSIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iPmZhbHNlPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFJlY29yZExpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj4xMDA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUnVuUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsT3B0aW1pemF0aW9uIiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiI+dHJ1ZTwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJmaWVsZERpc3BsYXlNb2RlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5sYWJlbDwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJwcmVmaXhEaXNwbGF5TW9kZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIvPg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iQWN0aXZlX1N0eWxlX1VzZXJfdHlwZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+cG93ZXI8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsVmFsdWVzUGFnaW5nIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj40PC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkZvY2V4ZWNQcmVmZXJlbmNlcyIgdHlwZT0iTWFwIj4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlTbGljZXJzVGFiRWRpdEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNlcmllc1RhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iYXV0b0RyaWxsU2NyaXB0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIi8+DQogICAgICAgICAgICA8RW50cnkga2V5PSJydW5PblN0YXJ0dXBEZWZlcnJlZEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUVkaXRNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SG9tZVRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0ibWV0YWRhdGFfdmlld3MiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPk1ldGFEYXRhVHJlZS5WSUVXX0RJTVM8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheURhdGFUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImluZm9Bc3Npc3RNb2RlQWxsb3dlZEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF9wcmV2aWV3X3BhZ2VsaW1pdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+NTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW5zZXJ0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJydW5PblN0YXJ0dXBJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUxheW91dFRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUludGVyYWN0aXZlTW9kZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+dHJ1ZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0X2xheW91dCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+MTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UXVpY2tBY2Nlc3NUb29sYmFyU2F2ZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+dHJ1ZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkludGVyYWN0aXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY29tcG9zZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPlBERjwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UmVzb3VyY2VzRmllbGRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlGb3JtYXRUYWJJbmZv
*-INTERNAL_COMMENT LINE#1$TWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5Pg0KICAgICAgICA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iY2FzY2FkZU5hbWVzIiB0eXBlPSJNYXAiLz4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ik1hc3Rlcl9GaWxlcyIgdHlwZT0iU2V0Ij4NCiAgICAgICAgICAgIDxFbnRyeSB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5jbHVzdGVyX2VqZWN1Y2lvbl9wcm95ZWN0b3M8L0VudHJ5Pg0KICAgICAgICA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0ibWV0YWRhdGFWaWV3QXMiIHR5cGU9Ik1hcCI+DQogICAgICAgICAgICA8RW50cnkga2V5PSJjbHVzdGVyX2VqZWN1Y2lvbl9wcm95ZWN0b3MiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPkdlbmVyaWNDdWJlPC9FbnRyeT4NCiAgICAgICAgPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9IlNsaWNlckd1aUlzbGFuZCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZXlKaVFYVjBiMUJ5WlhacFpYY2lPbVpoYkhObExDSmlUM0IwYVc5dWMwZHliM1Z3Vm1semFXSnNaU0k2ZEhKMVpTd2lZbEpsWTB4cGJXbDBSM0p2ZFhCV2FYTnBZbXhsSWpwMGNuVmxMQ0ppVUhKbGRtbGxkME52Ym5SeWIyeFdhWE5wWW14bElqcDBjblZsTENKaVVuVnVkR2x0WlVOdmJuUnliMnhXYVhOcFlteGxJanAwY25WbGZRPT08L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iU0xJQ0VSX0lORk9STUFUSU9OIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5QRDk0Yld3Z2RtVnljMmx2YmowaU1TNHdJaUJsYm1OdlpHbHVaejBpVlZSR0xUZ2lJSE4wWVc1a1lXeHZibVU5SW01dklqOCtQQ0V0TFVOUFRWQk1SVlJGWDFOTVNVTkZVbDlIVWs5VlVDMHRQanhUVEVsRFJWSmZSMUpQVlZBK1BFZFNUMVZRSUdkeWIzVndUblZ0WW1WeVBTSXdJaUJ6YkdsalpYSkhjbTkxY0V4aFltVnNQU0pIY25Wd2J5QXhJaUJ6YkdsalpYSkhjbTkxY0U5eVpHVnlQU0l3SWlCemJHbGpaWEpIY205MWNGTnBlbVU5SWpBaUlITnNhV05sY2tkeWIzVndhR2xrWlQwaVptRnNjMlVpTHo0OEwxTk1TVU5GVWw5SFVrOVZVRDQ9PC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkNoYXJ0QXV0b2ZpdFNpemUiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIj50cnVlPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9ImVuYWJsZVByZXZpZXciIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIj50cnVlPC9Qcm9wZXJ0eT4NCiAgICA8L09iamVjdD4NCjwvUm9vdD4NCg==
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='100.0';
-DEFAULTH &WF_STYLE_WIDTH='500.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE cluster_ejecucion_proyectos
-* Created by Info Assist for Graph
SUM CLUSTER_EJECUCION_PROYECTOS.FCT_EJECUCION_PROYECTOS.NUMERO_HORAS
BY CLUSTER_EJECUCION_PROYECTOS.DIM_ACTIVIDAD.NOMBRE_ACTIVIDAD
ACROSS CLUSTER_EJECUCION_PROYECTOS.DIM_ACTIVIDAD.FACTURABLE
WHERE CLUSTER_EJECUCION_PROYECTOS.DIM_CONTRATO.SIGLA_NUM_NOMBRE_CONTRATO EQ &SIGLA_NUM_CONTRATO. (|FORMAT=A301V).SIGLA_NUM_NOMBRE_CONTRATO.QUOTEDSTRING;
WHERE CLUSTER_EJECUCION_PROYECTOS.DIM_EMPLEADO.NOMBRE_COMPLETO EQ &NOMBRE_COMPLETO. (|FORMAT=A120V).NOMBRE_COMPLETO.QUOTEDSTRING;
WHERE CLUSTER_EJECUCION_PROYECTOS.DIM_TIEMPO.PERIODO GE &PERIODO_INICIAL. (|FORMAT=YYM).Periodo.QUOTEDSTRING;
WHERE CLUSTER_EJECUCION_PROYECTOS.DIM_TIEMPO.PERIODO LE &PERIODO_FINAL. (|FORMAT=YYM).Periodo.QUOTEDSTRING;
WHERE CLUSTER_EJECUCION_PROYECTOS.DIM_CONTRATO.VIGENTE EQ &VIGENTE. (|FORMAT=A8V).Vigente.QUOTEDSTRING;
HEADING
" "
" "
" "
" "
FOOTING
"&NOMBRE_COMPLETO"
" "
"&SIGLA_NUM_CONTRATO "
"DEL &PERIODO_INICIAL AL &PERIODO_FINAL"
" "
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET EMBEDHEADING ON
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH PIERING
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
setPieFeelerTextDisplay(1);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENID_Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=HEADING, JUSTIFY=CENTER, FONT='TAHOMA', SIZE=10, COLOR=RGB(32 0 32), STYLE=BOLD, $
TYPE=FOOTING, JUSTIFY=CENTER, FONT='TAHOMA', SIZE=10, COLOR=RGB(32 0 32), STYLE=BOLD, $
TYPE=DATA, COLUMN=N1, TARGET='_blank', FOCEXEC=IBFS:/WFC/Repository/DB-System/Reportes_de_Productividad/Reportes/horas_consultor_contrato.fex(SIGLA_NUM_CONTRATO=CLUSTER_EJECUCION_PROYECTOS.DIM_CONTRATO.SIGLA_NUM_NOMBRE_CONTRATO), $
TYPE=DATA, ACROSSCOLUMN=N1, TARGET='_blank', FOCEXEC=IBFS:/WFC/Repository/DB-System/Reportes_de_Productividad/Reportes/horas_consultor_contrato.fex(PERIODO_INICIAL=&PERIODO_INICIAL.QUOTEDSTRING PERIODO_FINAL=&PERIODO_FINAL.QUOTEDSTRING SIGLA_NUM_CONTRATO=&SIGLA_NUM_CONTRATO.QUOTEDSTRING VIGENTE=&VIGENTE.QUOTEDSTRING NOMBRE_COMPLETO=&NOMBRE_COMPLETO.QUOTEDSTRING), $
*GRAPH_SCRIPT
setDataTextPosition(4);
setReportParsingErrors(false);
setSelectionEnableMove(false);
setPieFeelerTextDisplay(4);
setLegendPosition(4);
setDisplay(getLegendArea(),true);
*END
ENDSTYLE
END
-RUN

-*IA_GRAPH_FINISH

Hi SPPC

Is all you are wanting to do is pass the original parameters selected for this chart based on the WHERE statements to the drill down?

Sorry for so many follow-up questions just trying to understand exaclty what needs to be passed to the drill down.

Thanks,

Yes, that was. And I could do it as i told you.
But if the fields i need are not parameters? else other fields? How do it?

SPPC

This is untested so hopefully it will get you in a better place..

At the beginning of you chart procedure add the following code to capture the data for the 3 fields you want in addition to what is in the chart. I used field1 field2 and field3 not knowing which fields you need.

TABLE FILE cluster_ejecucion_proyectos
SUM field1 field2 field3
BY CLUSTER_EJECUCION_PROYECTOS.DIM_ACTIVIDAD.NOMBRE_ACTIVIDAD
ACROSS CLUSTER_EJECUCION_PROYECTOS.DIM_ACTIVIDAD.FACTURABLE
WHERE CLUSTER_EJECUCION_PROYECTOS.DIM_CONTRATO.SIGLA_NUM_NOMBRE_CONTRATO EQ &SIGLA_NUM_CONTRATO. (|FORMAT=A301V).SIGLA_NUM_NOMBRE_CONTRATO.QUOTEDSTRING;
WHERE CLUSTER_EJECUCION_PROYECTOS.DIM_EMPLEADO.NOMBRE_COMPLETO EQ &NOMBRE_COMPLETO. (|FORMAT=A120V).NOMBRE_COMPLETO.QUOTEDSTRING;
WHERE CLUSTER_EJECUCION_PROYECTOS.DIM_TIEMPO.PERIODO GE &PERIODO_INICIAL. (|FORMAT=YYM).Periodo.QUOTEDSTR
WHERE CLUSTER_EJECUCION_PROYECTOS.DIM_TIEMPO.PERIODO LE &PERIODO_FINAL. (|FORMAT=YYM).Periodo.QUOTEDSTRING;
WHERE CLUSTER_EJECUCION_PROYECTOS.DIM_CONTRATO.VIGENTE EQ &VIGENTE. (|FORMAT=A8V).Vigente.QUOTEDSTRING;
ON TABLE HOLD AS foccache/drilldata FORMAT ALPHA
END
-RUN

Then in the drill down fex add the following code at the beginning.

FILEDEF drilldata disk foccache/drilldata.ftm
-RUN
-READFILE drilldata
-RUN

The readfile will cause &variables to be created based on the field names from the TABLE request ie (&field1)

You can then use those &field1 &field2 and &field3 however you want in the drill down report.

If there is more than one record in the foccache/datadrill.ftm file you can set up a loop and read all the records and maniputate the &variables.

You already have the other variables handled in the drill down request so you have that part right.

Hope this helps,

Ooops I see a error in what I posted instead of

ACROSS CLUSTER_EJECUCION_PROYECTOS.DIM_ACTIVIDAD.FACTURABLE

Make it

BY CLUSTER_EJECUCION_PROYECTOS.DIM_ACTIVIDAD.FACTURABLE