Report Center

Avatar
Intlock Team
Follow

Contents

Gain a fresh insight into your website with a wide range of usage reports and dashboards. In the Report Center, you can easily create dynamic reports that feature charts and tables, either by making use of one of CardioLog’s existing templates or by building a report from scratch. You can schedule a report to run automatically every day, week or month, and you can preset permission to view and/or edit a certain report or dashboard to ensure that the right person has access to the right data. It’s also possible to send a report to a predetermined distribution list, and to share it by exporting it to various formats, including SharePoint web parts.

How to Create a Report

  1. In the Navigation pane, under Report Center, click a folder in the Reports tree, and then select New Report… (You can first create a Reports folder by selecting New Folder...)

    6_Create_new_report.png
    Create a new report
     
     
  2. While in the New Report dialog, select the Blank Report option and click Next:

    Create_blank_report.png
    Create a blank report


  3. Enter the Name and Description fields, select the number of columns for the report, and then click Next.

    To display dates in the Name and Description fields, use the following variables: $now$, $today$, $lastday$, $thisweek$, $lastweek$, $thismonth$, $lastmonth$, $thisquarter$, $lastquarter$, $thisyear$, $lastyear$

    Report_details.png
    Report details


  4. Schedule the report: according to a predetermined time interval (day, week or month), then click OK.

    Report_scheduling.png
    Report scheduling


    ad-hoc_report_generation.png
    The ad-hoc report generation option


  5. The blank report is now in Edit Mode. When a report is in Edit Mode, you can add widgets to it.
  6. Click Add in the Top Toolbar and select a widget to add to the report (for a complete list of available widgets, see the Reports Gallery).

    6_Add_visual_controls.png
    Add widgets to a report


  7. The following actions are available in the Top Toolbar while in Edit Mode:

  8. Upon analyzing the report, it is possible to create a static version with real time data (by selecting Generate Report) or to wait until the report is automatically generated according to the report scheduling. As long as there are no static versions for the report, it will be displayed in Edit Mode (if there are edit permissions for the current user) if it is selected from the Reports tree. Otherwise, the latest static version will be displayed.

    6_A_static_report.png
    A Static Report


  9. The following actions are available in the Top Toolbar when the most recent report version  is displayed (static mode):
  10. Edit the time frame for a static report by clicking the Date Range link on the top right of the report.  Select the desired date range and time interval and click OK.

    Re-creation_of_the_report_customized_date_range.png
    Re-creation of the report with a newly selected date range


  11. To remove the report, including all previous versions right click the report and select Remove from the Navigation Pane. To remove only the previous versions of the report, select Remove Historical Data.
    The report’s Historical Data refers to all prior versions which are saved in the system. If a version exists for a selected date range, the actual saved version is displayed, and no query is submitted to the database. This is in order to save system resources and shorten the waiting time for the report.
  12. To modify the report properties (report title, description, number of columns and scheduling type), click the report and select Properties on the Navigation Pane.
  13. To view the report in a new window (without the CardioLog scheme) on the Navigation pane, click the report and select Browse. 

Tips for efficient report creation

