I created a metric based on two values that I’m using in an insight. However, when I use the metric ( a measure that simply chooses which of the other two measures should be shown) I get a message saying “Sorry, We Can’t Display This Insight”.
And then when I use other data values, it moves into “unrelated data measures”
Do the metrics need to be applied to the LDM? Or do I need to somehow associate the metric with a given dataset?
Best answer by Joseph Heun
MAQL always works in the context of data available in a given logical data model which determines the available data and utilization of MAQL statements.
You will need to make sure that all facts and attributes (datasets) are connected in a meaningful way within the LDM to ensure that the report will be working correctly.
Here are some articles that may assist further:
If you LDM hasn’t fully connected the datasets you need, you can use explicit lifting to help accomplish your report:
If you are still facing issues with the metric, we will be more than happy to look directly into the reports being created and compare them to your LDM. We will of course need admin access to the project to follow through with such an investigation.