Dashboards for reports with multiple joins

[jburchill]

Hello all, I'm pretty new to dashboards.  I have been writing Cognos for a while tho.  Leadership wants to focus more on visuals and dashboards.   Most our reports come from multiple tables and lots of report studio joins.  I read that dashboards can only come from one table.  How do you get a dashboard to work requiring more than one table?

thank you

[MFGF]

Hello all, I'm pretty new to dashboards.  I have been writing Cognos for a while tho.  Leadership wants to focus more on visuals and dashboards.   Most our reports come from multiple tables and lots of report studio joins.  I read that dashboards can only come from one table.  How do you get a dashboard to work requiring more than one table?

thank you

A dashboard (and a report) should really be based off a well-designed model that defines all the required joins between tables, adds commonly-used calculated items, organizes the data into intuitive, friendly groupings, and delivers accurate, consistent query results. This can either be a published Framework Manager model, or it can be a Data Module. I would strongly recommend you look into creating robust models rather than building joins into reports piecemeal - it will make things so much easier for you and for your authors when creating content - both reports and dashboards.

Cheers!

MF.