If I export a FR in "Export in query Mode" , it concatenates the parent with the child (parent.child) and does not return anything in Smartview. Even though the report works fine in workspace.
I narrowed down the issue and it seems if I use Stored member roll up instead of using Shared member roll up it returns the right data when I export the report in Smartview.
So the issue is only with the FR using Shared members.
Does anyone know if this is a known issue or can replicate this in their environment ? We are on version 22.214.171.124