MicroStrategy 10

Attended MicroStrategy 10 Symposium today held in Atlanta.

The new MSTR version is trying to solve BI problem of providing Agility with Governance and Security.

The main exciting features for release 10 are:

  • Unified Interface via MicroStrategy Desktop to do everything. This is very desirable to have end to end handling of data and move towards focus on data consumption without IT need.
  •  Most interesting to me were 
    • Data wrangling to clean up data and save it like Excel Macro to rerun for cleaning similar data (Reuse).
    • Reduced (No) data modeling as it can connect to any source and do aggregation/cleanup on fly
    • Connect with Maps (Out of the box ESRI maps to utilize for common cases) and ease of importing D3 maps
    • Native connections and build Mobile application like independent App for external customers
    • Native connections to Hadoop instead of Hive
    • Replacement of Flash with HTML5
    • Have Trend Line, Time series, data mining functions from R prepackaged
  • Performance is much improved compared to MSTR 9.4.1

There would be release every quarter to introduce new features and speed up analytics.  This should be game changer for sure in BI space where lots of time is spent in data modeling and Administration/Integration.



 






Popular posts from this blog

Cognos Excel Text Wrapping Issue - Row Merge and Column Merge

Below are the properties to set to keep column size and width with text wrapping: Column Merge issue  http://www-01.ibm.com/support/docview.wss?uid=swg21674298 Set the advanced server property RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL to TRUE for both BatchReportService and ReportService services.        Row Merge issue http://www-01.ibm.com/support/docview.wss?uid=swg21440556 RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL also to be set to TRUE  for both BatchReportService and ReportService services.   Once done, you can set any column width to be fixed and see same result in Excel as well as HTML. Please note that above properties will not be honored if you have unchecked Grouping repeating cells Report property in Report Properties menu. 
Read more

Cognos: How to replace an existing report without breaking links?

Below IBM document explains behavior of copy/move or overwriting impact of objects:- https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.wig_cr.doc/c_gtstd_copy_move_items.html If you copy and overwrite an existing report, the copied report ID and links replace those of the existing report. In this case, you might need to update links, such as links to job schedules. If you move and overwrite an existing report, the existing report ID and links are maintained. In this case, references to the moved entry are broken. However, this doesn't work in all cases and we see drill through links broken in some cases. Best approach in such case is to use cognos deploy method where you update reports in separate folder in same environment and import it to destination location. You can create single export and import tasks to use for all such updates.
Read more

How to change package for a report in IBM Cognos Analytics (ICA)?

In Cognos 10.x and 8.x , this was the simple to handle on Cognos Connection or via Repot Studio interface.  In Cognos 11.0.6, You  need to load classic view (Cognos Connection) to go back to this interface to change the package. In Cognos Cloud environment, we have single environment for Development and UAT. In such cases, when we move content from Dev folder to UAT area, we need to switch to classic mode to change the package.
Read more