Multiple Cubes - One Filter
I'm building a customer health dashboard that combines top=level metrics from multiple cubes. I would like a way to have 1 text/name filter to select the customer's name but the data comes from multiple cubes.
Is there a way to combine filters to cover the same field (customer name) when it's listed in multiple separate cubes.
I know this is an odd & specific request - but it's a pain in the butt so I thought I would try.
-
Hi Sam,
As Nathan said rightfully, the best practice would be to merge those several cubes into one cube (you can use the other cubes as a data source like any other data-source for that purpose).
If it is not possible in your case, you can develop a custom plugin that will listen to filter changes and each time it happens - duplicate that filter selection to all the data sources that are run within the dashboard.
I your having troubles developing it feel free to reach out with some questions, we're always happy to help.
We can also provide you with a price quote for a finalized plugin.
Good luck (:
Ravid
Please sign in to leave a comment.
Comments
3 comments