search

gm5000136 / GM_Dashboards

0 stars 0 forks source link

There are 70 appeals without target audiences, but none with multiple target audiences #13

Open gm5000136 opened 9 years ago

gm5000136 commented 9 years ago

Find them with this SQL in BBPM:

select a.AppealIdentifier, Count(p.AttributeDescription) as TargetAudienceCount from DIM_Appeal a left outer join (select AppealDimID,AttributeDescription from dim_appealattribute where AttributeCategory = 'Target Audience') p on p.AppealDimID = a.AppealDimID group by a.AppealIdentifier having Count(p.AttributeDescription) <>1