for%20IBM%20Cognos%20Series%207%20Impromptu

1
forIBM Cognos Series 7 Impromptu
from Three D Graphics
2
Preface
About five years ago, Cognos elected to freeze
the chart expressions in Series 7, Impromptu and
PowerPlay  - technology licensed from Three D
Graphics. In the ensuing period there has been a
significant advance in every aspect of chart
technology, led by Three D Graphics - the leader
in the field. The result is Charts Unlimited for
IBM Cognos Series 7 Impromptu (to be followed
later by PowerPlay). For Users of Series 7
Impromptu that have not yet chosen the superb
attributes of IBM Cognos 8 BI, Charts Unlimited
is a powerful, single click electable, exchange
replacement chart library, fully and totally
supported by Three D Graphics.

• Operations Assisted by more than 100 new macros,
  achieve superior Ease of Use, Usefulness and
  Usability
• Performance Receive an additional complement of
  chart types responsive to every need and
  application
• Aesthetics New expert pie labeling, perfect
  anti-aliasing, great multi-dimensional gauges,
  transparencies and more

3
Features Benefits
Charts Unlimited subscribers receive all of the
current chart capability in Series 7 as well as

• Immediate upgrade to a panoply of new features
  throughout the entire spectrum of chart usage.
• Guarantee of aesthetic evergreen through
  quarterly additions.
• Immediate access to more than 100 new tools
  (macros) that facilitate the process of
  building chart-centric reports.
• Guarantee of technology evergreen through
  quarterly reports.
• Timely response to special chart requirements.
• Timely response to technical problems and special
  technology issues.
• Timely access to the Three D Graphics development
  staff for resolution of chart support issues of
  every nature.

4
Immediate New Chart Provision

• State of the art anti-aliasing together with
  enhanced bevel, soft shadow, and transparency
  effects. Adds both sizzle and sophistication.
• New chart types include Pareto, bubble,
  waterfall, box whisker and most particularly, a
  variety of multi-faceted gauges.
• Full support for P-charts, X-bar charts, range
  charts and all other Six Sigma graphs in
  conjunction with the current Series 7 step-line,
  error-bar, range-line and SPC chart capability.
• Single- and Multiple-Pie engine with
  multi-faceted labeling capability that eliminates
  the interferences that plagued its predecessors.

5
Immediate Chart Upgrade

• Significant (and continuing) upgrade and
  expansion of Gantt charts and stock charts.
• Resolution of common Series 7 charting issues

• Programmatic control over dozens of chart
  properties like min/max scale range, hi-light
  colors, reference lines, etc.
• Set chart parameters at run-time instead of
  design-time
• Complete and easy methods to pivot and swap data
  in the chart
• Control over null-to-zero and zero-to-null
  conversions, numeric formatting and more
• Improved automatic layout routines that guarantee
  professional looking charts with well formatted
  labels, no matter how complex the dataset

6
Charts Unlimited
Charts Unlimited is composed of three elements

• Aesthetic. In comparison to the technology of
  five years ago, Charts Unlimited boasts two new
  rendering engines. Multi-slice single and
  multiple unit Pie Charts with expert labeling
  perfect anti-aliasing great multi-dimensional
  gauges transparencies and more
• Performance A full complement of chart types
  responsive to every need and application
• Operations Most important! Three D Graphics has
  generated more than one hundred macros
  specifically targeted to enable superior Ease of
  Use, Usefulness and Usability

7
Charts Unlimited Aesthetic Elements
A closer look at some of the more interesting
Aesthetic Elements

• Label placement on single and multiple pie charts
  are both interesting and intelligible
• Advanced Bezier technology enables perfectly
  smooth lines
• Transparency tools are the secret to awesome
  looking gauges
• Bevel effects can be applied to any and all chart
  objects

8
Pie Label Layout
Series 7
Charts Unlimited
9
Multi-Pie Label Layout
Series 7
Charts Unlimited
10
Charts Unlimited Anti-Aliased Drawing
Without Anti-Aliasing
With Anti-Aliasing

• Without Anti-Aliasing, curves along the outer
  edge of the gauge and the gauge band are bumpy
  and jagged
• With Anti-Aliasing, curves along the outer edge
  of the gauge and the gauge band are perfectly
  smooth

11
Charts Unlimited Anti-Aliased Drawing

• Gauges are automatically rendered with
  anti-aliased drawing for perfectly smooth lines
• Multiple gauge border styles and gauge needle
  styles are available

12
Charts Unlimited True Bezier Curve Drawing

• B-Spline based Curved Line Chart
• Drawn with Charts Unlimited true Bezier curve
  drawing technology

13
Charts Unlimited True Bezier Curve Drawing
2.5D Curved Stacked Area Chart
14
Charts Unlimited Variable Transparency

• True Alpha-Channel Transparency can be applied to
  any chart object
• Great for designing charts with hidden data
  areas

15
Charts Unlimited Variable Transparency
2.5D Absolute Area Chart with Variable
transparency
16
Charts Unlimited Bevel Effects

• Charts Unlimited includes several bevel
  overlays that can be drawn above a standard
  chart object.
• These drawing effects add visually appealing
  glints, highlights and shadows.

17
Charts Unlimited Bevel Effects

• Bevel Effect applied to risers and chart frame
• Bevel Effect can be applied to any chart object

18
Charts Unlimited Square Bevel Fill
Square bevel effect applied to chart risers and
their associated series icons.
19
Charts Unlimited Spherical Bevel Fill
Spherical Bevel fill effect can be applied to any
circular fill area
20
Charts Unlimited Performance Elements
A closer look at some of the more interesting
Performance Elements

• Gauge Configurations
• Box Plots
• Gantt Charts
• 2-Series Absolute Bar Chart
• Pareto Chart
• Waterfall Charts
• Histogram Report
• User-Defined Markers Lines

21
Charts Unlimited Gauge with Clipped Border

• Clipped Gauge border style draws the border
  according to specified start/stop angles of the
  inner Gauge Range/Band
• Bevel effect applied to standard gauge Needles

22
Charts Unlimited Gauge with Thin Needle Style
Configurable Gauge Needle Styles
23
Charts Unlimited Gauge with Dark Metallic Border

• Dark Metallic Gauge Border
• Steeple Gauge Needle Style
• Gauge Label automatically placed inside gauge
  between start/stop range

24
Charts Unlimited Box Plots
Configurable Box Width

• Configurable Marker Shapes Sizes
• Configurable Number of Markers

25
Charts Unlimited Gantt Chart
26
Charts Unlimited 2-Series Absolute Bar Chart
27
Charts Unlimited Pareto Chart
28
Charts Unlimited Waterfall Chart
29
Charts Unlimited Waterfall Chart with Total Riser
30
Charts Unlimited Histogram Report
31
Charts Unlimited Operations
Charts Unlimited features can be activated by
entering macros in chart title fields in the
Cognos Administrator Chart Titles dialog.
Even though macros are defined in the chart title
fields, they will not appear as text in your
chart. If you need to use a particular title
field to define a chart title and to enter a
macro, append a tilde () character and a space
to the title and add the macro after the space.
32
Charts Unlimited Operations

• Charts Unlimited macros can also be specified at
  run-time by associating a macro with an unused
  position in the data set.
• Charts Unlimited macros consist of an _at_ and a
  macro name (e.g., _at_DATATEXT Data Text Mode or
  _at_DLT Data Line Type).
• Most Charts Unlimited macros allow you to specify
  additional parameters (e.g., _at_BEVEL ChartObject
  BevelType) that further define the operation of
  the macro.
• Some Charts Unlimited macros do not require any
  parameters. For example, _at_GANTT will create a
  Gantt Chart assuming the data set contains the
  required data.
• If there are any problems, the chart footnote
  will show a message to help you identify any
  errors.
• Charts Unlimited macros cover a broad range of
  chart elements and functionality Auto
  Arrangement, Label Placement, Color Special
  Effects, Chart Types, User-Defined Fill Areas,
  Labels Lines, and much more.

33
Charts Unlimited Macros Axis

• _at_AXIS - Assign a series to an axis.
• _at_DX, _at_DY, _at_DY2 - X, Y, Y2-Axis Divisions
• _at_GX, _at_GY - X, Y-Axis Grid Style
• _at_HOUR_SCALE - Format the hour scale on a time
  axis
• _at_PX, _at_PY, _at_PY2 - X, Y, Y2-Axis Precision
• _at_SCX, _at_SCY, _at_SCY2 - X, Y, Y2-Axis Scale
• _at_Y1 / Y2BASE - Y1, Y2-Axis Base Line
• _at_Y1 / Y2INVERT - Invert Y1/Y2-Axis
• _at_Y1 / Y2_FORCE_PERCENT - Use format on
  Y1/Y2-Axis
