Digital Transformation of Human Resources with MicroStrategy 10

Technical Support Intern • Strategy

Human resources departments are tasked with managing a company’s largest expense and biggest asset – its employees. But to be effective managers, HR organizations need sophisticated tools that provide a single, unified view of the workforce. Discover how MicroStrategy enables human resources professionals to integrate HR platforms with data from their talent management, performance, payroll, and education systems.

SYMPTOM:

Prompt answers cannot be displayed as filter detail when do file subscription to Excel format in Strategy Distribution Services 9.0.x.

STEPS TO REPRODUCE:

Create a report with attribute Subcategory and metric Cost. Add an element prompt based on Category attribute. The report is shown as below in Web:

Send this report to File subscription as Excel format. Open the report in Excel, as shown below:

Note: the filter detail does not exist in the Excel file.

CAUSE:

This is a known issue in Strategy Distribution Services 9.0.x.

ACTION:

This issue has been addressed in Strategy Distribution Services 9.2.1. Upgrade to this version and follow up below steps to take advantage of this fix.

Go to Preferences->Project Defaults->Export Reports, check the option of "Use header and footer when delivering subscriptions" as shown below:

Go to Preference->User Preferences->Export Reports, check the option of "Export filter details" as shown below:

Restart Intelligence server or wait for some time to synchronize the settings.
After the file subscription, run the report in Excel which shows as below:

Comment

0 comments

Details

Example

Published:

June 9, 2017

Last Updated:

June 9, 2017