Tagged: CmdMgr

20

Creating Metrics in Bulk

Here’s a quick Command Manager script I wrote this morning when I had to create 60 metrics off of 60 Facts.  They were all simple Sum(Fact) Metrics.   //list all metrics in the project     String sProjectName = “PROJECT NAME”;   String sFactFolder = “\Schema Objects\Facts\Folder”;   String sMetricFolder = “\Public Objects\Metrics\Folder”;    ResultSet oFacts = executeCapture(“LIST ALL FACTS IN FOLDER ‘” + sFactFolder + “‘ FOR...

13

Moving Subscriptions Between Users

I was once on a project in 8.x days where one group of users were responsible for managing the subscriptions for larger sets.  Most had anywhere between 10-20 subscriptions, and the largest were in the hundreds.  This was back in the Narrowcast days where the subscriptions metadata was separate from the IServer metadata, and the connection was loose at best.  When a person left or...

71

Triggering Events with Command Manager

MicroStrategy Command Manager is an external application that has basic scripting components that can be used for bulk operations.  While it’s designed to automate common tasks and save time in bulk changes, it does come with the ability to integrate external applications with MicroStrategy Events.  This allows you to integrate your process flow from sources such as ETL or source system events to trigger MicroStrategy...

6

Tagging User Email Addresses

In MicroStrategy 9.0, Web Subscriptions were moved from Narrowcast into the Intelligence Server in a new function called Distribution Services.  In the Narrowcast days, you had to maintain a separate metadata of user accounts and rely on a link between User and Email address.  Today, those are more tightly integrated, and the results is having Email addresses directly tied to User accounts as well as...

6

Disabling All Schedules and Users with Command Manager

Today I’ll share two handy MicroStrategy Command Manager scripts I use quite often during upgrade testing.  When preparing for an upgrade, you’ll need to create a test copy of your metadata.  But  you may run into two problems: If you use Time Based schedules, they’re still active and could either email users or at least waste time processing during production schedules.   If you’re on...

17

Tagging Metric Formulas in Tooltips

A handy feature in MicroStrategy Web is the ability to show the description of an object as a Tooltip when you hover over it.  This can be a really useful way to get extra information on Metric in a report.  For example, you may add text to your Profit metric to say “Revenue – Cost” so that a user knows what the formula was.  I...