iPad Event URLs

I just want to post this, because I always need the event codes at different clients, then always end up having to search for it.

Info window popup from image: https://resource.microstrategy.com/support/Authoring/DisplayTN.aspx?tnkey=36031&formatted=1

Panel Selector: https://resource.microstrategy.com/support/Authoring/DisplayTN.aspx?tnkey=40581&formatted=1

For Panel Selector in Web see:

For express mode:
TN45218F

or DHTML modes:
TN42551

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"