Symptom
- An error occurs when some values of an analytical dimension are aggregated in the schedule axis, either manually or with a custom member.
- The error message displayed is "Unable to obtain the current member because a non-aggregatable attribute has a calculated member coordinate from a different hierarchy".
- The issue occurs when multiple members of a specific dimension are placed in the page axis. Placing a single member and refreshing does not cause the problem.
- The issue does not occur for all users. There are some users who can refresh the report without encountering the issue.
- The issue was observed since November, following a major Windows update.
Environment
- EPM Excel Client - SP38
- SAP BusinessObjects Financial Consolidation
- SAP Financial Consolidation
Reproducing the Issue
- Create a custom cube (without Cube Designer) based on FC data.
- Use the EPM to retrieve data from this cube.
- Aggregate several values of an analytical dimension in the schedule/page axis of the report.
Cause
There is a difference between the client parts of SSAS on the different stations. Error message is not an EPM add-in one but from SSAS.
Resolution
1) Update the workstations.
MS page on SSAS client libraries: Analysis Services Client Libraries | Microsoft Learn . There is a link to download
https://learn.microsoft.com/fr-fr/analysis-services/client-libraries?view=asallproducts-allversions
2) Microsoft KB : KB2531172 - FIX: "Unable to obtain the current member" error when you run an MDX query in SQL Server 2008 Analysis Services or in SQL Server 2008 R2 Analysis Services - Microsoft Support
https://support.microsoft.com/en-us/topic/kb2531172-fix-unable-to-obtain-the-current-member-error-when-you-run-an-mdx-query-in-sql-server-2008-analysis-services-or-in-sql-server-2008-r2-analysis-services-f3e22424-fc70-f987-3caf-ca48bde245a4
See Also
Keywords
EPM report, error message, analytical dimension, aggregated values, schedule axis, custom member, dimension ODG, page axis, Windows update, EPM Excel Client, SAP BusinessObjects Financial Consolidation, SAP Financial Consolidation. , KBA , EPM-XLS , EPM Excel Client , Problem