2527997 - [Error] Internal error during hierarchy operation. leveled node id creation requested without valid nodestyle specified

When you speciy level hierarchies in the Excel MDX (Drag and drop to the columns or rows fields), Excel generates error message saying:

If you see the index server trace, you will find the similar error message saying:

[8784]{324979}[38/-1] 2017-08-31 09:32:39.752445 e hierarchies      Exceptions.cpp(00019) : Exception occurred: exception  1: no.75000001  (hierarchies/InternalData.cpp:248)

    Internal error during hierarchy operation. leveled node id creation requested without valid nodestyle specified

[8784]{324979}[38/-1] 2017-08-31 09:32:39.752496 e mdx              hierarchyCacheManager.cpp(01209) : Hierarchy create error for "_SYS_BIC"."MTP/TIME_DIM/hier/HI_TIME" error: exception 75000001: Internal error during hierarchy operation. leveled node id creation requested without valid nodestyle specified

[8784]{324979}[38/-1] 2017-08-31 09:32:39.752821 e mdx              Executor.cpp(00183) : Error occurred while executing a MDX statement. The error message is: An internal error occurred. Assertion failed with error message Hierarchy cache reference is invalid for [TIME_DIM].[HI_TIME] : Hierarchy cache error:Hierarchy create error for "_SYS_BIC"."MTP/TIME_DIM/hier/HI_TIME" error: exception 75000001: Internal error during hierarchy operation. leveled node id creation requested without valid nodestyle specified

HANA Database server revision: 122.11
HANA Studio version: 2.3.27

MDX, Modeling, Level Hierarchy, nodestyle, name_only , KBA , HAN-DB-MDX , SAP HANA MDX Engine/Excel Client , HAN-STD-DEV-MOD , SAP HANA Analytical Modeling , Problem