MicroStrategy - Distribution Services - Bursting email
19 Mar 2022
Dificulty ★★☆☆☆
Intro
How to use table as source for emails and filters whithin distribution service.
Source
For this example I will be using the following report
And for easier understanding of the following here are the sources for it
Crate table
The first thing you need to do is create a new table with
- emails
- filter (Country colum)
- and (not necessarily) a colum to seperate difrent requirements (Report colum)
CREATE TABLE [dbo].[Email_Bursting](
Country [smallint] NULL
, Email [varchar](70) NULL
, Report [varchar](20) NULL
) input some data
INSERT INTO [dbo].[Email_Bursting]
([Country]
,[Email]
,[Report])
VALUES
(705,'demo_email1.gmail.com','Report 1')
, (191,'demo_email1.gmail.com','Report 1')
, (642,'demo_email1.gmail.com','Report 1')
, (705,'demo_email2.gmail.com','Report 1')
, (300,'demo_email3.gmail.com','Report 1')
, (724,'demo_email3.gmail.com','Report 2')
Registring new table in MicroStrategy
When you import the new table don’t forget to set Email as ‘Form format’ type ‘Email’.
and set the Parent/Child correctly
Limiting reports
If you have different requirements don’t forget to limit them on report
Result for first email
Result for second email
Subscription
Once ready go to subscription and set ‘Burst’ to email.
And that is it.