MicroStrategy101

Connect with MicroStrategy 101

Ashish Tiwari — Fri, 03 Sep 2010 19:17:29 +0000

Best way to connect with bloggers on MicroStrategy 101 would be registration. Rest assured, you are assured 101% privacy. You will not get any spam from me and your information is safe. Currently there are more than 150 registered users. To solve your issues/share your ideas you can join the forum too. Unfortunately, currently blog

Various types of Tables in MicroStrategy

Ashish Tiwari — Sun, 29 Aug 2010 07:05:38 +0000

Most of you would be working on it w/o knowledge. Pretty nifty. Base table: Provides source data for metrics. In a given SQL pass, the base table(s) may be fact tables or previously calculated intermediate tables. Lookup table: Provides attribute IDs and descriptions. A table functions as a lookup table if its columns appear in

GIS tools for MicroStrategy

Ashish Tiwari — Wed, 25 Aug 2010 16:18:34 +0000

This was probably long pending, but I had first hand information only about MapInfo, now called Business Insight (such a boring name) and Visual Crossing. Among MapInfo and VisualCrossing, former is lot cheaper. My ex-employer or rather client, LoanPerformance, have used both for trail and finally settled for Visual Crossing, due to the depth of

Metadata Browser v3.01

Sorin Suciu — Thu, 19 Aug 2010 13:21:04 +0000

As promised earlier this year, Senthil Raj – author of the celebrated Object Tracking Tool, has kindly agreed to merge his application with Metadata Browser. After much coding and testing, time has come to unveil this brand new application, which you will surely find very useful. Click here to download it. You can also download

Report Data Options in version 9

Sorin Suciu — Fri, 06 Aug 2010 15:15:38 +0000

You know how, after you execute a report, every time you make a change to the Report Data Options the report gets re-executed in order to apply those changes? Well, in version 9 (not sure about 9.01 yet) this doesn’t happen for the Metric Join Type and Attribute Join Type options. I don’t know if

Few more MicroStrategy interview question

Ashish Tiwari — Tue, 27 Jul 2010 05:43:29 +0000

Got this from some folder, written long time ago, but forgot to post. Few questions are not complete. How do you verify the missing data in MSI Web? How do you verify the missing data in Teradata? Difference?? do you know to create subscription in NCS? How will you create a dynamic subscription? How did you

Hacking MicroStrategy freeware license

Ashish Tiwari — Wed, 14 Jul 2010 18:23:37 +0000

When MicroStrategy, Inc released free version (though limited number of users), I jumped out of my seat. I thought finally I can start learning Server SDK with free mind. The the joy was only short lived, when I installed MicroStrategy Free Reporting suite, as that MicroStrategy calls, and came to know that lots of addon

MicroStrategy Mobile BI /w Apple. What a self destruction

Ashish Tiwari — Sat, 10 Jul 2010 09:09:49 +0000

Recently three have been a lot of noise about the MicroStrategy, Inc created tools targeted to Apple users (iPod, iPad etc). More than 200 re/twits a day. Mind boggling. During recent MicroStrategy World held at Cannes, France, MicroStrategy, Inc showcased these tools with lot of fanfare. But I highly suspect MicroStrategy gaining market share or

Extracting Long Description using Command Manager

Ashish Tiwari — Mon, 28 Jun 2010 16:26:18 +0000

About two weeks ago! Received an SOS email from Kiran asking the method to extract the Long Description of Metrics using Command Manager. Not worked on CM much other than some bulk generation of attributes/facts, in past. Search on knowledge base and found the cause. There are predefined CM scripts that would let us do

Field Report

Sorin Suciu — Sun, 20 Jun 2010 21:37:36 +0000

Last week I’ve attended a Free BI Class organized by MicroStrategy in Toronto, to see what’s new. The presentation was really well planned – a mix of the usual sales pitch and a nice hands on web and desktop exercises. Some new (at least to me) things that they’ve been working on are a great