This article describes the creation of a Jedox view, also called an OLAP view.
Open a new spreadsheet in Excel or in Jedox Web. Then click the command “View” (Jedox Ribbon in Excel) or Query → Paste view (Jedox Spreadsheet) to open the Paste View dialog window:
Select a database and the cube you want to use for the view.
Then select the dimensions and elements that you want to see and how they should be arranged. You can move the dimensions by dragging and dropping them from the page headers area (current location) to the row titles or column titles area.
For example, if we move the Products dimension to the row titles area and the Regions dimension to the column titles area and click Paste, the following view appears:
You can manipulate the view in a number of ways:
- Doubleclick B7 once to expand the Product hierarchy
- Change the year to May in D3
- Change All Versions to Actual in F3
- Change Units to Turnover in G3
You can select multiple elements in the page headers area (cells D3:G3). For example, in the screenshot below, we selected in cell E3 the years 2014, 2015, and 2016:
After selecting multiple elements, you can select among the functions Sum, Minimum, Maximum, or Average:
Sum: default aggregation type; calculates the sum of selected elements in the current view.
Maximum: shows only the highest value from selected elements in the current view.
Minimum: shows only the smallest value from selected elements in the current view.
Average: calculates the average value of selected elements in the current view.
If multiple elements have been selected, Drill Through and Drill History are not possible.
To continue our example from above, we applied the Maximum function to our selection and received the following Jedox view:
The spreadsheet now displays the maximum turnover in May for the years 2014, 2015, and 2016. Such calculations are also known as calculated members and ad-hoc client-side rules.