Monthly Archives: July 2009

MicroStrategy 9 Live Roadshow! Now in India


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
MicroStrategy Inc

Upcoming Roadshows in India

During this live event, you’ll learn about exciting new technology and capabilities designed to:

  • Graphically display the key information about your business
  • Provide interactive analysis to better understand your business challenges and opportunities
  • Dramatically increase the speed and simplicity of deploying new BI capabilities
  • Empower business users with extensive self-service capabilities
  • Extend the scale, performance, and efficiency of your BI solutions

Roadshow Agenda

6:15 -6:30 PM

Registration

6:30 – 9:30 PM

Welcome and Introduction to MicroStrategy

How Information Creates Competitive Advantage

Customer Presentation

MicroStrategy & Sybase Joint Value

Extending the Boundaries of BI

9:30 – 10:30 PM

Dinner

Note: Schedules may vary slightly.

Technology Partner: Sybase

Roadshow Sponsors:  InfoCepts, InfoSTEP, Lunexa, OBSI, Systech

To Register: MicroStrategy 9 Roadshows in India or the links above.

Make sure you write MicroStrategy101 for How did you hear about this event? in Registration form.

MicroStrategy 9.0 Hotfix 1 goes GA


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
Setup

MicroStrategy 9.0 Hotfix 1 is now generally available (GA) on the MicroStrategy Download Site.

Defects and Enhancements addressed in MicroStrategy 9.0 Product Suite can be found in the ReadMe.

But…

I’m wondering: Why this HotFix was released too close from the 9.0 launch?

Well…

A HotFix is a FIX! Therefore the 9.0 version was released with a number of bugs that had required this fast paced HotFix.

Question:

May I stay with my 8.x version or upgrade to 9.0?

Look close to MSTR 9.0 improvements and ask yourself if you need this upgrade. If no, then stay calm and wait for a second hotfix.

Bye

Spool space error


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
Database, ,

Okay, so this is an old one, but I still find it useful.

If you can’t run a report because of a spool space error, and you can’t convince the DBA to give you a couple of gigabytes more, then you might want to go to the Report Editor, Data ->VLDB Properties -> Tables -> Intermediate Table Type and select True temporary table.

What this does is modifying the SQL so that instead of having a huge chunk of code (that would use up a lot of memory) it breaks the code into CREATE – INSERT bits that are far easier to handle. It also makes the SQL more readable by humans (this includes programmers).

By the way, this setting also comes to rescue when you get the “Database is terrified by the script and it can’t even begin to analyze it” error. I don’t have the specific error message at hand, but I know for sure that Teradata does this when the SQL code is all in one pass and is so large that it can be seen from the Moon.