Following are the main steps that you need to take to start analyzing your uploaded or imported data and create and save reports. Go to Analyze main tab and follow these instructions. You can try these steps also in demo Sales cube.
Drag dimensions to columns and rows
Select dimensions across which you would like to analyze your data (measures). E.g. in this example we would like to analyze who are our best customers based on sales amount.
Select just one measure
If you have very many measures then instead of dragging all measures to columns you can select just one measure you would like to analyze.
Expand and collapse, rearrange measures and dimension members
You can expand and collapse selected dimension members to show detailed hierarchy level members (e.g. start with all customers and expand into countries, regions or states, cities and individual customers). You can add or remove selected measures in columns or rearrange them with drag and drop. If added one by one, measures are displayed in the same order as they were added to the report.
All hierarchy level members and member actions
Instead of expanding hierarchy levels from a top you can select all hierarchy level members (e.g. all cities). And then you can order them by selected measure or select other available member actions (e.g. drill into lower hierarchy levels, drill across another dimension, select only one member or remove selected member, select top or bottom rows based on selected measure, filter rows by specified condition). Read also about more advanced filters using date filters and regular expressions.
Rearrange dimension member order in the report
The sequence of dimension members in rows or columns is set automatically. To rearrange them, bookmark dimension members and then add them to the report one by on in the needed order.
Another option is creating a calculated member in this same dimension with members in the correct sequence and then using this calculated member instead of All level member.
Conditional formatting on cells
Select Cell formatting to specify the range of values which should have different text or background color in the column or row.
You can also use Cell Formatting to color Text fields; then write the exact text as both Min and Max values. If you have letter-coded field values like A, B, C, D etc, then you can set A as Min and C as Max to color all A, B, Cs.
Add members to Time dimension
The dates in Time dimension are created dynamically - days are added only if there is some activity in the date. If you wish to add some analysis about future or past Time periods that you do not see in eazyBI, it is possible to add these Time members in Time dimension / All Hierarchy level members.
This option is available for the users with account Owner, User Admin or Data Admin user roles.
To add date range you should use exact date name or relative date descriptions. After clicking on OK you will see a confirmation screen with number of how many Time dimension day level members will be created; click 'Yes' to proceed and create new Time dimension members that can be used to show e.g. forecasts or comparison when not all last year data exist.
If necessary you can drag some dimensions to pages as well and then select one dimension member in page dimension to see corresponding results.
By default all dimension members will be visible and Measures will be showed only where applicable based on filter. If you wish to see only dimension members that have values for selected filters, click on the Nonempty option in the Rows section header. This will make a NonEmpty CrossJoin with selected measures and only show dimension members with Measure values with the selected filter.
Save report and toolbar buttons
When you have created report that you would like to use later then save it from report header toolbar. If you edit exiting report and would like to save it as well as keep the previous report, click the save button and give report a new name. This will save the new report as well as leave the previous report as it was. There are also other report actions in the report header toolbar, for example to rename, delete report or embed reports in other HTML pages.
There are options for report result configuration in the report results toolbar that you can try out - maximise, undo, redo buttons as well as adding of report description and exporting results.
Export and import report definitions
If you have several eazyBI accounts or several eazyBI environments (development, test, produciton) then you can export report definitions from one eazyBI account and import into another eazyBI account.
To export individual report definition then click on other report actions in report header toolbar and select Export definition.
You will see report definition in JSON format, please copy this report definition for pasting it in the other eazyBI environment. Exported report definition will also include all calculated member definitions that are used and needed for this report.
You can also export all report definitions for selected cube from Analyze tab by clicking Export reports (if you have any private reports then they will not be exported in this all reports list).
Now you can visit different eazyBI account where you would like to import one or several exported reports and click Import reports.
In Import report definition dialog paste previously copied one or several report definition export results.
If there will be any warnings then please review them and confirm that you would like to continue with report import.
After import will be done you will be able to see and use imported reports in this other eazyBI account.
If you have created many reports, then you can create report folders and organize your reports in folders. You can select a folder when saving a new report or move existing report to a selected folder.