Tagged: Admin

13

Moving Cubes

This is a hack, so proceed at your own risk!  I haven’t tested this or used it in a production environment, so things may break/crash/catch on fire. Say that you have built a really nice dashboard, deployed it to production, and everyone loves it.  This dashboard is based on a cube that takes an hour to load.  Now you’ve made modifications to the dashboard and...

Screen-Shot-2012-07-07-at-9.07.36-PM 3

Detecting Freeform SQL Reports

I’ve written about the merits of Freeform SQL reports before, and how they can become very useful in a pinch but with a few consequences.  For example, one of the great advantages of MicroStrategy is that you can switch the underlying database platform without having to change anything except to tweak a couple of settings for performance.  Of course, that won’t apply to Freeform SQL reports...

Screen-Shot-2012-04-24-at-8.58.58-PM 6

The Importance of Branding

Business Intelligence is much bigger than the application itself.  Driving user adoption is critical to it’s success, and the best way that I’ve found to do that is to create a Brand for your system.  Creating an identity and personality is important for increasing user confidence, building an image, and gaining mindshare with your users.  Don’t forget that you’re always competing against the manual analyst...

pd1 15

Project Documentation

Documentation isn’t the most exciting thing to work on, but fortunately, MicroStrategy provides a tool that does some of the leg work for you.  This free tool is included in Desktop and produces a nicely formatted, web browsable output that can be shared with users.  In addition to discussing how to access and create this documentation report, I’ll also outline a really simple Web Customization...

7

Multisource

Sometimes the speed of business can’t wait for the perfect model and information flows to feed it.  Or perhaps it’s just not practical to ship data around to and from multiple locations due to it’s size or timing.  Maybe you just need to do a proof of concept or to borrow a few bits from an operational system.  MicroStrategy’s Multisource feature aims to assist in...

home 29

MicroStrategy Education eBooks

This past weekend, I received an update to my MicroStrategy Mobile client on my iPhone, so I started exploring through some of the examples.  I’m not sure how long they’ve been there, but I was surprised to see that just about every MicroStrategy Education course has it’s full course book available for free download.  They come in ePub format and can be viewed directly on...

SNAG-0000 4

Web Server Macro

A common environment setup is to have separate machines for your Production and Development environments.  While a lot of shops I’ve worked in will simply have separate Production and Development projects on the same physical servers (usually due to budget reasons), having separate physical machines gives you advantages like being able to restart the IServer / Web Server without causing outages for users.  Sometimes though,...

26

VLDB Properties

Today’s post is at the request of @jayzzzz on Twitter. VLDB (Very Large Database) Properties are settings that allow you to tweak some of the detailed behavior of MicroStrategy.  These settings control options on how the SQL Engine and Analytical Engine behave, and are necessary to address in every environment.  Precise control of these options can have dramatic effects on the performance of your reports,...

20

Best Practices in QA and Migrations

Todays post was suggested by @lenotooleBI via Twitter.  Whenever you mention “Best Practices”, the first thing that usually comes to mind is Object Management and Quality Assurance.  Any software development workflow is going to involve the same basic concepts of a Dev / QA / Production, sometimes in the form of multiple projects or even multiple servers.  As always, “Best Practices” are ideas and recommendations and...

0

Testing as Other Users

Here’s a quick tip that could be really obvious or make a big difference in your ability to provide support if you haven’t used it before.  It’s pretty common to receive an email from a user who has some issue, usually security or preference related.  It could be easier to either physically visit the user (if you’re able) or do a screen sharing session (if you have...