Multicube Performance

[Former Member]

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

[former_member181964]

Hi,

Build Indexs on Both Cubes.

You schedule the report in Background i.e. before user will execute the report, you schedule it in background then the data will store in Cache and second time users will run the report then it is fast this is the one of the best way to reduce the complaints from Users. It is common, we need to face it and do the things.

Thanks

Reddy

[Former Member]

Thanks for replying me Reddy.

I'm interested to execute report by scheduling in background.

Sorry, but how to do this?

Regards,

Steph

[Pravender]

You can create a broadcast setting and populate the cache for a report.

[Former Member]

Do you mean using BEx broadcaster option in BEx Analyzer?

I still not get the point, do you want change user behaviour by pushing report to their email using broadcaster?

Regards,

Steph

Edited by: Steph on May 14, 2010 9:29 AM

[Pravender]

I meant Broadcaster option in Bex analyzer only.

I didn't mean to sent report to user via e-mail. When you will create a bex broadcasting setting, then there is an option to populate cache only. Which can be scheduled for any interval.

[Former Member]

When I go to Broadcaster Setting and click Create New Setting, the only option that show in Distribution Type is Broadcast Email with an output format are MHTML, HTML or Online Link to Current Data.

Where is the option to populate cache only? Please help.

Regards,

Steph

[Pravender]

Are you using BW3.5?

In BI7, under distribution type we gets following options:

Broadcast E-Mail (Bursting)

Broadcast by Exception

Broadcast (Multi Channel)

Precalculating Value Sets

Filling the OLAP Cache

Filling the MDX Cache

You have to use "Filling the OLAP Cache" option for Distribution type.

[Former Member]

I'm using BI7, I think there is additional setting to show this option in basis side.

Do you know that?

Regards,

Steph

[Pravender]

You need object S_RS_ADMWB with field RSADMWBOBJ = BR_SETTING for the things you mentioned but not sure about the authorization objects for other things. You can try with SAP_ALL.

Also check OSS Note 760775 (3rd point).

[Former Member]

Thanks Pravender, but it's not working, still showing only "Broadcast Email" in Distribution Type.

I already have SAP_ALL (include S_RS_ADMWB of course).

Regards,

Steph

[Former Member]

Regarding my question about multicube performance, don't forget to compress your infocube!

I really forget this thing, after I compress the infocube, the report performance is more better now.

But I still investigate how to run report in background and store it in cache.

Regards,

Steph