Excel Client:Analyzer

The Analyser is an interface for defining data. The Analyzer allows you to select databases and analyse them via drag and drop in a browser.

The Object Tree

The object tree is the dropdown list that is used for selecting the data source or report which will serve as the basis for a report. The object tree is located in the upper left corner of the Analyzer.

Error creating thumbnail: File missing Object tree, initial view

Error creating thumbnail: File missing Object tree, opend

The object tree has three main sections:

1. My Reports: This is where users can save their reports. This folder is saved on a per-user basis. The saved reports can only be viewed by the user who saved them.
   
2. Public Reports: All data sources/reports in this folder are visible and available to all users.
   
3. Data Sources: This folder lists all objects that can serve as the basis for a report. The objects are grouped according to connectors. This folder is visible only to the users Manufacturer, PowerUser, and Partner. CoPlanner standard users do not have access to this selection. Objects in this folder must be made available by users with access to this folder. This is done by creating a link in the Public Reports folder.
   

The object tree contains two different types of objects

• Data Sources: These objects do not have defined filters or axis dimensions and do not use templates. They contain the permitted filters and axis dimensions and serve as the basis for creating reports.

The following icons are used for Data Sources:

CoPlanner Cube
OLAP Cube
CoPlanner Tables

• Reports:Reports can be saved either in My Reports or in Public Reports. These folders are designated by the predefined filters or dimensions that were used on the axes. Reports are marked by the icon .

Using the object tree

As we have seen, all data sources are accessible only to the users Manufacturer, PowerUser, and Partner. These data objects are made available by the creation of an entry for the desired data source in the Public Reports folder. When a user creates a report, this report can be saved either in My Reports or in Public Reports. Access to the contents of the object tree can be facilitated by creating folders. Users with the appropriate user rights can create and delete views in the corresponding folders and can also create and delete subfolders.

Sharing data source for all users

This option is only available to the users Manufacturer, Partner, and PowerUser. To share a data source, please select the data source, left-click on it and drag it to the place in the object tree where you want it to be available (Public Reports or a subfolder of Public Reports). The folders will close at the start of the dragging process. The folder names of folders that are available for dragging data into will be shown in black, while folders that are not available will be greyed out. The current folder, i.e. the folder into which the data was dragged, will be shown with a yellow background.

Error creating thumbnail: File missing

Renaming folders

Right-click on the folder you want to rename. This will display a context menu. Select the “Rename” menu item. You can now give the folder a new name. The folders My Reports, Public Reports, Data Sources, and the subfolders of Data Sources cannot be renamed by users.

Error creating thumbnail: File missing

Hint  Context menu: Only those commands will be available that the user is permitted to use.

Creating a new folder

Right-click on the folder in which you want to create a new folder, and select “New folder” from the context menu. A new folder will be created, and you can now assign a name to the new folder.

Error creating thumbnail: File missing

Deleting a report or a folder

Right-click on the report or folder you want to delete. A context menu will appear. Select “Delete”. If the option to delete is not available (i.e. if it cannot be selected), then you do not have permission to delete the report or folder. If a folder contains subfolders or reports, these must be removed before the folder can be deleted.

Error creating thumbnail: File missing

Functionality of the Analyzer

When the Analyzer is started, it initially opens with no data object selected.

Error creating thumbnail: File missing

When working with the Analyzer, the first step is to select a data object from the tree located in the upper left-hand corner of the Analyzer.

Error creating thumbnail: File missing

After you have selected a data object, the dimensions that can be used as axis dimensions or filters will be available in the right-hand pane.

Additionally, the measures that can be displayed or hidden will be available.

Elements – dimensions and measures – that do not have an associated icon () will not be available here. Measures without an icon will not be shown, and dimensions without an icon will be ignored.

You can rotate the axes by clicking on the icon. To transfer only the measure dimension to the opposite axis, press and hold the Ctrl key.

To use a dimension as an axis dimension, drag the dimension to the position of the desired axis and drop it there.

Error creating thumbnail: File missing

To use a dimension as a filter, drag the dimension to the filter area instead of an axis.

Error creating thumbnail: File missing

If you want to display fewer measures, simply click on the measure you wish to hide.

To display the hidden measure again, click on it again.

You can add dimensions as filters without using drag & drop. The procedure is identical to showing or hiding measures, except that, in this case, the dimension must be selected.

If a dimension was added as a filter, the dimension can be removed again by double-clicking on it in the filter area.

Error creating thumbnail: File missing

