KB47172: Dynamic subscription does not send out the email when the component metric for a compound metric does not have value for the attribute element in MicroStrategy Narrowcast 9.x

SYMPTOM:
 
In the personalized page dynamic subscription in Narrowcast, the report is not delivered if it includes a compound metric with a component metric which has no value attribute element although the component metric is not included in the report. However, the compound metric can return value for attribute element if executing report in Desktop as outer join is configured.
 
 
STEPS TO REPRODUCE:
 

• Attribute T contains a form called "email" whose values are email addresses that will be used in the dynamic subscription in Narrowcast.
• Compound metric C is made up of two metrics A and B with expression (A+B).
• Attribute T contains an element t1.
  Metric A has corresponding value for element t1 while B does not.
  
  
• Report R contains attribute T, metric C. The definition of the report should include:
   

• 1)   T is placed in page-by.
  
  2)   The form that contains the email address should be enabled to display in the report.
  
  3)   Go to Data->Report Data Option -> Metric Join Type, and set metric C to be outer join. 
  
  
• Run report in Desktop and make sure the report returns value for element t1.
• In Narrowcast, create an information object called "IObject" as below:
   
  
  1)   Role
  
         - Subscription Information Object
  
   
  
  2)   Source of Subscription Information
  
         - Select or define a report and return dynamic subscription information from the selected report
  
   
  
  3)   Report
  
         - Choose the one that created in step 4.
  
   
  
  4)   User Properties and Personalization
  
   
  
         - Address ID:    Retrieve from Report    T(ID)
  
         - User ID:    Retrieve from Report    T(ID)
  
         - Locale ID:    Apply a constant    System
  
         - Personalization:    Retrieve from Report
  
         - Security and Authentication:    Do not apply security     
  
   
  
  5)   Address Properties
  
   
  
         - Address display:    Retrieve from Report    T(DESC)
  
         - Physical address:    Retrieve from Report     T(Email)
  
         - Device:    Apply a constant    Generic e-mail client
  
         - Transmission properties:    Apply a constant     TransmitType=='To'
  
         - PIN:     Apply a constant     space
  
         - Time zone:    (Choose any)
  
         - Delivery window:   (Choose any)      
  
   
  
  6)   Preference
  
         - Choose preference 'T(ID)' for the personalized object.   
  
  
• Create an HTML document with "IObject" created step6. Edit the Advanced Properties -> Report Execution -> Choose "Personalized page execution".
• Create a subscription set and add information object that created in step6.
• Create a service using delivery method "Email" and define as follows
   
  
  1)   With the HTML document as the message body
  
  2)   Use the subscription set that created in step 8.
  
  
• Run service. No email is sent. In the DELog, it's seen that 0 segment was generated as the sample entry below:

CAUSE:
 
This is a known issue in Strategy Narrowcast 9.x
 
ACTION:
 
Contact Strategy Technical Support for update of the issue.