Master Data Load Indexing Problem in BIA.
I have Master Data Loads (full) happens at night at least for 3 hours. After it completes, there is a bia index will start and it takes more than 1.5 hours to complete the index and do a rollup. During this time, when user access their queries, its getting timed out. Because, it couldn't able to use the BIA and the query enrouted to BI infocube. This infocube doesn't have aggregates. Becuase, we are using BIA.
Can any one suggest how I can resolve this issue?