7 Exciting Mobile BI Announcements in MicroStrategy World 2014 – Barcelona

Hello there!

Len O’Toole wrote another excellent post about some exciting news for MicroStrategy Mobile announced in MicroStrategy World 2014 – Barcelona.

pic2

Here is what he wrote:

TRANSACTION SERVICES

One key differentiation between MicroStrategy and other vendors is their absolutely fantastic Mobile BI tool-set. One of these key features is Transaction services. This year, Hugh Owen announced some pretty exciting features in this area.

Input Controls & Conditional Logic: Input Controls can now be used as Selectors. In additional, when used with the new Conditional Logic feature, developers can now build Transaction Services dashboards that display information dynamically based on what data is being entered / selected by the Input Controls. For instance, on a mobile survey, selecting gender as Female can now dynamically change the values of the following questions to be more appropriate for female survey participants. Awesome stuff. Can’t wait for this killer feature to arrive.

Local Transactions: Having consistent network connectivity is not mandatory any more. New features coming down the product line will allow improved offline Transaction Services. Any inputs made in Offline Mode will be maintained in a local data cube (?). When connectivity is enabled, local transactions are synced with the MicroStrategy Mobile Server and visa versa.

USER EXPERIENCE

Information Windows are coming to MicroStrategy Mobile for iPhone. Designers can also alter transparency of these windows producing some really slick looking pro-effects.

Background Data Refresh for apps is now possible for normal Mobile BI apps – not just News-Stand enabled apps.

And the most awesome feature of all is the new List View Object widget. This widget will allow you to display a flexible list grid containing images / text for just about anything. To me, this screams store front and product browsing. Imagine adding a grid like this with a “Buy Now” button on top of a Transaction Services document… This opens up a whole new area of possibilities for your MicroStrategy Mobile App – Sweat!

MAPPING ENHANCEMENTS

In the pipeline are Custom Shapes & Polygons that can be used with your Mobile BI App. Custom Shape files can be of anything – Store maps – Geographic regions etc…

Mapping will also be enhanced to allow Multiple Data Visualization Layers on the same map. For example: One layer could be a Density Map while another layer on the same map could be pins indicating store locations. Right now, we are restricted to one or the other – not both at the same time.

Indoor Mapping Integration is coming. Used in conjunction with proximity technologies like Apple iBeacons, we can now build Mobile BI apps with real-time location data of all mobile devices within the Geo Fenced area. This is a pretty exciting feature that will open up a whole new area of Mobile BI app goodness.

PROXIMITY SERVICES

MicroStrategy is also pushing in to the area of Proximity Services. Hugh demo’d a scenario of a cell tower inspector. Upon arrival at a tower, the Mobile BI app detected the ‘beacon’ signal from the tower. This triggered a Microstrategy document to be refreshed and pushed to the mobile device. When the tower inspector opens the Microstrategy Tower Inspection App, it already has all the tower information displayed. It even anticipates the next action of the inspector by opening up the Survey Widget.

I’m getting weak at the knees thinking about the possibilities surrounding Proximity Services !!

ANDROID HAS GROWN UP

At last, the MicroStrategy Mobile BI App for Android is getting a face-lift. In fact, the whole app has been rebuilt as an Android Native App versus the previous Web App. This refines the overall experience with enhanced animations and slick visualizations.

WINDOWS IS OUR FRIEND TOO

Also announced was Support for Windows 8 Mobile Devices. I am writing this post on a Windows 8 Surface tablet and absolutely think that this will be a huge win for MicroStrategy over the coming year. Microsoft’s latest Surface Pro has shown that it will be a major contender in the Enterprise Tablet Space. Being Windows friendly, Microstrategy Mobile should see mega adoption within the Enterprise – Watch This Space…

SECURITY SECURITY SECURITY

Top priority for all enterprises these days is Security. Thankfully, MicroStrategy is leading the way in this space with their Usher Mobile Identity App. Hugh Owen announced that Usher Integration with the Mobile BI framework is in the works. I’m a big fan of the Usher secure technology and can see a bright future for it. Being integrated in to the Mobile BI framework is a brilliant enhancement.

In addition, Microstrategy announced expanded integration with Device Management Vendors including – Mobile Iron, Airwatch and Citrix.

 

MicroStrategy is creating and innovating its tools. I believe that in less then one year, we are going to work with a 100% better solution from MicroStrategy.

God bless you!

Changing Metric Column Alias Name

Hello there!

Today let’s talk about changing the metric alias name in the SQL that MicroStrategy generates.

Sometimes you need to debug the query and you see something like this:

select name_pu as name, sum(salary) as #MAS01MQW from Fact_Table group by name_pu

If you have a lot of metric inside your report, it is very hard to know where is a specific metric in the query.

You can change that machine metric alias name to a human metric alias name using Metric Column Name.

To do that, you just have to:

1. Edit your metric;

2. Go to Tools;

3. Go to Advanced Settings;

4. Choose “Metric Column Option

pic2

Then, you just have to type a different name in the “Column Name used in table SQL creation“, like the image below:

pic1

Now your SQL is going to be something like this:

select name_pu as name, sum(salary) as Name_of_Metric from Fact_Table group by name_pu

That’s it.

Hope it helps!

God bless you!

Top 7 Announcements in MicroStrategy World – Barcelona 2014 by Len OToole

Hello there!

Today I am just copying and pasting what my Len O’Toole told in his Linkedin account. He wrote wonderfully about his most exciting announcements in MicroStrategy World Barcelona 2014. He writes a lot of good stuff, I encourage you to read his feed from his Linkedin account.

