What DSN is my iServer connecting to?

The Problem:

• You have multiple Metadata DSNs setup on your server
• Now you need to find out which one your iServer is connecting to

Collation Conflict Error

We got the following error at one of our clients:

Report: Status: Execution failed Error: SQL Generation CompleteQueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42000:468: on SQLHANDLE] ..... Cannot resolve the collation conflict between "SQL_Latin_General_CP1_CI_AS" and "Latin1_General_CI_AS"

This error occurred on one of our reports after we switched our DW database to a different server.
We are running on MSSQL 2008 R2.

Advanced Custom Grouping based on Prompt

How do you display prompted elements on a report, and at the same time display all those not selected as a single Element called "Other"

Display all days to a specified day

A Bit of a confusing title I know. I found it quite interesting once I figured out what the technical note was talking about.

TN: 13932 shows how you can display all days in a month up until a single filtered day, instead of having to use a "between" or "multi value" filter.

Not a function that I'm using currently, but it might be useful in the future, or might be a good approach to use on a different problem.

Setup MicroStrategy on your BlackBerry

First off, I'm using a BB Bold 9700. Got it working on there, so now I want to do it from scratch on a Bold 9000 and see if I can document the process.

Steps I'm covering in this post:

1. Make MSTR Mobile Client available for download
2. Connect to Intelligence server