Creating and Using PickLists in Intelligence Reporting

Creating and Using PickLists in Intelligence Reporting

Picklists are set up in the “Database Name” textbox under Connections in the Connector Module

Let us assume that we have created a new connection called A_Company_Consolidation and have set up the connection details in the conventional way within the Connector Module. We now navigate to the “Database Name” text box in the Properties pane and replace the existing database details with the following:

“PICKLISTM=Select from List;MyCompanyA::DataA; MyCompanyB::DataB; MyCompanyC::DataC; MyCompanyD::DataD”

This will give us a picklist showing four company database connections. Let us look at each component functions and the variables associated with it:

  • PICKLIST= Presents you with a list of all connections but only allows you to select ONE – This will obviously no do for our consolidation Management Pack exercise.
  • PICKLISTA= Will automatically run ALL the connections listed in the picklist, thus no popup list to select from. This option is great for a consolidated Management Pack that consists of all the Companies in the list.
  • PICKLISTM= Presents you with a list of all the connections and allows you the option of specifying which connections to run. Make your choice by checking one ore more of the check boxes next to your Company Names.
  • PICKLISTDSN= Presents you with a list of all connections available DSN connections but only allows you to select ONE – This will obviously not do for our consolidation Management Pack exercise but is a very useful picklist parameter to remember.
  • Select from List; – This is the text that will appear in the popup box and you can change it to whatever you like. Remember to always end with ”;” Only really useful when used with the straight PICKLIST= option, thus you can safely leave the comments out if you wish provided you still end in ; e.g. PICKLIST=; MyCompanyA::DataA; MyCompanyB::DataB;
  • MyCompanyA::DataA; – Defines your various database connections.
  • MyCompanyA:: – Is your descriptive name so anything goes – remember to end in ::
  • DataA; – is the exact database name so it has to be exact – remember to end in ;

Please note: There is no ; after the last database entry in the list

You must remember to export the report from Report Manager and then import it under the PICKLIST connection. (Right-click on the connection and select Import report under the Connector)

    • Related Articles

    • Sharing Report Shortcuts using Intelligence Reporting

      Problem When you create a report shortcut, it creates and points to a file within the AppData directory of the user that created the shortcut, which in turn points to the BICore.exe on the machine. When another user tries to run the report shortcut, ...
    • Does Intelligence Reporting and CData support TLS 1.2?

      Question A recent upgrade from Microsoft has marked End of Life for TLS 1.0 and 1.1. I am using Intelligence Reporting and/or Cdata drivers selled by Alchemex and need to upgrade my servers. How will it affect my Reporting? Support for Intelligence ...
    • Downloading and Installing Intelligence Reporting

      1. Download Intelligence Reporting To download your version of Sage Intelligence, visit our website and choose the appropriate version. a) Visit our website here: https://www.alchemex.com.au/intelligence-reporting/#alchemextrial b) Choose the ...
    • Report Distribution using Intelligence Reporting

      Distribution Settings Email is the most popular distribution channel.  By default, your Microsoft Outlook profile settings will be used by Sage Intelligence to send emailed reports automatically, however, if this is not preferable, or you do not have ...
    • Creating a Report Shortcut in Intelligence Reporting

      An LNK file allows a report to be run from a shortcut without needing to use the Report Manager Interface. LNK files need to be created using the Report Manager Interface and then associated with the Alchemex.exe program under the windows operating ...