How to create charts in Toad Decision Point

http://www.DellSoftware.com/Business-Intelligence-Suite Learn how to create charts in Toad Decision Point, part of Dell Software's Toad Business Intelligence Suite.

Hello. My name is Robert Pound, a product technologist for the Toad Business Intelligence Suite. Today I'll be discussing how to create charts in Toad Decision Point.
To begin, I have Decision Point open and a data set already connected to my workbook. In Decision Point, we have several different charting options. Tabular View allows row level access of your data sets, giving you the ability to validate your data. Dimensional View gives us the ability to create small aggregation tables and understand the size and uniqueness of each field. Pivot Table shows us data in a grid format as a cross-section of multiple dimensions.
Bar, Line, and Area charts allow us to visualize multiple dimensions and numeric data. Scatter Plots are visual comparisons of numeric data sets. Pie charts show us a single numeric and dimensional data visualized as a percentage. Crosstab gives us the same granularity that Tabular View does, however, it allows us to cross dimensions similar to a pivot table.
Now let's take a look at how each of these are functionally created. I'll start by selecting Tabular View. To get an idea of what's in our data set, we can simply drag and drop fields that we want to view on a row by row basis, and then scroll through each individual row.
In the Dimensional View, we can create as many tables as we like by simply dragging and dropping to the canvas, and then adding to that table the desired facts and numerical values. The numeric values, by default, are set to sum, but you can change the aggregation. In pivot tables, we can drag dimensions to both the row and column headers and drop in our numeric values into the table itself.
On to the visualizations. The first way we can generate visualizations is from the Dimensional View itself. In this particular table, I have an aggregated view. If I want to visualize this, I can simply click Send a Chart, and it will create a new tab with that visualization. From here, I can add more dimensions to get a better picture of my data.
Line charts have similar functionality to bar charts. The functionality for an Area chart is similar. For a scatter plot, we will compare two numerical values. And then from here, we may add dimensional views if we like. For pie charts, we will be using a single dimensional and numerical value.
Finally, crosstabs. Crosstabs are created similar to pivot tables. They have both row and columns as well as the field. We will drop our dimensions into both the column and row headers, and then drop our numeric values into the field itself.