Want to reuse the metric set for another dashboard will it create copy?

#1

We have a metric set created from one cube(used in one dashboard already) to a different dashboard built from a different cube and want to set up a relationship between them. can we create a copy of the existing metric set? will there be any circular references created if we create a copy of the dashboard? our admin mentioned using publish option to avoid references. what is the difference between publishing and copy? cant we create a copy of the object? Please note that both the dashboard and metric set are in the same project folder.

thanks for the help in advance.

#2

Hi Mistu,

Yes, you can create a copy of the existing metric set and you can make changes according to your new requirements. If you created a copy of dashboard there is no circular reference will be created.

Publishing lets you copy the contents of a source project or files (such as dashboards or data cubes) to a target project, with the option to also copy referenced files so that any dependencies are also part of the target project. While publishing you can’t publish to the same folder you need to choose different folder but if you are copying you can paste it on the same folder. Dundas BI includes a built-in project named . You can use this project to store any items that are common to your other projects and reusable. IF you publish to Project then it will be available in each project’s shared folder

image
image.png378×578 14.2 KB

Please let me know if you have any questions.

#3

Thanks for your reference. What about metric sets? if we create a copy of metric set , created from a different cube to a different one, will the circular reference be created?

1 Like
#4

You can indeed create a copy of a metric set and it will become its own separate item (i.e. no circular references), albeit it will obviously be sourcing its data from the same data cube as the original data cube. This can be rectified by re-wiring this copied metric set to the different data cube you’d wish to have powering it.

https://www.dundas.com/support/learning/documentation/cleanse-consolidate-modify-data/re-wire-the-data-flow#h3-re-wire-metric-set-elements

At that point, all you’d need to do is drag this copied metric set onto the different dashboard.

#5

Hi Christian,

Thanks for your response. we cant rewire to the new data cube as there are some differences in source table columns. we just want to filter the data based on filters from one table to the other one as filters for both dashboard and metric sets are same.