Here is another task from the MicroStrategy Performance Labs series. To try this task, please setup our Workshop Online Environment. You are asked to create a report, which shows cumulative metric Units Sold Year-To-Date (YTD) per Day for the Subcategory Art & Architecture and selectable time period (use the filter “Day@ID between ?From_Date and ?From_To”...
Read more »
To give you an idea, what you can expect from my MicroStrategy Performance Optimization Workshop, I prepared some quite interesting tasks based on our Workshop Online Environment (follow the link for setup instructions). All tasks should be solved using MicroStrategy only, changes on the database are not...
Read more »
We have updated our MicroStrategy workshop. Some obsolete tasks have been removed and many new tasks have been added. The new workshop considers special features of warehouse database systems like Oracle, DB2 and Teradata and is designed for MicroStrategy architects and developers who want to...
Read more »
Some days ago I had an interesting problem in my current project. The customer wants to define new KPIs himself using a simple web interface. They want to be...
Read more »
Sometimes it’s necessary to retrieve something from the database without using any table. For example: SELECT ‘Hello World!’; or SELECT CURRENT_DATE; Besides, some of my workmates even ignore the...
Read more »
Many performance issues in MicroStrategy come into being because of Outer Joins. So let’s make them to our today’s topic. First of all, in MicroStrategy outer joins appear at...
Read more »