Perhaps, using reverse Engineering:

If I have a report which shows Portfolio V. Index - Adjusted Yield Curve Exposure by region CTD

internationaldb.dbo.smat_report_log group by report_desc order by count(*) desc

The output of that is:

Adj. Yield Curve Exp by Region CTD 470

Holdings by Client, Region, and Sector 280

Settlement Day Cash Projection By Currency 217

Settlement Day Cash Projection 203

Net FX by Currency 168

Maturity Schedule 147

Securities by Sector and Client - Detail 126



How do I bucketize all this data in a cube and make Excel reports out of this