Skip to Content
0
Former Member
May 12, 2010 at 04:04 AM

Multicube Performance

23 Views

Dear All,

I have performance issue in one of my query.

This query is build from MultiProvider, which is contains 2 InfoCube.

What I'm already do:

1. Build aggregate in each infocube and when I check via RSRT, they found it.

2. Check related master data, infocube and query via RSRV and all object are fine.

3. Setting Read Mode and Cache Mode in query properties.

I choose Read Mode = H - Query Read when you navigate or expand

and for Cache Mode = 4 - Persistent Cache Accross Each Application Server, since this query is accessed with many user.

4. Recreate DB Indexes and DB Statistics in tab Performance (InfoCube - Manage) for each infocube.

5. Check via DB20, DB Statistic for related table (fact and dimension) is up to date.

Is there anything else that I can do? I already frustated with user's complaining in this week.

Really appreciated any kind of helps, Thanks.

Regards,

Steph