Replace metric set

#1

Hello,

While building a dashboard displaying multiple times the same metric set, I stumbled up this blog post https://www.dundas.com/resources/dundas-data-visualization-blog/best-practices-for-performance-optimization-of-dashboards-in-dundas-bi which I can summarise in 2 points:

  • one metric set = 1 database query, so do no use auto-generated metric sets
  • to actually (re)use a metric set, it needs to be slid into a dashboard and then revisualised. Adding data to a component would create an auto-generated metric set.

Now sadly this is too late for me. I have 7 auto-generated metric sets which could actually use and reuse the same explicit metric set I did define for this purpose.

Long story short: can I replace the metric set of a component? If I drop all my components to add them again the right way, I am talking about a good few hours of restyling and more which I would rather not spend. I know it is possible to replace the cube a of metric set, so can I replace the metric set of a component in the same way?

Thanks,

1 Like
#2

Hi @guillaume,

Are you having any performance issues that would justify the work? There are rewiring capabilities but it’s not going to help you on the dashboard level. You’d have to re-do the work.

I’m recommend taking a look at the performance tab and seeing if any particular metric sets are causing issues. Maybe you can just combine a few of them?

#3

Thanks Jeff,

I saw indeed rewiring capabilities but that’s outside the dashboard as you pointed out.

My backend DB is high latency, so if I can have 1 metric set only feeding a few visualisations it helps a lot with performance (and no, I cannot really warehouse this data, it’s too big and specific). My issue is not so much with one metric set per se, it is that as they are for all practical purpose duplicated (auto-generated), they hit the DB much more than needed. That’s why I want to replace auto generated metric sets with my hand-crafted on, but you confirmed that it it is not possible in an easy way.

Thanks!

1 Like