How to tell a Webi report to use a specific index

[shlomi_weiss2]

Hi

I have some Webi reports over a IDT universe on SQL server

I want to be able to tell each report to use a specific index

Is it possible? how?

Shlomi

[sateesh_kumar1]

Hi Shlomi,

To use index defined at database , we need to add that index object as primary key to the objects in universe.

Then if we the objects created with Index defined in webi , webi will leverage indexing of DB.

[shlomi_weiss2]

Hi Sateesh

Thanks for the quick response

But my indexes are not unique and are combined from more then 1 field

Ho do I do it in those cases?

Shlomi

[sateesh_kumar1]

We can add as many as keys .Just click Add Key and add .