You can also use filter dimensions as axis dimensions by means of drag & drop. To do so, simply click on the dimension in the filter, hold the left mouse key, and drag the dimension to the desired axis. When the desired position is highlighted, release the left mouse key. The dimension will be inserted and will now serve as a dimension on the axis.

Error creating thumbnail: File missing

To change the order of the measures (fields), click on the measure you want to move and drag it to the desired location. A bold black line will display the current position where the measure will be inserted when you release the left mouse button.

Additionally, you can change the order of the measures in the “Select measures” dialogue. Open the dialogue by clicking on the “Select measure” button. Now change the position of the selected measure using the Up and Down arrow icons.

Error creating thumbnail: File missing

Dimensions can be positioned on the axis (to the left or right of a previously inserted dimension), or they can replace other axis dimensions. The border around the dimensions on the axis shows the position to which the dimensions will be moved.

Error creating thumbnail: File missing

Error creating thumbnail: File missing

Error creating thumbnail: File missing

To edit the definition of the axis, right-click on an axis dimension to display a context menu.

This context menu consists of the following elements:

• Current dimension element
• Dimension of the element
• Total axis

Context menu

Description of the context menu item

Menu item	Description
Isolate element	The current element will be isolated. In other words, only this element of the dimension will be displayed on the axis.
Hide element	The element will be removed from the axis dimension.
Isolate/expand element	The current element will be isolated. Additionally, all sub-elements will be displayed on the axis. (This menu item is available only in the case of elements that contain sub-elements.)
One level up	The element above the current element is displayed along with its subordinate nodes. (This menu item is available only in the case of elements that are not root elements.)
Open to level	This menu item provides additional menu items, depending on the number of levels in the dimension. Select a menu item to open the dimension up to the selected level.
Select level	This menu item provides additional menu items, depending on the number of levels in the dimension. Select a menu item to open the selected level.
Select elements...	The “Select elements” dialogue allows you to select the elements that will appear on the axis. For a detailed description of the dialogue, please refer to the Select Elements Dialogue.
Show leaf elements only	Shows only those elements on the axis that do not contain sub-elements.
Break dimension structure	Removes the visualisation of the level.
Suppress null values	Shows only those dimension element that contain a value. This setting will affect all dimensions on the selected axis.
Turn axis dimensions	Switch the line and column dimensions
Reset	The dimension is reset to its original state. This corresponds to the command “Open to level 1”.
Copy	Copies the active cell of the value area
Paste	Not available in the Analyzer

Ribbon

Button	Action
	Refresh: Reloads data from the server.
	Suppress null values (displays only lines and columns that contain a value unequal to zero in at least one cell).
	This menu item allows you to insert previously defined style sheets for this data definition. By selecting the Style Sheet Editor, you can define and then apply a template. Reset causes the style sheet to be removed from the view.

Style sheet Editor

The Style Sheet Editor allows you to create style sheets. You can save your style sheets to reuse again later.

“Select elements” dialogue

The “Select elements” dialogue allows you to select the elements that will appear on the axis. You can select individual elements only, or, if the selected dimension contains sub-elements, include these in the selection.

To select an element, single-click on the little black box symbol to the left of the element. To display sub-elements, click the box again. To cancel the selection, click the box a third time. Quick reference:

• 1 click: Select element
• 2 clicks: Include sub-elements
• 3 clicks: Cancel selection

Error creating thumbnail: File missing “Select elements” dialogue: Selection includes sub-elements	Error creating thumbnail: File missing : “Select elements” dialogue: Selection excludes sub-elements
The double check mark indicates that the sub-elements will be selected as well.	Only the marked element will be selected.

Error creating thumbnail: File missing	Right-click on an element of the tree to display a context menu. The context menu helps you to select the elements you need. Isolate element: Only the element on which you right-clicked will be selected. Select: Use the flyout menu to select the required elements. Deselect: Use the flyout menu to deselect the required elements.
Error creating thumbnail: File missing	Flyout menu items for selection: All: Select all elements in the dimension Following elements of same level: Select all elements of the same level, starting with the element on which you right-clicked Following elements of all levels: Select all elements of the same level and their sub-elements, starting with the element on which you right-clicked
Error creating thumbnail: File missing	Flyout menu items for deselection: All: Deselect all elements in the dimension Following elements of same level: Deselect all elements of the same level, starting with the element on which you right-clicked Following elements of all levels: Deselect all elements of the same level and their sub-elements, starting with the element on which you right-clicked