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
Quote from: jburchill on 16 Dec 2024 10:10:52 AMHello 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.