So, here is what he wrote:

 

  1. Visual Insight – Reborn In HTML 5The current Adobe Flash based Visual Data Discovery tool has matured greatly over the past few releases. The good news is that in a future release it will be completely replaced with a browser friendly HTML 5 version. Demos of the product were quite impressive and I am really looking forward to deploying this tool to my Self Service Users. They are going to love this package of awesomeness.
  2. MicroStrategy Analytics Desktop tool coming to a MAC near youWhen it comes to MAC users, MicroStrategy products never worked well with MAC. Thankfully, things are about to change with the announcement that the MicroStrategy Analytics Desktop tool will soon work with your MAC.
  3. MicroStrategy Web ArchitectThis was a really cool announcement for me personally. A new Architect product that uses HTML 5 is in the works. The tool will allow MicroStrategy Architects to perform much of their architecting tasks without the need for the thick-client Desktop / Developer tool. One notable feature is “Low Level Object Locking”. Now, rather than locking the whole schema for editing, a minimal amount of objects will be locked. For a multi-architect environment, this will be an outstanding feature. The object creation UI has also been re-worked. Setting up Tables, Facts & Attributes is much more intuitive, allowing super rapid data model configuration.
  4. Operations Manager – A Unified Administrative InterfaceAlthough currently available for MicroStrategy Cloud only – the plan is to bring this to on premise installations in the future. The tool allows MicroStrategy Administrators to have a Unified Administrator Interface that will allow everything related to your MicroStrategy environment to be viewed and controlled from a single location.
  5. Enhanced Enterprise Manager Functionality comingEnterprise Manager has been re-architected to improve statistics data loads. The pre-canned Enterprise Manager Dashboards have also been upgraded and there will also be a bunch of new MicroStrategy Mobile BI App statistics available to monitor within the tool.
  6. Distribution ServicesNew features (from Narrowcast) – Burst to Email – FTP Delivery. This continues the journey to transfer of features from the old Narrowcast tool to the newer Distribution Services tool.
  7. Integration with “R”MicroStrategy “R” Integration looks pretty cool indeed. Analysts can literally create a new metric on a grid report, copy / paste an R Script in to the Metric Expression Editor and finally drop the Metric on the grid report. That’s it – Simple as it gets. Run the report and you’ll see your statistical R Metric just like any other metric. In addition, MicroStrategy has also released a bunch of pre-canned “R’ scripts to their R “Scripts shelf” out on CodePlex. Anyone can access the Scripts Shelf and use the scripts in their own metrics.

 

I just want to add one more thing in this list, that is about Windows Phone! Yes! MicroStrategy has announced that they will create a native Windows Phone MicroStrategy Mobile app! That’s awesome!

 

So, that’s it for today!

God bless you!

Creating Alias name for a project in Web

Hello there!

Today let’s talk about a quick tip: How to change a project name in MicroStrategy Web without modifying it in MicroStrategy Developer. So, you can have a project name in Developer and a different name for the same project in MicroStrategy Web.

To do that, you have to:

1.  Login using Administrator user in MicroStrategy Web;

2. Open your project;

3. Go to Preferences;

pic1

4. Choose Project Defaults;

5. Go to Project Display;

pic2

6. Input a name in the Project alias textfield, restart your MicroStrategy Web, and you will have a different name for you project.

Hope it helps.

God bless you!

Performance Counter

Hello there!

Today I’m going to say less and show more.

You can enable performance counter to see if you have any performance issues in your environment.

There are one post from MicroStrategy that helps you to enable those logs. Here is the link:

https://resource.microstrategy.com/support/Authoring/DisplayTN.aspx?tnkey=13313&formatted=1

There are two posts about the recommended settings for those logs. Here they are:

For Unix:

https://resource.microstrategy.com/support/Authoring/DisplayTN.aspx?formatted=1&tnkey=19155

For Windows:

https://resource.microstrategy.com/support/Authoring/DisplayTN.aspx?formatted=1&tnkey=19154

The link below shows you how to import the created file to Visual Insight (using MicroStrategy Analytics Express, but you can use your own Visual Insight installation (Desktop or Enterprise)) and analyze the log data:

https://resource.microstrategy.com/support/Authoring/DisplayTN.aspx?tnkey=47317&formatted=1

Hope it helps.

God bless you!

Using Extended Fetch

Hello there!

Today let’s talk about a very important thing! Extended Fetch!

Do you know what is extended fetch?

Extended Fetch is an option that can be used in MicroStrategy that returns multiple rows at one time when querying your Data Warehouse.

Without Extended fetch(the Default option): MicroStrategy returns data one row at a time. With Extended Fetch: MicroStrategy returns multiple rows at one time. Extended Fetch may therefore facilitate faster retrieval of query results, especially when the number of result sets is large.

There is a list of the supported (MicroStrategy didn’t update the list, so maybe your database can support extended fetch) databases in this link below:

https://resource.microstrategy.com/support/Authoring/DisplayTN.aspx?tnkey=32213&formatted=1

To use Extended Fetch, you have to make sure to use 2.0 ODBC Calls instead of 3.x ODBC Calls ODBC Version.

To inspect which ODBC version you are using for your database connection, just go to:

MicroStrategy Developer -> Administration -> Configuration Managers -> Database Instances -> Choose your Database Instance and Edit it -> Go to Advanced tab and look for ODBC Version section:

pic4

pic3

Now just go to General tab:

pic7

Choose your Database Connection and click on the Modify button.

Go to Advanced tab and check: “Use Extended Fetch” option:

pic6

If you are using Tier-3 connection, restart your Intelligence Server to apply those settings. If using 2-tier, just disconnect and reconnect to your project source.

That’s it.

Hope it helps.

God bless you.