Can MSTR generate this?
SELECT A.ATTRIBUTE, B.COUNT(PK)
FROM LOOKUP_TBL A, FACT_TBL B
WHERE A.PK=B.PK (+)
GROUP BY A.ATTRIBUTE
So I want to count rows in the fact table that aren't in the lookup table, group by a higher level attribute, and have the extra show up as a row with a NULL as the attribute element.
Thanks.
SELECT A.ATTRIBUTE, B.COUNT(PK)
FROM LOOKUP_TBL A, FACT_TBL B
WHERE A.PK=B.PK (+)
GROUP BY A.ATTRIBUTE
So I want to count rows in the fact table that aren't in the lookup table, group by a higher level attribute, and have the extra show up as a row with a NULL as the attribute element.
Thanks.