Drill through from smart view with special characters in source table
Hi All,
We are running drill through from smartview (drill through query developed in essbase studio).
Issue:
When we run drill through from smart view , drill through reach out to GL table and bring back results.
we are receiving error 'SmartView XML Load Error: "An Invalid Character was Found in Text Content' because there is a special character in one of the GL member description.
if we replace special character manually in the GL table drill thought working without any issue. But this is not a good practice because we are changing source.
And we are not loading these GL alias names into our application.