Basic Training
- Ada Trajer
Welcome to our training materials! We're excited to have you here and hope that this training will provide you with valuable knowledge and skills. Below, you can find the complete table of contents, this will give you an overview of what topics will be covered and in what order. Be sure to check back regularly for any updates, as we make changes or additions to the training materials.
- 1 Installing Apliqo and UX Demo App
- 2 Ad-hoc analysis
- 2.1 1. Context menu
- 2.1.1 » Subset editor shortcuts
- 2.1.2 » Drill
- 2.1.3 » Edit Mode
- 2.2 2. Sort
- 2.3 3. Column Selection
- 2.4 4. Filters
- 2.1 1. Context menu
- 3 User default settings
- 3.1 1. Homepage
- 3.2 2. Dimensions defaults
- 3.3 3. Favorites
- 4 Export
- 4.1 1. Excel
- 4.1.1 » With or without filters
- 4.1.2 » Slice / Active Form
- 4.1.3 » All Tables in dashboard
- 4.2 2. Custom format & PDF
- 4.1 1. Excel
- 5 Notifications
Installing Apliqo and UX Demo App
In this section of the training materials, we will be guiding you through the process of installing a demo application. This application will be used throughout the rest of the training materials, so it's important that you are able to successfully install it. The demo app is a great starting point for getting to know the different features and functionalities that will be covered in the upcoming exercises. It also contains numerous examples that can be used to help you experiment and try new things on your own.
Download the latest Apliqo UX installer file.
Right-click Apliqo UX installer file and select Run as Administrator
Follow the installation wizard:
Click Next button
Click I Agree button
Select:
Demo Applications
Install Apliqo Server
Click Next button
Finish installation by clicking Finish button
Ad-hoc analysis
1. Context menu
» Subset editor shortcuts
In this section, you'll explore Subset Editor Shortcuts, accessible via the table context menu. These shortcuts include, Selection (quickly change displayed elements), Remove Attribute and Attributes (replace current attribute with a new one) .
» Drill
» Edit Mode
2. Sort
3. Column Selection
4. Filters
User default settings
1. Homepage
2. Dimensions defaults
3. Favorites
Export
1. Excel
» With or without filters
Data from the view can be easily exported to Excel file. In the toolbar there is Export button with two options available for Excel file.
Excel (Load Format) - simplified file version without filters allowing you to load files into the application.
Excel With Filter Values - file version including global filters.
» Slice / Active Form
Export to Excel as a slice with DBRW’s and Subnm’s - you can now export cell references displayed in a report, rather than static values. Those references allow to dynamically pull data from the tm1 server.
Export as DBRW Active Form - allows so to export report as active form complete with expand and collapse functionality.
» All Tables in dashboard
This option gives you possibility to export all widgets visible in a dashboard in a form of a grid to single excel file. Each widget will be located in a separate tab.
Follow the steps:
Navigate to Exec Dashboard by selecting it from Dashboards folder
Click Export button
Choose All tables in the Dashboard
Make sure the file has been downloaded to your computer
Notice that all widgets were exported as grid tables into the single excel file.
2. Custom format & PDF
You can export every page created in our app to PDF without further configuration, although it is possible to customize our choice.
Follow the steps:
Click Export button
Choose Custom from the list
Inside the popup up there are three settings that need to be configured:
Select A4 Page size
Select Portrait Page orientation
Select pdf Export format
Click Export
Make sure the file has been downloaded to your computer.
Notifications
» Send a message using notifications feature
When you want to draw attention to a particular value in a certain view the best way is to send a message directly referencing that cell. In that case recipient of the message will be able to open the view with the original global filters settings.
When a cell reference is not the main priority, you can send messages directly from notification window.
Now we will look at the messages from the point of view of the recipient » Enduser
To further improve communication, each user can reply to a message sent to them by selecting Reply from the list of options available after clicking 3 dots icon (visible next to the notification).