Bryan's BI Blog pushing what's possible

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,...

Screen-Shot-2012-01-09-at-9.30.27-PM 32

Custom Formatting Strings

Formatting metrics is something that we’re all familiar with.  Currency, commas, decimal places and percents are common choices, but what happens when we have to do something more advanced?  The Number Formatting screen for a Metric contains an option to provide a Custom Formatting string, but documentation is sparse on this hidden gem of a feature.  Today, I’ll talk a little bit about how it...

5

Saving Settings in Custom Visualizations

I had an interesting problem the other day while working on a custom visualization.  The requirement was for the user to be able to enter some custom text into a box to annotate some data, but the end usage was to export this to interactive PDF.  This meant that upon export, any text entered would be lost, so I needed a way to persist that...

Screen-Shot-2012-01-02-at-7.33.23-PM 7

Web Styles for Prompts

One feature that I find is often overlooked is the ability to change the display style of Prompts in Web.  In a lot of situations, these alternate styles can help guide the user in the way the prompt should be answered (one selection vs many selections) in a way that’s not always as clear or clean as the default Shopping Cart style.  It’s a quick...

stats 6

Blog Stats

This is my 100th post, and my last for the year.  I figured it would be fun to share some statistics about the blog and what better way to do that than with MicroStrategy Cloud Personal.  I use Google Blogger as the backend software for my blog, and it keeps some pretty high level statistics for me.  In mid-October, they offered integration with Google Analytics...

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,...

Screen-Shot-2011-12-05-at-8.06.14-AM 13

Conditional Attribute Text with Derived Metrics

One of the coolest features in MicroStrategy that I think we take for granted is Derived Metrics.  They’re incredibly useful, save lots of time and most importantly, save lots of clutter.  They allow us to do quick little tricks with calculations and display and have gained more of a foothold now that they bubble up to Documents as of 9.0.  However, their counterpart has sorely...

0

Conditionally Showing Widget Properties By Domain

Here’s a quick tip for the Flex developers out there.  In my environment, we commonly export visualizations to Flash PDF and send them externally to clients.  While we may want to add some flexibility to the visualization to allow for some customization by the user, we don’t always want the same options to be available to the client in the exported version. Here’s a very...

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...

Screen-Shot-2011-11-15-at-7.57.19-AM 9

Hide/Show Elements on a Dashboard

Here’s some more fun that we can have using HTML Containers.  Say that you want to add just a little bit more dynamic flair to your Dashboard, such as hiding and showing different objects into view.  Using an HTML Container and some simple JavaScript, we can accomplish that pretty easily.  Although I don’t have it working quite perfectly, perhaps the more JavaScript savvy among you wouldn’t mind...