Cizer Newsletter Issue 8, March 2006

Springing Forward with Cizer.Net ReportingSPRINGING FORWARD

In this issue:
  Cizer.Net Training Schedule
  SQL Server 2005 SSIS & SSAS
  Read, Write and Share; What's the Difference?
  Character Assessment


Two classes are now offered at the Cizer Corporate offices in Ashburn, Virginia. Registration information is included in the Course Info PDFs, or by contacting Pat Haynesworth at 703-554-1405.

Cizer.Net Reporting Training
This 4 day class will be held monthly through June and is intended for personnel who will be building both ad-hoc and production reports as well as generating queries, parameters, and templates for storing in the Global Libraries. Adding of Roles and Users, granting of permissions to other users and the Admin Module will be covered on the last day of the class for those who will be general or departmental Cizer.Net Reporting Administrators. A general knowledge of databases and SQL text is assumed for the class.

CNR 3.2 Training Info PDF


SQL Server 2005 SSIS/SSAS Training
This 4 day class is intended for personnel who will be building SSIS packages / scripts and SQL Server OLAP cubes using SQL Server 2005. Taught by members of Idea Integrationís Business Intelligence consulting practice including Brian Knight, SQL Server MVP and one of the Idea authors of Professional SQL Server 2005 Integration Services, published by Wrox; one of the text books provided as course material. Only two sessions are offered; don't miss this unprecedented opportunity to attend one of these highly sought classes.

SSIS & SSAS Training Info PDF

Read, Write and Share: What's the Difference?
CNR Reports, Queries, Parameters and Folders include a level of security called Permissions, in addition to the security that is provided in the Administrative Management Interface.

Permissions can be granted to each User and/or Role for certain Parameters, Queries and Reports available within Cizer.Net Reporting. Each User and Role can be granted the right None (no rights), Read, Write or Share to a given item. The table below demonstrates what tasks a user or role is allowed to perform based on the permission setting granted.

Read, Write, Share; What's the Difference?

Why Bother With None?
Setting permissions to None is useful when you need to exclude a small number of users that belong to a Role with permissions to an item. For example, you might have 30 Users that belong to the Analyst Role. The Analyst Role has been given Read permission to a report that returns sensitive data. Two new employees will be added to CNR as Users with the Analyst Role, but until their probation period is complete, they are not allowed to view this sensitive data. Rather than take away the Read privilege of the Analyst Role and have to then grant it to each of the 30 Users who need to run this particular report, you can simply exclude the two new Users that also belong to the Analyst Role by setting their permissions for this report to None.

What a Character!
So the new sales associate would like her Cizer.Net logon ID to be $4ME. How cute, you tell her, but it canít be done. Itís not that vanity login IDs are against company policy, but Reporting Services does not allow certain characters, such as the dollar sign, to be used in a folder name. So whatís that got to do with her Cizer.Net logon ID?

When a user is created in Cizer.Net, SQL Server Reporting Services simultaneously creates a user folder of the same name. When a user runs a report, a copy is saved in their Reporting Services folder. Reporting Services does not allow any of the following characters to be used in a folder name:

; ? : @ & = + $ , \ * < > | " / ,

If you try to create a Cizer.Net User containing any of these characters the following message will display in red below the toolbar: Reporting Services error creating directory for the user. Hopefully your new sales associate will be satisfied using these characters in her vanity password, which isnít stored by Reporting Services.
Need help? Contact Cizer Tech Support, M - F, 8:30 - 5:30 EST

The CNR 3.2 downloadable zip files are now posted on the Customer Resource page for which you have a Customer Login ID and Password that was emailed to you at the time of purchase. We recommend that you download the which has the various .msi files for full and upgrade installation, as well as the documentation and release notes (the Security Extension for Outside Access, Custom Security for Single Sign-on, and URL Extension folders are included in the product .zip files). Other file sets are also available for smaller downloads if you prefer. If you cannot locate the email containing your Customer User ID (your email address) and Password which was sent at the time you purchased CNR, please send an email to requesting a resend of that information.

To access the latest version of CNR, go to the home page and click on the Customer/Partner Sign-on link (just above the Microsoft Partner logo). You will be redirected to the sign-in dialog box. Enter your Login ID and Password to access the Customer Resource page with all the most current downloadable files. This page is only for those who have actually purchased Cizer.Net Reporting. Your current Permanent Activation Key will continue to work with this new version of CNR, and if you run the upgrade script, you will keep all the information (Users, Reports, Data Sources) currently stored in the software database.

If you are still in Evaluation mode, you'll need to request a new Eval copy by filling out the Eval Request form accessed from the home page / Get Free Eval link at the top left. This will be the full copy of CNR 3.2 but you will be restricted to a 30-Day evaluation key. This zip file also includes all the documentation but it does not include the Security Extension for Outside Access or the upgrade scripts.

Comments and suggestions on topics for this newsletter can be sent to

If you wish to be removed from our Newsletter distribution, email
Cizer and Cizer.Net Reporting are trademarks of Cizer Software Corporation.   Patent Pending.