performance of query

Hi BW Experts

when i try to execute the query it taking lot of time but this cube(0FIAR_C03) contains 6crore records .i created aggregate on this cube and iam deleting and recreating index also but no good performance .even iam entering small selection period also . i gone through previous forums but i did'nt get any solution.Can you please guide me any one on this issue.

Regards

RK