locked
BI Rollup CRM 2011 Data / Reports RRS feed

  • Question

  • Hello,

    I have been assigned what would be a pretty complicated on-demand report. It consists of a high quantity of counts, percentages, previous month data, etc. It is basically a BI performance report. Now as an on-demand report this rdl would become very large and complicated. However my year in the data warehouse writing BI reports makes me think this would be a good candidate for a rollup table. The question is can I do this in CRM / SSRS or am I basically going to have to put the complex SQL into the report. Stored Procedures?

    TIA

    JB

    Friday, July 19, 2013 3:52 PM