![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_1_en.png\")
<\/a><\/p>\n<\/p>\n
In expanded lists of elements, it is possible to use a context menu:<\/p>\n
- \n
- for an attribute hierarchy<\/li>\n<\/ul>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_2_en.png\")
<\/a><\/p>\n<\/p>\n
- \n
- for regular hierarchies<\/li>\n<\/ul>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_3_en.png\")
<\/a><\/p>\n<\/p>\n
Moreover, a quick search in the list of elements in the context is possible:<\/p>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_4_uen.png\")
<\/a><\/p>\n<\/p>\n
For example, now it is easy to select a group in the list of elements (or alternately specified elements), which is essential for the attribute hierarchy. For this, enter a keyword in the search field and use the context menu to mark all the elements corresponding to the group:<\/p>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_5_en.png\")
<\/a><\/p>\n<\/p>\n
As a result, in addition to those previously selected, all Road* elements will also be selected in the list:<\/p>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_6_en.png\")
<\/a><\/p>\n<\/p>\n
If you wish, you can now only work with this set of elements.
\nFor this, enable Offline mode<\/strong> in the context for this hierarchy, in the form for selecting items in the Options<\/strong> tab:<\/p>\n![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_7_en.png\")
<\/a>![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_8_en.png\")
<\/a><\/p>\n<\/p>\n
After that, the list of elements in the context will be as follows:<\/p>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_9_en.png\")
<\/a><\/p>\n<\/p>\n
<\/p>\n
SQL-query editor for \u00abInteractive Dashboard\u00bb<\/h5>\n
If you select the way to connect to the Query data source in the Query Editor form, after you add all the necessary tables and views in the Query Builder form, you will have the possibility to edit the automatically generated SQL query:<\/p>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_10_en.png\")
<\/a><\/p>\n<\/p>\n
For this, check the Allow Edit SQL check box and edit the SQL query that will be displayed in SQL area:<\/p>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_11_en.png\")
<\/a><\/p>\n<\/p>\n
Support Views for \u00abInteractive Dashboard\u00bb
\nIt is possible to use views in the admin module in the Query Editor<\/strong> form for \u00abInteractive Dashboard\u00bb in Query Builder:<\/strong><\/p>\n![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_12_en.png\")
<\/a><\/p>\n<\/p>\n
<\/p>\n
Support Stored Procedure for Data Source<\/h5>\n
It became possible to use the stored procedure to retrieve the data in the admin module in Query Editor<\/strong> form for the \u00abInteractive Dashboard\u00bb:<\/p>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_13_ren.png\")
<\/a><\/p>\n<\/p>\n
As the next step, you can define the specific parameters for the stored procedure:<\/p>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_14_en.png\")
<\/a><\/p>\n<\/p>\n
<\/p>\n
Client\/Server Mode for \u00abInteractive Dashboard\u00bb<\/h5>\n
For SQL data sources, it is possible to enable \u00abClient Mode\u00bb to work with data. To enable it, you have to disable the server mode for the selected data source (the server mode is set by default). For this, use the Server Mode<\/strong> button, which is located on the toolbar:<\/p>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_15_en.png\")
<\/a><\/p>\n<\/p>\n
In server mode, the operations associated with the data are performed on the server side. For example, when a user applies filtering to an element of a dashboard panel, the dashboard automatically requests the necessary data by sending a query containing the corresponding SELECT with the specified WHERE clause.
\nIn client mode, the operations associated with the data are performed on the client side (reporting module\/admin module). In this mode, a compressed snapshot of the aggregated data is loaded into the client’s memory. This reduces memory consumption and improves the speed of data processing operations on the client side using several methods: data compression, various data groupings, multi-stream algorithms, and so on.<\/p>\n<\/p>\n
MDX Statistics for Queries by Elements<\/h5>\n
MDX-statistics for the following elements was added:<\/p>\n
- \n
- queries on elements in the form of elements selection:<\/li>\n<\/ul>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_17_en.png\")
<\/a><\/p>\n<\/p>\n
- \n
- at elements list in the context:<\/li>\n<\/ul>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_18_en.png\")
<\/a><\/p>\n<\/p>\n
- \n
- for auxiliary queries on element lists.<\/li>\n<\/ul>\n
This statistic is displayed in the admin module in the MDX Statistics<\/strong> tab:<\/p>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_19_en.png\")
<\/a><\/p>\n<\/p>\n
<\/p>\n
Password Settings<\/h5>\n
In the admin module in the Reports Users<\/strong> tab, you can set the conditions for the complexity and password expiration:<\/p>\n
- \n
- for all the users:<\/li>\n<\/ul>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_20_en.png\")
<\/a><\/p>\n<\/p>\n
- \n
- for each and every user separately:<\/li>\n<\/ul>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_21_en.png\")
<\/a><\/p>\n<\/p>\n
Important<\/strong>: password settings that are user-specific are of the highest priority.<\/p>\n
The following parameters will be available in the appeared form:<\/p>\n
- \n
- The user must change the password at the next login to the system – the user must change the password specified by the administrator;<\/li>\n
- The validity period of the initial password specified by the administrator – the administrator sets the validity period of the initial password (the number of months or the end date);<\/li>\n
- Validity period – the validity period of the password (the number of months or the end date);<\/li>\n
- Length without special characters (at least) – length of the password, the password must include 3 of the 4 following groups of symbols: uppercase letters (capital letters), lowercase letters (small letters), numbers, special characters (! @ # $% ^ *? _ ~ – \u00a3 ().,)<\/li>\n
- Length with special characters (at least) – the length of the password with special characters, the password must include 3 of the 4 following groups of characters: uppercase letters (capital letters), lowercase letters (small letters), numbers, and mandatory special characters (! @) # $% ^ *? _ ~ – \u00a3 ().,).If the user’s password does not meet the conditions specified by the administrator in password settings, the user will be prompted to enter a new password that must match the password settings when logging into the reporting module:<\/li>\n<\/ul>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_22_en.png\")
<\/a><\/p>\n<\/p>\n
<\/p>\n
Search in List of Reports in the Report Module<\/h5>\n
For reports users in the List tab, a quick search of the required report in the report tree was added:<\/p>\n
![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2018\/06\/56_23_en.png\")
<\/a><\/p>\n<\/p>\n
<\/p>\n
Highlighting of Hierarchy with All Elements of the Level<\/h5>\n
On the report page, the user can easily define which of the selection contains only all elements of the level. Now such selections are colored in a certain color:<\/p>\n
- for each and every user separately:<\/li>\n<\/ul>\n
- for all the users:<\/li>\n<\/ul>\n
- for auxiliary queries on element lists.<\/li>\n<\/ul>\n
- at elements list in the context:<\/li>\n<\/ul>\n
- queries on elements in the form of elements selection:<\/li>\n<\/ul>\n
- for regular hierarchies<\/li>\n<\/ul>\n