Qualified Member Name from Reports output cannot be recognized when perform ad hoc analysis
Summary:
We move Financial Report to Reports then the output for member qualified name display only with dot and without bracket. This display cause error when perform ad hoc analysis for this report.
Example when we need to have output for Entity Dimension as follows :
Output from existing Financial Reports : [G007].[TH03]
Output from Reports : G007.TH03
Content (please ensure you mask any confidential information):
When the objective is to have output Entity dimension as qualified member name output in Reports then I use Custom Heading for the Column as follows :
Setting custom heading in Reports
Output from Reports for qualified member name cannot perform adhoc analysis as not recognized member and need to manually edited for the particular member