Logi Reports - Product Advisory
June 2024
Logi Info vs Logi Reports – The Why?
As part of advancing the goal to modernize the report offerings within LeaseAccelerator, we have upgraded our software standard to Logi Reports. All current BI (Business Intelligence) reports are designed using Logi Info software. While the Logi Info version of BI reports allow users many options in selecting data elements, creating crosstabs, editing, and saving reports, the capabilities were limited by a reduced file size that has left some of the reports unusable for our larger clients. Logi Reports solves this problem by generating data comparable to the Excel limitation of one million rows.
Important Update!
The four existing ‘v2’ accounting reports will continue to be available under the Accounting tile in the Reporting workspace. These are static reports that will not be editable. New customizable templates with multiple data options will be available through the new Design Studio. Please refer to the User Guide for Design Studio for details regarding functionality.
What Did We Do?
Four of the most widely used Logi Info reports were selected for the initial transition.
Portfolio Trial Balance
Schedule: Trial Balance for a Single Month
Schedule: Account Activity Trend
Schedule: Account Balance Trend
These reports are available under the Accounting tile in the Reporting workspace in both their original version as well as with a ‘v2’ extension. The ‘v2’ reports represent the newer version. Both LAStaff and Power Users will have access to the reports by default. Access can be provided for others by utilizing the Access Control – Report Access tile.
We used these reports as a base for embedding Logi Reports. As such, the output of both versions of each report is the same. The look and feel of the output, along with actions of some of the parameters, will be different.
Parameters
A few enhancements were made to the parameter section including placement and dynamic menus.
Ledger – The Ledger parameter was moved up in the parameter list so that it is directly under the date selection(s). Ledger selection will now drive the values being presented in the drop-down menus for numerous other parameters.
Note: Changing the ledger after selecting other participant-based options will result in all dynamic parameters resetting to ‘All’.
Currency Measured In – This parameter’s drop-down menu is dependent on the combination of the Ledger and Report Using selections.
Report Using = Transactional Currency - the list includes all currencies in which schedules booked into the selected ledger have been transacted.
Report Using = Functional Currency - the list includes all currencies which were assigned as functional currencies on the schedules booked into the selected ledger.
Report Using = Reporting Currency - the list defaults to the single reporting currency configured for the selected ledger.
Show Deals Transacted In – This parameter’s drop-down menu is dependent on the above-mentioned Ledger/Report Using combination. It provides the option for a more granular subset of data.
Report Using = Transactional Currency - this field MUST be set to same currency selected in the Currency Measured In parameter. (A red warning message exists otherwise.)
Report Using = Functional Currency - the list includes all currencies in which schedules booked into the selected ledger have been transacted.
Report Using = Reporting Currency - the list includes all currencies in which schedules booked into the selected ledger have been transacted.
A few examples are included below.
Examples
Output will include only schedules whose functional currency is set to EUR and were transacted in PLN. Values will be in EUR.
When the fields Currency Measured In and Show Deals Transacted In do not agree, users will see a validation error if Report Using is set to Transactional currency.
Output will include only schedules transacted in GBP. Values will be in USD.
Deal Level Participant parameters – These parameters are now dynamically generated based on the selected Ledger. Each parameter below will include drop-down menus populated with company names/countries assigned as deal level participants on schedules booked into the selected ledger. By reducing the options in the drop-down menu to include only valid selections, the chances of a user experiencing no returned data due to invalid choices has been reduced. Deal Level Participant parameters include the following:
Entity
Lessee
Country
Business Unit
All four of these parameters will default to ‘All’.
Note: Dynamic functionality does not continue within these parameters. For example, if Entity = Company A, Lessee, Country and Business Unit drop-down menus are not further restricted to only participants associated within Company A.
Account Code (exclusive to Schedule Activity Trend v2) – This parameter is dependent on the Ledger selection. The drop-down menu will include the account code and account description assigned to all GL coding conventions within the selected ledger. Given a ledger may have multiple GL coding conventions, this drop-down menu could subsequently include multiple listings of the same account description but with different account codes.
All remaining parameters function the same in the ‘v2’ reports as they do in the original version reports.
Output
The version 2 (v2) reports provide the Data Table only. This is the equivalent of the Data/Analysis Grid, the most granular level of data, on the version 1 reports. The various crosstab sections included on the version 1 reports can be easily created via pivot tables in Excel upon exporting the data.
Below is an example of the output within the UI for the Portfolio Trial Balance v2 report.
Toolbar
A toolbar appears at the top left of the window where the results are shown in the UI. This section discusses the icons associated with the toolbar.
Note: Many pop-up windows contain a Help icon (?) in the top right corner which links directly to Logi Report published documentation. This can be useful for further explanation, however, please note the level of information included is written at a developer level.
Export icon – opens a box allowing for the selection of format types for exporting.
LeaseAccelerator is currently only supporting PDF, Excel, HTML, XML and Text (csv).
View Report Results - results are opened in the web browser if the format is supported by a plug-in for the web browser; otherwise, the report will download automatically.
Save to File System – results are downloaded.
Save to Version System – option is disabled.
When exporting a file to Excel, select both the Detail and Parameters box if the Parameters sheet is expected to be included.
To export a csv file, select Text and then More Options. A new box will appear in which “CSV Format” is an option in the Format field. When using this option, we recommend unchecking the Header and Footer box in the lower right to avoid several rows of report titles at the end of the file.
Undo icon – reverts the most recent action.
Redo icon – reapplies the most recent action previously removed.
Filter icon – allows for advanced filtering options. The example below shows a grouped filter on ACCOUNT_DESCRIPTION and AMOUNT. The result includes entries for Finance Asset over $1,000,000.
The Advanced button offers an analytical view of the query.
First drop-down menu includes all data elements (aka column headers).
Second drop-down menu includes the mode for comparison such as <, >, =, in, and like.
Third drop-down menu includes the values from the base report for the selected data element. This field can be filled in manually as in the example for AMOUNT below.
Last drop-down menu includes “And”, “Or”, and “End”.
“And” – results will include conditions for that query plus conditions for the next query.
“Or” – results will include conditions in any one of the queries.
“End” – specifies the final query condition .
Clicking the ‘X’ to the left of the data point removes the query row.
Sort icon - Opens a box allowing for the selection of the column to be sorted along with radio buttons for Ascend or Descend.
Search icon - Opens a box allowing the user to search for a specific value in a defined search field.
Zoom icon - Provides a preset list of options (percentages) for zooming in or out.
Page Controls - Determines the screen output placement within the entire report.
Full Data/Partial Data – Full Data (which is the default) will provide all data that renders for the requested parameters and filter combination. Partial Data will bring up a box in which a value can be typed that would limit the rows of data the report renders. Notice in the example below that a warning will appear to caution that the output may be incomplete since it has been limited to the number of selected rows.
Go To - Allows for toggling between the different tabs associated with the report.
Exit – Exits the main reporting section so that only the UI parameters remain.
Scheduling v2 Reports
Users can now utilize the existing scheduling functionality used for legacy LeaseAccelerator reports to schedule v2 reports.
Generate the report with the parameters you want included in the scheduled output.
-
Click the box marked Schedule This Report at the bottom of the workspace. The following box will appear:
The options and restrictions existing for other scheduled reports within LeaseAccelerator apply to these selections as well.
Run once option cannot be set for the same day.
When selecting Weekly, only one of the weekdays below the option should be selected.
Scheduling output is only available in XLSX.
-
For dynamic scheduling in which the Start and End Date of the generated report adjust to the configured fiscal calendar, use the Period parameter. Options include Prior/Current Quarter, Prior/Current Month, and the four quarters. All options relate to the configured fiscal calendar. With the Q1 thru Q4 selections, the Start/End Dates will shift to the EOM dates for the first/last month of each of the fiscal quarters within the same fiscal year in which the report is generated. When using the new ‘Period’ parameter, the ‘Run As At’ parameter should be left blank for scheduling.
Note that the Schedule Trial Balance v2 report only has one date parameter. Quarter ‘Period’ selections on this report will use the last month-end date of the specified quarter.
-
Click the Submit Schedule button. The following message will appear:
Scheduled reports will be listed under the Scheduled tile within the Reporting workspace with all other scheduled reports. Only the person who created the schedule can view the list of scheduled reports or delete the scheduled report.
In addition to being emailed to the selected individual(s), after the scheduled report has been generated it will be available for export (XLSX only) in the Systems Operations Console.
The steps outlined above are related to the following reports:
Portfolio Trial Balance v2
Schedule Trial Balance v2
Schedule Account Balance Trend v2
Schedule Account Activity Trend v2
Please refer to the recently updated LeaseAcceleratorUser Guide: Design Studio for instructions on scheduling customized reports created within the Design Studio.
Caution: The four ‘v2’ reports are NOT currently enabled with the blocker preventing reports from running while a Refresh (aka Sweep) is in progress. Please check for the Refresh banner and/or broom icon before generating your ‘v2’ report.