I am currently doing a lot of URL API work.
So, as a reference, here is a link to the MSTR documentation:
https://lw.microstrategy.com/msdz/msdl/analyticsenterprise/docs/mergedProjects/websdk/topics/urlapi/URL_API.htm
Tiaan Otto's MicroStrategy Blog
Thursday, October 1, 2015
Thursday, May 28, 2015
Where did that join condition come from?
Being a consultant, I see many different MSTR implementations and the following issue pops up ever so often.
A report that always works, suddenly... doesn't.
After checking the change log (no changes were made to the report) and making sure there is data in the warehouse, I find an interesting addition to the report SQL.
Where it was always:
SELECT a1.day
FROM
Fact a1
join LU_Date a2
on a1.day = a2.day
now it is...
SELECT a1.day
FROM
Fact a1
join LU_Date a2
on a1.day = a2.day
and a1.deliverydate = a2.day
Where did the additional join condition come from?
A report that always works, suddenly... doesn't.
After checking the change log (no changes were made to the report) and making sure there is data in the warehouse, I find an interesting addition to the report SQL.
Where it was always:
SELECT a1.day
FROM
Fact a1
join LU_Date a2
on a1.day = a2.day
now it is...
SELECT a1.day
FROM
Fact a1
join LU_Date a2
on a1.day = a2.day
and a1.deliverydate = a2.day
Where did the additional join condition come from?
Tuesday, March 18, 2014
iPad Reset URL
I don't have to reset my MSTR iPad app often, but every time I do, I have to do a search for the reset url.
http://www2.microstrategy.com/webteam/m-reset/
Open the link above on your mobile device and tap on the big blue button
http://www2.microstrategy.com/webteam/m-reset/
Open the link above on your mobile device and tap on the big blue button
Thursday, September 12, 2013
Enable Google Map Widget on Web
These steps are for getting Google Maps to work on DHTML 9.X
Although there are many blogs and posts on this topic, I have had to do this so often that I decided to post my steps anyway:
Wednesday, August 21, 2013
Level Metric Formulas
When creating a level metric on the fly (Derived metric inside a report), there is some syntax you need to know for the different grouping and filtering options.
The table bellow shows the different options:
The table bellow shows the different options:
Thursday, May 16, 2013
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...
Sunday, March 10, 2013
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.
Subscribe to:
Posts (Atom)