March 2010 Newsletter

Get the most out of your investment with training

May 3rd, 4th and 5th, Monday through Wednesday, ClickBase is offering an in depth course in Milwaukee, WI. This will be a hands-on session so bring your laptop.

The first morning of the session will be devoted to end user training. Clients who wish to attend only this portion of the class are welcome to do so. The remainder of the class will be devoted to the development functions within ClickBase.

The first two days will be full eight hour sessions. The class will end at noon on the third day to account for travel home. Lunch on Monday and Tuesday will be provided by ClickBase in order for you to get the most out of these sessions.

Registration for the full session is $1,500 per attendee and includes the cost of lunch. Registration for Monday morning only is $300 per attendee. Additionally, each attendee will be given a 30 day trial copy of ClickBase to use during the class.

Click for May 2010 Training Brochure

Registration will close on April 23, so please sign up early.

Please contact your ClickBase representative to register or fill out the form to the right and please include “May Training” in the comments.

ClickBase reserves the right to cancel the class if there are insufficient registrations.

Did you know?

Mandatory, Global parameters can be used to control what users see when they log in.

When a global parameter is set up as mandatory, users must set a value for that parameter when they log into ClickBase. Used in conjunction with a drop down list and the constant, THE_USERS_NAME, the mandatory, global parameter is another way to provide row-level security on your queries.

The first step would be to define a lookup list that uses THE_USERS_NAME to control the content of the list:

SELECT territory_cd
FROM territories T, user_territories UT
WHERE T.territory_cd=UT.territory_cd AND UT.user=‘THE_USERS_NAME’

The list of territories would be limited to only those mapped to the user logged into ClickBase. The global parameter would be set up as a string lookup with the IsMandatory property set to True. When users log in, they will receive a prompt for the Territory and they must select from the values available in the drop-down list.

If you have any questions, contact .(JavaScript must be enabled to view this email address).

Get the most from your support program

If you haven’t upgraded recently, now’s the time to consider doing. Many new and enhanced features have been added to ClickBase in the past year. These are features that you get free of charge if you are current on support. Some of the highlights, of which you may or may not be aware, are:

  • Embedded spreadsheet
  • Enhanced Layout Server – support for multiple sheets
  • Printer settings for each spreadsheet
  • Drill down from dashboards
  • Compatibility with Windows 7
  • Disable workstation caching
  • Cache datasets to external disk drive

The latest release is Version 4.5.2.2. Check your version number (Help/About). If you aren’t on this version, please contact us to upgrade.

ClickBase in Action

smashboxSmashbox Cosmetics, creator of a variety of beauty products sold in premium retail outlets and on the web, rolled out the ClickBase business intelligence to their national retail sales team, thereby eliminating time consuming manual efforts to report electronically reported store sales data. As a bonus, account coverage has increased more than 100%, allowing retail account executives and regional sales managers to focus on proactive planning through weekly store results and trend analysis. The ClickBase case study describes the accelerated implementation process and the immediate ROI results.

Read the whole story…

Partner Tools

A new two and a half minute demo has been posted to the ClickBase website on the home page to provide a high level introduction to the power of ClickBase.

We’ve added more partner names to our Value Added Partner page. Is your organization listed? If not, send an email to .(JavaScript must be enabled to view this email address) and we’ll tell you how your company can be included.

ClickBase User Group Meeting

We are continuing to plan for our late summer user group meeting. The event will provide a forum for specialized training and the opportunity for you to meet other ClickBase users so that you can get even more value from your ClickBase implementation. Send us your suggestions for sessions that would help you get more from ClickBase.

Send your ideas to .(JavaScript must be enabled to view this email address) .