• _at_Y2SLAVE - Slave a Y2-Axis to the Y1-Axis

34
Charts Unlimited Macros Axis
_at_BEVEL 3 4 (Bevel bubble risers)_at_GX 3 (Inside
Ticks on the X-Axis)_at_GY 4 (Outside Ticks on the
Y-Axis)_at_PX 2 (2 Decimal Places on X-Axis
Values)_at_PY 4 (4 Decimal Places on Y-Axis
Values)_at_SC 1000 5000 (Y-Axis Scale
1,000...5,000)_at_SCX 1000000 6000000 (X-Axis Scale
1,000,000...5,000,000)
35
Charts Unlimited Macros Series Groups

• _at_CALC_PERCENT_SERIES - Calculate a percentage
  series.
• _at_FORCE_ABSOLUTE - Force a series to plot absolute
• _at_FORCE_SERIES_COUNT - Force a of series in a
  chart
• _at_FORECAST - Add Blank Groups
• _at_IG / _at_IS - Ignore Group/Series
• _at_PERCENT_SERIES - Create a Percentage Series
• _at_RG / _at_RS - Reverse Groups/Series
• _at_SORT - Sort Series/Groups
• _at_STEP_LINE - Draw a step line across a series
• _at_SWAP - Swap Series/Groups
• _at_TOTAL_GROUP - Create a total group

36
Charts Unlimited Macros Series Groups
_at_STEP_LINE -1 1 (-1ALL SERIES, 1ENABLE STEPPED
LINE)
37
Charts Unlimited Macros Labels

• _at_AGL - Redefine Group Labels
• _at_ASL - Redefine Series Labels
• _at_COND_GROUP_LABEL - Color a riser based on a
  group label
• _at_GROUP_LABELS_ON_BASELINE - Draw group labels on
  the charts baseline
• _at_XSKIP Skip a number of group labels

_at_GROUP_LABELS_ON_BASELINE 1
38
Charts Unlimited Macros Risers Markers

• _at_BUBBLEMODE - Control appearance of bubble chart
  risers
• _at_HIDE_ZERO - Hide Risers/Markers for zero data
  points
• _at_HL - Highlight a Riser/Marker
• _at_MARKER - Marker Shapes
• _at_MCOLOR Marker Colors
• _at_PAT - Apply Pattern to Risers/Markers
• _at_RISER_BORDER - Enable/Disable Riser Borders
• _at_RISER_OVERLAP - Overlap between risers in
  side-by-side/clustered bar charts
• _at_RISER_WIDTH - Width of Risers in bar charts
• _at_SZ - Marker Size

39
Charts Unlimited Macros Risers Markers
_at_RISER_OVERLAP -50
_at_HL 0 2 255 255 0 (Hi-light Series 1, Group 3,
Yellow)
40
Charts Unlimited Macros Data Data Text

• _at_APPEND_DATATEXT - Append a String to Data Text
• _at_DATATEXT - Select a Data Text Mode
• _at_DLT - Data Line Type
• _at_DP - Data Point Override
• _at_DPC - Data Point Clear
• _at_DT - Show/Hide Series-Specific Data Text
• _at_FORCE_DATALINE - Force data line connecting all
  data points
• _at_FORCE_DATATEXT_CURRENCY - Force data text to
  currency format
• _at_IR - Insert Row (i.e., create a user-defined
  series of data)
• _at_OFFSCALE_Y1 - Off-scale Values on a Y1-Axis
• _at_RDT - Rotate Data Text
• _at_RESET - Reset Internal Data Range
• _at_Y_ZERO - Include/Exclude zero to calculate
  Y1-axis auto-scale

41
Charts Unlimited Macros Data Data Text
_at_FORCE_DATATEXT_CURRENCY 2 (0, 1, 2, 3Euro)
_at_RDT 2 (Rotate Data Text 90 degrees)_at_APPEND_DATAT
EXT (s) (Append (s) to Data Text)
42
Charts Unlimited Macros Color Special Effects

• _at_ALPHA - Apply Alpha Channel Transparency to a
  riser or marker
• _at_ALT_FRAME_FILL - Alternating Frame Fill
• _at_ALT_FRAME_FILL_MODE - Alternating Frame Fill
  Mode
