🚨 Unknown Member error in Financial Reporting Studio Reports
🚨Common issues in Financial Reporting Studio Reports🚨
💭 A) Error executing query:Error:Internal Essbase JAPI error:[Cannot perform cube view operation.Essbase Error(1260046):Unknown Member 3-XXXXXX,51362DE2312B57A7E05384C72E0AC338 used in query]
Cause 1: Member "XXXXXX" is expected in segment3 from respective tree version which is missing. Hence, "XXXXXX" is identified as unknown member in report.
🛠️ How to resolve:
- Go to "Manage Account Hierarchies" task in Setup and Maintenance
- Search for respective Tree and select Tree Version
- Verify the value exist in respective tree version or not. In given example, value supposed to search is "XXXXXX"
- As
0