Solution : https://service.sap.com/sap/support/notes/1068324 (SAP Service marketplace login required)
Key words : 
cases hierarchy queries, correction instruction attached, prerequisites program error, stale temporary views, program error, temporary views, stale 03 -views, system shows, terms query, view reason
Related Notes : 
       
| 449891 | Temporary database objects in BW 3.x |