• _at_AUTO_COLOR - Activate Automatic Color Mode
• _at_BEVEL - Draw a bevel effect on a chart object
• _at_COLOR_MODE - Color Mode (Color by Series or
  Color by Group)
• _at_COLOR_SCHEME - Activate a pre-defined color
  scheme
• _at_COND_COLOR - Apply color to risers
  (bar/line/area) based on conditions
• _at_CURVED_LINES - Apply curved lines to an line or
  area chart
• _at_DEFINE_SCHEME - Define Color Scheme
• _at_GCOLOR - Color a Chart Object
• _at_SHADOW - Apply a Drop Shadow to a chart object

43
Charts Unlimited Macros Color Special Effects
_at_ALT_FRAME_FILL_MODE 1(1Horizontal)_at_ALT_FRAME_FI
LL 0 255 255 255(Red,Green,Blue,Transparency)
_at_COLOR_SCHEME 5
44
Charts Unlimited Macros Lines

• _at_CX - X-Axis Line with Color
• _at_CXY - Line between two X/Y Coordinates with
  Color
• _at_CY - Y-Axis Line with Color
• _at_INIT_USERLINES - Initialize all user-defined
  lines
• _at_LS - Line Style
• _at_MEAN - Mean Average Line
• _at_MOVA Standard/Scientific Moving Average Line
• _at_SMOOTH_LINE - Connect data points with Smooth or
  Straight Line segments
• _at_TRENDLINE - Trend Line
• _at_TRENDLINE_ALLDATA - Linear Regression Line
  through all data points
• _at_X - X-Axis Line at Value
• _at_XG - X-Axis Line at Group

45
Charts Unlimited Macros Lines
_at_CY 100 255 255 0_at_CY 90 0 0 255_at_USER_MARKER 90
9 4 255 0 0 Old Average_at_USER_MARKER 100 31 5 255
255 0 Target_at_USER_MARKER 100 35 2 0 255 0
25_at_USER_MARKER 90 38 0 0 0 255 Peer Average
46
Charts Unlimited Macros Lines

• _at_XSZ - X-Axis Line with Label
• _at_XSZL - X-Axis Line with Label on Left
• _at_XSZN - X-Axis Line with Label Value
• _at_XSZNL - X-Axis Line with Label Value on Left
• _at_XY - Line between two X/Y Coordinates
• _at_XY_DP2 - Line between two Data Points (Scatter
  Charts)
• _at_Y - Y1-Axis Line
• _at_YSZ - Y1-Axis Line with Label
• _at_YSZL - Y1-Axis Line with Label on Left
• _at_YSZN - Y1-Axis Line with Label Value
• _at_YSZNL - Y1-Axis Line with Label Value on Left

47
Charts Unlimited Macros Lines
_at_SMOOTH_LINE -1 1 (-1ALL SERIES, 1ENABLE SMOOTH
LINES)
48
Charts Unlimited Macros User-Defined Fill Areas

• _at_USER_CIRCLE - Outlined Circle
• _at_USER_CIRCLE_ABOVE - Outlined Circle above Chart
  Area
• _at_USER_FILL - Color-Filled Rectangle
• _at_USER_FILL_CIRCLE - Color-Filled Circle
• _at_USER_FILL_CIRCLE_ABOVE - Color-Filled Circle
  above Chart Area
• _at_USER_FILL_CIRCLE2 - Pattern-Filled Circle
• _at_USER_FILL_CIRCLE2_ABOVE - Pattern-Filled Circle
  Above Chart Area
• _at_USER_FILL2 - Pattern-Filled Rectangle
• _at_USER_MARKER - Marker at X/Y coordinates
• _at_USER_MARKER2 - Marker at X/Y coordinates with
  Value
• _at_USER_RECT - Outlined Rectangle
• _at_UW - Vertical Band
• _at_WC - Color _at_UW Vertical Band

49
Charts Unlimited Macros User-Defined Fill Areas
_at_USER_FONT 14 255 0 0 255 Splash_at_USER_RECT 0.0
0.5 0.0 0.5 255 0 0 2 800 Three D Graphics
50
Charts Unlimited Macros Chart Type Chart
Specific

