yeah.. indexing is basically all automated.. you don't create index per se.... because cube is really for aggregated results.. not to find a single entry (like relational index)

to speed up query .. you go with aggregations..

with aggregations.. you first go through the wizard.. then you use query log to perform "usage based optimization".. then you design your own..

I usually just do usage based optimization as it's easy and to the point.