3023754 - Unable to switch on ENABLE_HANA_MDX - BPC NW

• When activating model parameter ENABLE_HANA_MDX, error occurs. Runing program BPC_MIGRATE_TO_HANA does not help.
  UJA_DATA_CHECK  Invalid measure formula existed in model MMMMMM
  UJO_READ_EXCEPTION MDX statement error:"MDX SYNTAX CHECK WITH MEMBER [Measures].[PERIOD"
  E 000 E::000
• SM21 shows the following errors.
  > sql processing error: Error occurred while executing a MDX
  > statement. The error message is: Internal error during
  > hierarchy operation. Found invalid base object with the ID
  > 3290431 for the hierarchy dependency name:
  > "SAPHANADB"."$MDX/EEEEEE_MMMMM/SAPHANADB/$BPC$V
  > LAP_T3IAYIY/DDDDDD/hier/PARENTH9" oid: 4148561
  EEEEEE = environment name, MMMMMM = model name, DDDDDD = dimension name
  
• In HANA indexsever_alert file, error below can be find.
  Error occurred while executing a MDX statement. The error message is: Cube EEEEEE_MMMMMM could not be found. Please check if the Cube is valid and exists. The detail error message: Error building hierarchy definition for PARENTH9 for cube EEEEEE_MMMMMM dimension DDDDDD: Hierarchy View BPD::SAPABAP1:$MDX/EEEEEE_MMMMMM/SAPABAP1/$BPC$V$XXXXXX/DDDDDD/hier/PARENTH9en for cube EEEEEE_MMMMMM source query execute error: Source query execution error on [DDDDDD].[PARENTH9]: error:SQL: invalidated view: $BPC$J$XXXXXX900000000: line 1 col 352 (at pos 351)
• Sometimes, ENABLE_HANA_MDX is switched off after transporting some dimensions.

• SAP Business Planning and Consolidation 11.X, version for SAP BW/4HANA
• SAP Business Planning and Consolidation 2021, version for SAP BW/4HANA

EPM, BPC NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, ENABLE_HANA_MDX , KBA , EPM-BPC-NW , NetWeaver Version , EPM-BPC-BW4 , BPC/4 , Problem