The amount of resources needed for report processing depends on the number of scheduled reports, the number of database queries for each report and the timeframe selected for the reports (reports for 365 days require more resources then reports for 30 days). To ensure optimal operation, make sure you follow these recommendations: 

  1. Number of Queries (Widgets) per Report - Limit the number of widgets in a report to a maximum of 6.
  2. Number of Results (Rows) per Query - Display only the top 100 rows in tables.
  3. Report Filters - Define a black list rule when possible and avoid using the exclude (!) condition in the report filters.
  4. Report Scheduling Type - Make sure that the report scheduling type (daily/weekly/monthly) is in correspondence to the report date range, for example:
    When a report’s date range is “Last Month”, schedule it to run once a month.
    When a report’s date range is “Last 30 Days”,schedule it to run once a day.
  5. Report Type (“By URL” Widgets) - Avoid using the “By URL” widgets (for example - "Events" (Page Views by URL) unless needed. When creating a report for a web site, search the website in Object Explorer (Analysis Center), and use the appropriate tree item as the source of your report.
    Use the “By URL” reports only for: 
    • Web sites which do not exist in Object Explorer
    • Retrieving URL Parameters in the report
    • Tracking banner and button clicks
    • Tracking custom events
  6. Number of Scheduled Reports - Delete unused scheduled reports. Use the CardioLog Analysis Center for real time queries or to create an Ad-Hoc report and generate it manually on demand.
 

How to Copy a Report

 This useful feature enables copying an existing report and applying it to a selected item from Object Explorer.

  1. On the Navigation pane, under Report Center, click a report from the Reports tree and select Copy.

    Copy_report_dialog.png
    Copy report dialog


  2. In the Object Explorer dialog, add the portal item for the copied report, then click OK.

     Object_Explorer_dialog_suite.png
     Object Explorer dialog
     

  3.  In the Choose Location dialog, select a report folder where the copied report will be displayed.
  4. The copied report will be displayed in its new location in the reports tree.
 
 

How to Create a Report based on a Template
  1. On the Navigation pane, under Report Center, click a folder in the Reports tree and select New Report. To initially create a Reports folder, select New Folder.
  2. In the New Report dialog, select the New report form template option, and then click Next.

    Report_from_template.png

  3. Select one of the available templates.

    Report_select_template.png
  4. Continue with the standard report creation steps

For more information see "How to create report templates".

 

How to Set Permissions for a Report

Permissions are available in CardioLog installations which include integration with Active Directory.

Members can set view, edit (Edit Mode), modify (modify report properties) and delete permissions for a specific report for any user or group in Active Directory. By default, the report creator has full control permissions, while view permissions are given to everyone. Additionally, new users and groups can be added,  users and groups can be deleted, or members can modify existing permissions.

  1. In the Navigation pane, under Report Center, click a report from the Reports tree and select Permissions…

    6_Report_Permissions.png
    Report Permissions menu option


  2. In the Permissions dialog, click Add and enter the user/group name and the desired permissions.
    This dialog allows members to Assign View, Edit, Remove and Modify permissions. User permissions precede group permissions. To assign permissions for all users, use the default “All” group.

    Permissions_dialog.png 
    Permissions dialog


  3.  When entering the user/group name, click Ctrl+K to search for users/groups.
  4. Select the preferred results and click OK.

    Select_Users_and_Groups_dialog.png 
    Select Users and Groups dialog
     

  5.  Click Save to save the permissions.

How to Export a Report to Excel

You can export a report to CSV file format.

  1. Click Export to CSV in the Top Toolbar.
  2. In the File Download dialog, click Open or Save.
 

How to Export a Report to PDF

You can export a report from the Report Center to PDF format for printing.

  1. When the report is in View Mode, not Edit Mode, click Export to PDF in the Top Toolbar:

    Export_to_PDF.png
    Export to PDF option


  2. In the File Download dialog, click Open or Save.

How to Export a Report as a Microsoft SharePoint Web Part

A Web Part is a component which displays data in a Microsoft SharePoint Portal. You can create a Web Part that displays a report from Report Center and add it to any page in the portal.

  1.  When the report is in View Mode, as opposed to Edit Mode, click the Create Web Part button on the Top Toolbar.

    Create_Web_Part_option.png 
    Create Web Part option


  2.  Once the popup message is displayed, select create a Web Part with a CardioLog frame style (scheme).
  3.  In the File Download dialog, click Save.

How to Send a Report via Email

You can send an email with a unique link to the report, and the data in the report will be automatically refreshed.
  1. Click Send To in the Top Toolbar.
  2. In the new email window, enter an email address and click Send.

How to Set an Email Distribution List for a Scheduled Report

Once a new report version is created, it is possible to send an automated email to a predefined distribution list. This email includes a unique link to the new report version, and the data in the report is automatically refreshed.
Upon browsing the report link, the latest generated report (based on the report type) is the one displayed.

  1. Open a report in View Mode and click the Distribution List button in the Top Toolbar:

    Distribution_list_button.png

     
  2. Enter an email address in the text box and click the Add button to add the address to the distribution list. Click Ctrl+K to select from a list, then click Save.

    Distribution_list.png

How to View a Report from SharePoint's "Site Actions" Menu 

To view usage reports from within your SharePoint portal, via the "Site Actions" menu, install our CardioLog Usage Reports SharePoint Feature.
The site action feature can be deployed on the entire farm or for specific web applications.

The “CardioLog Usage Reports” SharePoint Feature which enables the submission of usage queries directly from your SharePoint portal.
  1. The CardioLog system administrator creates published report templates. These templates are available from the portal pages.
  2. Each portal page displays (under "Site Actions") a link to CardioLog Analytics usage reports. Clicking on the link will generate a usage report for your page.

    By default, access to the report is denied for users and groups who are not assigned with the view role for the SharePoint page.

     sharepoint_siteactions.png 
    Submit queries directly from portal pages with the “CardioLog Usage Reports” SharePoint feature
     
  3. Select the desired report template and date range in order to run a usage report for the page you are visiting. The report is displayed in a new browser window.
     
    Mezer_02-06_09-56-36.png 
    Select report template option 
 
For more information click here.
 
Back to top
 
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk