ACE Analytics

ACE Analytics is a module that allows you to: Create charts, tables, and other visualizations of your data Save these "visuals" in your own gallery Combine them into dashboards Place them in reports that can be shared with others...

When you launch the ACE Analytics module, you'll see this initial page: The three colored panels shown above are your menu for the different features in the application. The icon in the upper left-hand area will always return you to this pa...

The ACE Analytics application uses a theme to specify its colors and appearance. If you've been designated as an Administrative User (see previous section), you may be able to use the Theme Editor tool to customize the theme in use. The ima...

If you choose to include a "PDF Link" component, you should be aware of what the PDF version of the report will look like. When the report is converted into a PDF document, the internal ACE Analytics report name, the Design and View links, an...

Each component has its own settings, which are displayed by clicking the component's Gear icon: As you'd expect, the settings will be different for different components. The settings for the Link component are shown above. The Text ...

Report settings are configured by clicking the gear icon next to the report title: The available options, shown above, allow you to change the report name or save a copy of the report into your My Items folder.

Just under the report title, you can see the Design and View links, which let you switch modes. When you elect to create a new report (from the Home page), it starts in Design mode but you can switch modes at any time. In Design mode, the component...

Let's meet the building blocks of a ACE Analytics report. A report can use any of the following components: Text - You can enter text to be displayed in the report. Various font attributes like size can be set as desired. Image - You can ...

An ACE Analytics report displays an arrangement of components that convey the information you want to see. Visuals from the Visual Gallery can be included in reports and charts in them are fully functional in a report: their animation, hover highli...

Each dashboard panel has its own settings icon: The available options, shown above, allow you to change the panel title, or remove the panel from the dashboard. As shown above, panels can be re-arranged by dragging their titl...

Dashboard Tab settings are configured by clicking the gear icon next to the active tab title: The available options, shown above, allow you to add visuals from the Visual Gallery, change the panel layout, rename the tab, or remove it alt...

Dashboard settings are configured by clicking the Gear icon next to the dashboard title: The available options, shown above, allow you to change the dashboard title, or to save a copy of the dashboard into your My Items folder.

When you create a new dashboard, or when you change tab settings, the Visual Gallery will be displayed: As you can see above, it's a collection of all of the visuals saved in the gallery. You can recognize them from their thumbnail image...

An ACE Analytics dashboard consists of a collection of visuals (charts, gauges, and tables): They're placed into dashboard  panels and grouped on dashboard  tabs , as shown above.

You may want to share your work with other ACE Analytics users. Sharing is an optional ACE Analytics feature that may have been enabled by your ACE Analytics developer. Sharing Individual Items Individual reports, dashboard, and analyses t...

Once you create an analysis, dashboard, or report, it appears as an item in the list on the ACE Analytics Home page: List items include icons at the right end that allow you to schedule, share (both discussed later), or delete the item, ...

As you created tables and charts, you probably noticed that each panel included an Add to Visual Gallery icon.   When you click the icon, you'll be prompted for a title and description. These, and a thumbnail image of your v...

ACE Analytics tables include three Export functions, available by clicking the Export icon: Depending on your application's configuration, you may see some, all, or none of the Export options. When present, they allow you to export the...

Click the Add Crosstab tab to use the feature that lets you create a crosstab (also known as a "pivot") table: Here's how to use this feature: Select the  Header Values Column , whose values will be shown  horizontally ...

Click the Add Chart tab to use the feature that lets you create charts and gauges. A separate Chart panel with its own configuration area will be displayed: Here's how to use this feature: Click the option item for the type of ch...

You can format the appearance of the data in the Table by clicking a table column header and selecting Format : These options allow you to apply, or remove, a variety of standard data formats. More information about these formats is ava...

Click the Table's Gear icon and then the Paging option item to control the pagination of your analysis table: Here's what you need to do: Choose a paging option: Show all rows will display all of the data at once in the table....

The Aggregate feature in the Table configuration area, which can be displayed by clicking the Gear icon or by clicking any table column header, lets you calculate totals, averages, and other aggregations: Here's how to use this feature...

The Group feature in the Table configuration area, which can be displayed by clicking the Gear icon or by clicking any table column header, lets you group table rows: Here's how to use this feature: Select the  Grouping Co...

This feature allows you to set the sort order of the table column data. You can display the Sort configuration area by clicking the Gear icon and then the  Sort item, or by clicking any table column header and selecting a Sort option from t...

You've selected which data columns to include in your working dataset but you may not want to see them all. The Columns feature in the Table configuration area, which can be displayed by clicking the Gear icon or by clicking any table column head...

Click the Formula tab to use the feature that allows you to add calculated columns to the data. Here's how to use this feature: Select the  Filter Column containing the values to be compared: You'll see that th...

Click the Formula tab to use the feature that allows you to add calculated columns to the data. New columns are added at the right side of the table but can be relocated by dragging them. Here's how to use this feature: Help cons...

The first thing you need to do is select the data that you'll be working with: Select some data to work with, as shown above. The data source tables and views available to you have been determined by the application developer. If multiple dat...

The basic purpose of this application is to let you see your data, so that you can understand it. ACE Analytics lets you see your data as tables and charts, in a variety of arrangements. It allows you to perform a wide range of activities with ...

Here are some example s of CDML in action in applications: Creating a 2-Line Axis Title As shown above, a simple <*br*> tag is used in the Label Title attribute to produce a 2-line title. Using Subscripts in an Axis Title ...

A special element, the Formatted Column element, allows developer to format data right in a datalayer. The element formats data from another column and places it in a new column in the datalayer. All of the formatting options pre...

In addition to the standard formats listed above, developers can enter custom numeric formats by typing them in directly. For example, one of the standard date formats is "###,###,##0.00". Developers can directly enter other combinations of val...

In addition to the standard formats listed above, developers can enter custom date and time formats by typing them in directly. For example, one of the standard date formats is "yyyy/MM/dd". Developers can directly enter other combinations of valid...

The following standard formats are available, from a pull-down list, in Studio for elements' Format attribute value: The  HTML format, when used with a Label caption, allows you to embed HTML code in the report. This be used to accompli...

The following elements have a Format attribute, which can be set to format the appearance of their data: Analysis Grid Column Crosstab Table Value Column Format Font Formatted Column Gauge Label Heat Map Column ...

Download to PDF   If you choose to include a "PDF Link" component, you should be aware of what the PDF version of the report will look like. When the report is converted into a PDF document, the internal ACE Analytics repo...

Using the Theme Editor   The ACE Analytics application uses a theme to specify its colors and appearance. If you've been designated as an Administrative User (see previous section), you may be able to use the Theme Editor tool to cust...

ACE Analytics Screen   When you launch the ACE Analytics module, you'll see this initial page: The three colored panels shown above are your menu for the different features in the application. The  icon in the upper left-hand ...