Intelligence Server Engines and Query Flow

Tue, 2011-09-27 10:58

I would like to blog about various MicroStrategy engines available in I-Server. There are about 14 I-Server engines, each one is described below:

• Security Engine – manages user authentication and authorization
• Object Browsing Engine – presents the folder navigation of the BI applications
• Prompting Engine – manages the presentation and resolution of prompts
• Resolution Engine – interprets business definitions for efficient execution
• Command Engine – manages all engine capacities and job queues.

MicroStrategy Access and Privilege Control by Project

Mon, 2011-09-26 01:36

From the time I last blogged and today, I have seen excellent growth in the number of MicroStrategy implementations. Many enterprises (regardless of size) have started using MicroStrategy for Business Intelligence practice. I have helped few teams to get started with MicroStrategy. One most common questions most clients had was around project security.

I would like to describe a MicroStrategy Access & Privilege Control Model which might work for most clients. The goal is to address the following:

Intelligent Cubes in MicroStrategy 9.x

Wed, 2011-09-21 11:08

Intelligent Cubes provide access to a single set of data that can be shared among multiple reports and analyzed with OLAP Services,while reducing access to the data warehouse.

A Technologist View of the Future of Commerce - Michael Saylor

Finding out all the free-form SQL reports in a project

Fri, 2010-05-21 22:13

Finding out all the free-form SQL reports in a project:

There is no option with in the desktop to find out the list of free-form SQL reports in a MicroStrategy project. The list can be pulled by querying the metadata.

What you need is the access to metadata. So that you can connect and run the below query.

select a11.object_name from dssmdobjinfo a11, dssmdobjdepn a12 where
a11.object_id=a12.object_id
and a12.depn_objid in(select a13.object_id from dssmdobjinfo a13,

Creating a Data Mart Report

Thu, 2010-02-18 23:18

Data Mart report is a feature in MicroStrategy which allows a report to insert the results set into a table which can be created  on any relational database. MicroStrategy objects can be built on the table (created by data mart report) for reporting needs.

Create a new report or modify an existing report to configure a data mart report.

Step 1: Open the report editor and click on "Configure Data Mart" [Data > Configure Data Mart]

Content Tags

Exclusive Jobs

We are looking for a Sr.MicroStrategy Consultant with good experience in MicroStrategy administration, dashboards, advanced reporting, etc. for our direct client.

Location: Bay Area, CA
Rate: $80/hr to $105/hr (depending on experience)
Join Date: Week of Sep 12th 2011

Contact us asap: careers-us@nalgan.com. We will respond at the earliest.
Microstrategy developer
Location:
Multiple positions across USA
 
Rate:
DOE
 
Requirement:
Strong Data Modeling and Dimensional Modeling experience
Develop and maintain MicroStrategy reports, dashboards and end-user applications. 
Design, develop and implement BI systems enabling non-technical users to leverage data for strategic decision-making. 
Utilize various MicroStrategy reporting tools to deliver insights to targeted audiences (e.g., Narrowcast, Web Reporter, Web Analyst, Wed Professional, Report Services).  
Develop ad hoc interfaces enabling end-users to generate their own reports. 
Perform extensive QA on data and MicroStrategy reports. 
V9 experience is a must.
Mobile & Iphone experience is beneficial
 
Resumes must be sent to careers-us@nalgan.com. Only selected canadidates will be contacted.

Experience working on Unix systems and System admin skills
Understand Shell Scripting
Experience with installing, upgrading and maintaining MicroStrategy Servers
Configure Web Servers (Tomcat)
Performance monitoring on MSTR Server
Understanding MSTR Architecture and reports and dashboard development is a plus.

Unix/Linux environment

Responsible for object migrations

Release Management

System level tasks - Capacity planning, storage management, system uptime, scaling and performance

Ability to assist in Reports, Dashboards creation and enhancements

 

Business Intelligence Administrator

 

Job Description

We are a seeking a strong BI Administrator to manage the BI Platform that helps analyze, visualize and process massive amounts of data that our site captures on a daily basis, in addition to data from Oracle EBS CRM/ERP systems.

RESPONSIBILITIES

The successful candidate will be required to work closely with the Data, IT and Infrastructure teams to help implement & manage MicroStrategy BI Platform.

        Responsible for implementing a scalable MicroStrategy Platform, manages entire BI infrastructure stack and provide 24x7 support

        Implements and maintains access and security layers

        Monitors Dev, UAT and production systems

        Implement scalable Code Migration and Change Management Deployment Processes

        Identify the technology stack changes and help with Installation and Upgrades on MicroStrategy server stack.

        Complete application and user/developer support within uptime window

        System performance monitoring, tuning, and capacity planning

        Create automation of user provisioning and maintenance tasks

        Project fine tuning – requires some understanding of objects within project and strategy for deployment

        Provide feedback/reports on system usage and potential bottlenecks using Enterprise Manager and other tools

        Caching strategy - requires some understanding of objects within project and strategy for deployment

        Server idling strategy for data loads, etc.

        Database connectivity setup and troubleshooting

 

REQUIREMENTS

 

        At least 4 – 6 years of experience as BI Administrator with MicroStrategy – for a high transaction volume  environment and MicroStrategy certified v9

        Expert Level with MicroStrategy Administration

o   iServer, Web Server, Architect and Desktop components

o   Enterprise Manager, Narrow Cast server, Object Manager

o   Cache Management and Clustering

        Expertise on Linux and ability to code shell scripts

        Knowledge in Flex and Flash (MSTR SDK) preferred

        Innovative thinking and problem solving capabilities in a fast pace environment
Excellent knowledge of Oracle RDBMS (SQL/PLSQL), mySQL and OLAP

        Familiarity with Best Practices around MicroStrategy Implementation and Development methodologies

        Good understanding of Data warehousing and ETL techniques, best practices and technologies

        Exposure to distributed data file system data warehouse environment used for massive quantities of data, familiarity with Hadoop/Pig/HBase and MapReduce/Sawzall/Bigtable

        Strong communication, interpersonal and organization skills

Can do attitude, proactive and self motivated

 

Please call 510-360-5117 or email jhingon@milestonepowered.com

Duration: 18 months

This person will be the overall BI Architect (Microstrategy).  Must have enterprise Microstrategy Architect experience.  Consultant does need to be on-site Monday-Thursday and there could be some travel to Latin America as well, so a valid passport is required.

Please email resumes to careers-us@nalgan.com