Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Ben Maxwell

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...