Im working in version 8207.28 of Designer Studio, and I am ...

[Ben Maxwell]

Im working in version 8207.28 of Designer Studio, and I am not quite sure how to enforce chaining when pointing directly to a master file.

The below is a super-basic chart against the CARS file. All I want to do is chain CAR to MODEL.

Can someone provide me code for a simple example where this works Thanks!

 

image.png969519 41 KB

[Andreas Starek]

Hi Benjamin

I think as of 8207.28 chaining of filter left to right is activated by default.

But you can check it on the filter properties control.

 

kind regards

Andreas

[Sarah Buccellato]

Andreas, welcome to myibi!

Benjamin, was Andreass post helpful

[Ben Maxwell]

Hi Sarah,

Im still not quite doing something right when I try to chain directly to a master file.

When trying a little different example I dragged in County and Car, the 2 fields are definitely not chaining.

 

 

image.png915281 25.7 KB

 

Now when I am working off a custom fex I created, I was able to chain w/o any difficulties.

 

 

Notice in the top example how the Filters area is greyed out.

 

 

My goal would be to obtain a simple example for the Cars file which would chain Country and Car.

[Alexander Homer]

Hi Ben,

If youre writing a FOCEXEC, you can use WITHIN in the filter statement to chain a filter to a parent filter field, e.g.

 

-DEFAULT &MODEL = _FOC_NULL;

-DEFAULT &COUNTRY = _FOC_NULL;

GRAPH FILE ibisamp/car

-* Created by Designer for Graph

SUM CAR.BODY.SALES

BY CAR.CARREC.MODEL

WHERE CAR.ORIGIN.COUNTRY EQ &COUNTRY.(OR(FIND CAR.ORIGIN.COUNTRY IN IBISAMP/CAR |FORMAT=A10,SORT=ASCENDING,FIELDNAME=CAR.ORIGIN.COUNTRY)).COUNTRY.;

WHERE CAR.CARREC.MODEL EQ &MODEL.(OR(FIND CAR.CARREC.MODEL IN IBISAMP/CAR |FORMAT=A24,SORT=ASCENDING,FIELDNAME=CAR.CARREC.MODEL, WITHIN=COUNTRY)).MODEL.;

ON GRAPH PCHOLD FORMAT JSCHART

ON GRAPH SET VZERO OFF

ON GRAPH SET HAXIS 770.0

ON GRAPH SET VAXIS 405.0

ON GRAPH SET LOOKGRAPH BAR

ON GRAPH SET EMBEDHEADING ON

ON GRAPH SET AUTOFIT ON

ON GRAPH SET STYLE *

INCLUDE=IBFS:/WFC/Global/Themes/Standard/Default/theme.sty,$

TYPE=REPORT, TITLETEXT=Chart1, ARREPORTSIZE=DIMENSION, ARFILTER_TARGET=*, CHART-COLOR-MEASURES=ON, ARGRAPHENGINE=JSCHART, $

TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $

TYPE=DATA, COLUMN=N2, BUCKET=y-axis(1), $

TYPE=FOOTING, BACKCOLOR=RGB(255 255 255), $

TYPE=GRANDTOTAL, OBJECT=TAG, FONT=CAMBRIA, COLOR=RGB(237 28 36), $

*GRAPH_SCRIPT

*GRAPH_JS_FINAL

blaProperties: {

seriesLayout: stacked

}

*END

ENDSTYLE

END

 

When you run, the two fields should chain in autoprompt. This may not work with some fields from different segments or dont have a clear relationship.

Does this work for your example As Andreas said, Designer can also force chaining within the design time UI.

[Sarah Buccellato]

Benjamin, I hope Alexs recommendation was helpful. If you need further assistance, I suggest that you open a case.

[Ben Maxwell]

At some point I will need to revisit my thought process on this one. Thanks for the suggestions!