I’m having issues getting embedded data to show up on an insight.
I optimized the properties for reporting, and they are showing up under ‘Available Fields’ in Explore Data, so I can add them as columns to a table. But, when I add them as columns, the data is showing as blank (even though I know there is data there).
If I generate a report definition and add a declarative index join for the embedded data and run the report, I do get data back.
Does anyone have pointers on how to get this to work? Do I need to create an association?
@morak If u can check the network tab when the insight is loaded ,we can get some info. Sometimes even though data is coming from the insight api or the source , insight does not display.
@morak you are correct, assuming the properties are relevant, then optmiizing them should work. I can see in your image, they must be relevant records as they are shown in the Insight builder.
In '25, you have a clear cache option in explore data
Earlier versions you can do this manually:
right-click Inspect → Application tab → on left side of this tab, expand Session storage > click on your environment (I’ve only ever seen there be one option)
right-click and Delete any rows where the key starts with your app (i.e. all ‘app/ken-25-app’ ones in this list should get deleted)
manual Refresh of browser tab is needed
I made sure to optimize the properties for reporting and tried to clear the cache, using the clear cache option, and the data is still showing up as blank in my insight.
I’m not sure what information I’m looking for on the ‘Network’ tab.
@morak
Create a sample report definition in that class and then include those embedded properties . If you are able to see the data in the report definition but not in insights , then it might be the bug in insights.
But if you are unable to get any data even with report definition then problem might be the either properties are not optimized properly . Could you please try these things.
Optimize the properties again
Save the class instance / data base table instance
Try running a SQL query to check if u are able to query the optimized embedded property data
I created a report in the applicable work class. In the report, on the Data Access tab, I added a declarative index join to the page list property - and then added the page list property fields to the report. When I run the report, I do get data back.
I also created a Connect SQL rule and was able to get the data back and see it on the clipboard.
However, it’s still showing up as bank in Insights.
