...
The system highlights the 16 Cube request screens currently available as shown below.
Scroll Scroll the menu tree to locate the Cubes that are of interest to you. You can then use the right-click menu to add those menu choices to your favorites tab or the AMS Client’s toolbar.
|
|
Understanding Cube Request Screens
...
- Requesting more Dimensions increases your flexibility in viewing your data
- But requesting more Dimensions causes the server to take longer to make your Cube and will result in a larger, slower Cube.
- Some Dimensions have few values, and some have many. For example, you may only have 5 Regions, but you may have thousands of customers. The more values a Dimension has, the larger your Cube will be and the slower it will operate. So requesting the customer Dimension when you really are only interested in totals by region could waste your time.
- Grouped Dimensions are powerful but perform poorly when composed of one or more Dimensions with lots of values. For example, a Group Dimension containing thousands of customers or thousands of individual orders may produce a nearly un-usable Cube. In extreme cases, the server will fail to produce the Cube, or the Cube viewer will malfunction when asked to display such a bulky Grouped Dimension.
- Therefore, request the Dimensions you need and leave out those you do not.
- The request screen may offer Dimensions that your company does not use. For example, you may be offered “region” as a Dimension, even though your company does not use regions. In that case, the region Dimension will not be useful to you if you request it.
- When experimenting with building and using a Cube, you may want to limit the volume of data requested while learning about the Dimensions that are available. For example, use a restrictive date range or limit your request to a single, small state or sales region. Once you become sure of the Dimensions, you can increase the volume of data. This approach will save you time.
Each Cube request screen offers Ungrouped Dimensions that are unique to it. Dimension numbers may not refer to the same dimension on two different request screens. Dimensions are specified with a two-digit number. You can use the handy lookup tool to locate the Dimension you want. Activate the lookup by clicking the glyph to the right of the field with your mouse... ...or use the F12 key or the Alt- DownArrow keys. Make your selection by typing and pressing enter or by highlighting a dimension with your mouse and selecting it. | ||||||
Note that the fields used to hold selected dimensions is of no consequence. The system will process each dimension number, regardless of where they appear on the screen. Notice that there are three areas on the screen where you can select Dimensions. They are labeled Group1, Group2, and Ungrouped. Let’s discuss Grouped Dimensions. |
|
Group Dimension
A Group Dimension also called a hieratical dimension, is a single Dimension containing nested “regular” dimensions in a pre-arranged order. An example would be a Group called “Areas,” which contains Regions, States, and Cities.
...
The system shows the results of your request in the AMS CUBE viewer. Its default display appears as described below.
(1) The file path and filename of the CUBE using the file extension .YAC. In this example, C:\Ams\Ams Client\Users\Ernie\THOR2012\DEMOCART\InBox\D538965–A.YAC. When you close the Cube, the system gives you options to save or delete this file.  Saving the YAC cube file in any manner enables you to reopen the Cube quickly without having to resubmit your screen request.
(2) CUBE Viewer Toolbar used to make a spreadsheet, send data to Excel, view a report, etc. Hover your mouse over each control to display its tooltip description. (3) Dimension Bar containing your requested Cube dimensions, displayed as moveable data objects. It is the parking place for dimensions that we don’t want to be displayed as a row or column just now. (4) The Column Dimension Bar. Drag a dimension into this area to define the dimension as a column. (5) Row Dimension Bar. Drag a dimension into this area to define the dimension as a row. (Note, the word Rows shown in the image does not actually appear in the Cube viewer and is for purposes of this documentation only.) (6) Default Measures, as defined, and turned off and on by the Measure Manager. Default measures will differ, depending upon the AMS module in which it is defined. |
|
Functional areas of the Cube viewer
...
Use the controls appearing in the bottom left corner of the Cube to launch the two versions of the Measure Manager.
|
|
Default Measures
By default, three measures appear in our example Wholesale Orders Cube.
Default measures will vary between different cubes, depending upon the AMS module in which they are defined. |
|
Checkmarks - Green or Red
...