Discovering Business Intelligence using MicroStrategy 9 — Save 50%
Leverage the power of the MicroStrategy platform to design, develop, secure, and share Business Intelligence reports and dashboards with this book and ebook.
In this article, by Nelson Enriquez and Samundar Singh Rathore, authors of Discovering Business Intelligence Using MicroStrategy 9, we cover the procedures to share reports and the subscription engine.
(For more resources related to this topic, see here.)
The final objective of the information in the BI reports and dashboards is to detect the cause-effect business behavior and trends, and trigger actions to solve them. These actions supported by visual information, via scorecards and dashboards. This process requires an interaction with several people.
MicroStrategy includes the functionality to share our reports, scorecards, and dashboards, regardless of the location of the people.
Reaching your audience
MicroStrategy offers the option to share our reports via different channels that leverage the latest social technologies that are already present in the marketplace, that is, MicroStrategy integrates with Twitter and Facebook.
The sharing is like avoiding any related costs and maintaining the design premise of the do-it-yourself approach without any help from specialized IT personnel.
The main menu of MicroStrategy shows a column named Status. When we click on that column, as shown in the following screenshot, the Share option appears:
The Share button
The other option is the Share button within our reports, that is, the view that we want to share. Select the Share button located at the bottom of the screen, as shown in the following screenshot:
The share options are the same, regardless of the location where you activate the option; the various alternate menus are shown in the following screenshot:
While selecting the e-mail option from the Scorecards-Dashboards model, the system will ask you for the e-mail programs that you want to use in order to send an e-mail; in our case, we select Outlook.
MicroStrategy automatically prepares an e-mail with a link to share it. You can modify the text, and select the recipients of the e-mail, as shown in the following screenshot:
The recipients of the e-mail will click on the URL that is included in the e-mail, send it by this schema, and the user will be able to analyze the report in a read-only mode with only the Filters panel enabled.
The following screenshot shows how the user will review the report. Also, the user is not allowed to make any modifications.
This option does not require a MicroStrategy platform user account.
When a user clicks on the link, he is able to edit the filters and perform their analyses, as well as switch to any available layout, in our case, scorecards and dashboards. As a result, any visualization object can be maximized and minimized for better analysis, as shown in the following screenshot:
In this option, the report can be visualized in a fullscreen mode by clicking on the fullscreen button  located at the top-right corner of the screen. In this sharing mode, the user is able to download the information in Excel and PDF formats for each visualization object. For instance, if you need all the data included in the grid for the stores in region 1 opened in the year 2000. Perform the following steps:
- In the browser, open the URL that is generated when you select the e-mail share option.
- Select the ScoreCard tab.
- In the Open Year filter, type 2012 and in the Region filter, type 1.
- Now, maximize the grid.
- Two icons will appear in the top-left corner of the screen: one for exporting the data to Excel and the other for exporting it to PDF for each visualization object, as shown in the following screenshot:
Please keep in mind that these two export options only apply to a specific visualization object; it is not possible to export the complete report from this functionality that is offered to the consumer.
In this article, we learned how to share our scorecards and dashboards via several channels, such as e-mails, social networks (Twitter and Facebook), and blogs or corporate intranet sites.
Resources for Article:
- Participating in a business process (Intermediate) [Article]
- Self-service Business Intelligence, Creating Value from Data [Article]
- Exploring Financial Reporting and Analysis [Article]
|Leverage the power of the MicroStrategy platform to design, develop, secure, and share Business Intelligence reports and dashboards with this book and ebook.|
eBook Price: $20.99
Book Price: $34.99
About the Author :
Nelson Enriquez is a multicultural executive and business leader with more than 17 years of experience in IT, strategy and planning areas, with specializations in business studies at Stanford (U.S.A), INSEAD (France), and EGADE (Mexico). He has international experience of working on several projects in other geographical locations including Asia, Europe, the Middle East, and South America, that are focalized in business integration, valuing and acquiring technology-related companies (the Due Diligence process), and integrating IT-related operations to company standards (Mergers and Acquisitions). He also has experience in retail, pharma, services, and manufacturing industries as a partner at an IT services company, in Monterrey, as an External Director in a Big Five consultant firm, and as a IT Planning Director at Tier 1 Retail in Mexico.
Samundar Singh Rathore is a data warehousing and business intelligence consultant, and a trainer with extensive experience on various data warehousing business intelligence products. He has worked with a large business and analytics organization with specialization in investment and healthcare domain data. He is currently working as a MicroStrategy administrator and architect. He was born in Mundara, Rajasthan, and raised in Mumbai, Maharashtra, which is the financial capital of India. He speaks Hindi and English, and he is also proficient in Java and SQL. He is an active member and the "Guru" of the MicroStrategy official discussion forum at https://resource.microstrategy.com/Forum/UserProfile.aspx?uid=8557.