Page Structure Designers Designer “Rows / Columns” Context/Global context Time Selection

Under the term “Page structure” we mean all that information which describes what is the selection on the columns and rows, what is displayed inside the page, what is the format of the numbers, what filters and sorting rules exist, etc. If you were given enough rights by administrator, you will be able not only […]

All pages can be divided into several zones: The area which is selected with green represents all dimensions and measures. You can drag and drop their elements to areas which are selected with blue. The latter are called “designers” – they defined the structure of the page. There is the way to show or hide […]

This designer shows what is displayed on the rows and columns. It is located in the upper part of the window above the table: On our example we see that columns display time, and rows display products. Let’s show how this can be changed. Drag the item “Date.Calendar” on rows: During the movement process you […]

“Context” is the designer that limits the data which you’re watching. It is located to the left of the table: You can drag dimensions into context (the same when you do it with columns and rows). Let’s assume we are interested in sales for “Miami”. Drag the dimension “Geography” from the “Dimensions” into “Context”. The […]

The page may contain time dimension in rows, columns or context: Member selector for time dimension will have additional functionality: There are two radio buttons in the upper part of the dialog. If you select “Date Range” option you will have a possibility to set either fixed or floating time period. If you use fixed […]

This designer allows you to set the measures that will be displayed in the table. The picture below displays only one measure – the store sales: Drag the measure “Reseller Order Count” from the list of the measures (to the left) onto the “Measures” designer: As you see, the table has changed its view. Now […]

Virtual Hierarchies Swapping Rows and Columns Data Editing (Write Back) Removing Controls from Rows, Columns and Context Hiding Empty Rows and Columns Grouping of Measures Size of columns/rows Description of a Page Displaying Totals Operation “Show By” of the Context Menu

The hierarchies can be of several types: regular, attribute and parent-child: In the section “Basic Navigation on the Page” of this document we’ve already described the types of hierarchies. Let us look at the table where there are more than one attribute hierarchies: Let us join all the attribute hierarchies into ohe virtual hierarchy by […]

There is a way to quickly swap rows and columns with the help of this button on the toolbar: