MicroStrategy Technical Notes.

Its a collection of TN for quick reference.

TN:18911 - Remove SQL information in the report details in web 

TN:30699 - Measure Intelligent Cube performance

TN:19864 - How filter objects are resolved

TN:9434  - Remove redundant where clause using report as filter

TN:19861 - Logic for multipass SQL generation.

TN:19233 - Retrieve ID and DESC in two different pass

TN:19866 - SQL Join tree construction logic

TN:8159  - How does mstr join tables?

TN:7494 - Table join order

TN:11721 - settings to consider when performing outer join

TN:16423 - different branches in sql

TN:20579 - Global optimization sql pass with different where clause

TN:11122 - Downward outer join

TN:20062 - Report Limit vs MQ

TN:4295  - Intermediate table naming convention

TN:15393 - Partial Star Join

TN:11067 - Adaptive Metric

TN:20017 - Join on common attributes when no common key can be found.

TN:8831 - Filter defintions are stored based on the ID of the attribute

TN:17415 - remove coalesce function by removing outer join support

TN:19863 - How M-M relation is resolved?

TN:7956  - multipass sql even when the fact can be calculated from the same fact table.

TN:13508 - Global optimization remove unused sql

TN:14562 - Relationship filter to avoid expensive subquery

TN:6005 - Fact dependent security filter

TN:11351 - different security filters for different facts based on user login.

TN:10138  - WS, RI, HL

TN:38391  - Configure certificate server for Mobile

TN:34911 - Display group by as wheel in ipad

TN:14878 - Enable Web Beans tracing in MicroStrategy Web 9.x

TN:41346 - DS Bursting feature

TN:43665 - Integration with R