• _at_3DSCAT - 3D Scatter Chart
• _at_COMBO - Combo Chart
• _at_COMPARE2 - 2-Series Absolute Bar Chart
• _at_GANTT - Gantt Chart
• _at_GRAPHTYPE - Select from over 100 Graph Types
• _at_PARETO - Pareto Chart
• _at_POLAR - Polar Chart
• _at_RIVER - 2-Series Floating Area (i.e., river)
• _at_WATERFALL - Waterfall Chart

51
Charts Unlimited Macros Chart Type Chart
Specific
_at_COMBO 0 2 _at_COMBO 1 0 _at_COMBO 2 1
_at_RIVER 1 1
52
Charts Unlimited Macros Box Plots

• _at_BP - Box Plot with a square-style tail
• _at_BP2 - Box Plot with a T-style tail
• _at_BP3 - Box Plot with a I-style tail
• _at_BPH - Box Plot Orientation (Vertical/Horizontal)
• _at_BPW - Use the sixth data value to determine the
  width of Box Plots
• _at_IN - Move the First Box Plot In/Right by a
  specified number of virtual units
• _at_MC - Marker Colors in Box Plots
• _at_MK - Number of Markers in Box Plots
• _at_MS - Marker Shapes in Box Plots

53
Charts Unlimited Macros Box Plots
_at_BPH 1 (Horizontal Box Plot)_at_MK 3 (3
Markers)_at_MC 1 255 0 0 _at_MC 2 0 255 0 _at_MC 3 0 0
255 (Marker Colors)
54
Charts Unlimited Macros Gauges

• _at_GAUGE_ANGLE - Start/Stop Angle of Gauge
  labels/gridlines
• _at_GAUGE_BORDER_STYLE - Gauge border
• _at_GAUGE_BORDER_THICKNESS - Gauge border thickness
• _at_GAUGE_CHART - Create a Gauge Chart
• _at_GAUGE_MULTIPLE_NEEDLES - Gauge multiple needles
• _at_GAUGE_NEEDLE_STYLE - Gauge needle style
• _at_GAUGE_RANGE_COLOR - Gauge band colors
• _at_GAUGE_RANGE_START_STOP - Gauge range start/stop
• _at_GAUGE_RANGE_THICKNESS - Gauge Band Thickness
• _at_GAUGE_RANGE_THRESHOLD - Gauge Band Thresholds

55
Charts Unlimited Macros Gauges
_at_GAUGE_CHART _at_GAUGE_MULTIPLE_NEEDLES 0 (1
Needle, Multiple Markers)_at_GAUGE_BORDER_STYLE 5
(Metallic Border) _at_GAUGE_NEEDLE_STYLE 2
(Triangle with Extended End)
56
Charts Unlimited Macros Miscellaneous

• _at_EB - Adds error bars to standard bar/column
  charts
• _at_FONTANGLE - Change the rotation angle of a text
  object
• _at_FONTNAME - Map a global font on a text object
• _at_FONTSIZE - Font size of a text object
• _at_FRAME - Frame size/location
• _at_HAT - Size of hats on Error Bars
• _at_LEGEND - Legend size/location
• _at_LEGEND_ORDER - Force Legend Order
• _at_LEGEND_WRAP_WIDTH - Virtual wrap point for all
  legend text
• _at_ORD_SPACE - Draw line chart to chart frame or
  inset
• _at_USER_LABEL_FONT - User-Defined Label Font

57
Charts Unlimited Miscellaneous Macros
_at_EB 1 (Turn ON Error Bars)_at_HAT 50 (Width of
Error Bar Hat)_at_YSZL 60.9 0 0 Old Target _at_YSZL
67.0 0 0 Target
58
Charts Unlimited Warranty
Three D Graphics is solely responsible for the
development, product testing, system testing,
production, marketing and support of the current
and future versions of Charts Unlimited for IBM
Cognos Series 7/Impromptu. Users can be assured
that the IBM Cognos-provided chart component of
Series 7/Impromptu can be single-click restored
at any time. In such event, Three D Graphics will
cheerfully refund the unused portion of any of
the selected Charts Unlimited licensing
options. As noted therein, Three D Graphics is
the Licensor to IBM Cognos of the current
Impromptu Series 7 chart technology, as well as
the chart component in IBM Cognos 8 BI. 
Accordingly, the Company is in the best position
to offer the comprehensive benefits of Charts
Unlimited to those Users of Series 7/Impromptu
that have not yet elected to migrate to the
overall substantial attributes of IBM Cognos 8 BI
.