• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

Learn how to check your Containers in the Sage Intelligence Connector module

By admin on July 24, 2018April 19, 2019

Being able to check if the components of a report are functioning as expected while working with them can help provide a smooth workflow and save time dealing with problems later in the report creation process.  Also, if you do come across errors in a report, being able to test its components easily allows for carefree troubleshooting.

In the Sage Intelligence Connector module, Containers define the datasets that you want for a report.  Once one has been added and the query for it written, two options are provided to check whether it’s working as desired.  These are Check/Test and Sample Data.

Check/Test

Check/Test runs the query of a Container against the database to see if it executes correctly.  To do this, select the Container you want to test and click Check/Test on the Home tab on the menu ribbon.  You can also right click on the Container and select Check/Test from the context menu.

If successful, you’ll receive a Success message.  This provides confirmation that the Container has no errors. It’s always good to run after making changes to a Container’s query or properties.

If the Container does have an error, then a Check Failed message will be shown with a description of the type of error to help with trouble shooting.

Sample Data

Running Sample Data for a Container will display a sample of the information returned by its query.  This is usually limited to the first 50 rows.  To do this, select the Container and click Sample Data on the Home tab on the menu ribbon.  You can also right click on the Container and select Sample Data from the context menu.

This is useful to check that the query is bringing back the desired information or to investigate the tables in your database to determine which ones to use in a report.

In addition to this, Check/Test and Sample Data can be executed against other objects in the Connector.  For example, Check/Test can be run against a Connection to make sure that it’s accessing the database correctly, and Sample Data can be run against individual Expressions of a Container to see what data they return.

To see if Check/Test or Sample Data applies to an object, select the object in the object window.  If either one applies, it will become active on the menu.

Making Check/Test and Sample Data a standard part of your report writing skill set can go a long way to ensuring trouble-free report writing, saving you time.

The post Learn how to check your Containers in the Sage Intelligence Connector module appeared first on Sage Intelligence.

Source: Sage Intelligence

Post navigation

Sorting data in a PivotTable with Microsoft Excel
Using Wildcards to make finding or replacing data in Excel quicker and easier

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd