You can index the characteristic hierarchies for a hierarchy basic characteristic in BWA.
Indexing BW Data in SAP BW Accelerator