BPC EPM Find Hidden Hierarchies in the Excel Sheet

Hi experts,

How should I check the hierarchies of different cells in the excel sheet? As you can see from the screenshot, it only shows PARENTH1 without showing the other four, in which case all five hierarchies exist. Is there any way I can find out all the hierarchies without checking BW? Thank you.