Using Photo Uploader widget

After playing around with the photo uploader widget for a while, I decided to document the procedure I used for posterity...

Trigger MicroStrategy Events from ETL

Use Case:

You have multiple MicroStrategy iCubes that you want to be able to refresh from your ETL process, which would allow you to refresh them only when certain criteria have been met (like after data load has been successfully completed)

Using the Command Manager tool you could refresh each cube separately, but it might be easier to have all cubes refresh when a specific Event is triggered.

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"

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.