Splitting/dividing infocubes

[Former Member]

Hi SDN Community,

I am doing an internship (1 year) in the BW department.

The topic of this internship is performance improvement in SAP BW an

especially on Queries.

In our BW there is only one InfoCube for all reporting years, which isn´t very fast

(that´s what I learned so far from you guys at SDN).

My main objective is to segment this InfoCube into InfoCubes for each year.

As I am totally new to SAP an especially to BW, finding information about this topic

is not that easy.

I would appreciate any help, links or material where I can find solutions or suggestions.

(reporting rules, can I take the old Queries?, what about the filter in the queries?, ...)

best regards

Torsten

[Former Member · Accepted solution]

Hi Torsten!

Start taking a look here...

https://www.sdn.sap.com/sdn/developerareas/bi.sdn?page=bi_performance.htm

hope it helps!

Bye,

Roberto

[Former Member · Accepted solution]

thx for the first help,

another topic will be, as i will have to write an thesis about my internship, how to measure performance improvement.

Are there any tools? (or do I have to sit with a clock in front of my pc)

[Former Member · Accepted solution]

Hi Torsten,

Don,t use your clock!! Use BW technical content, which collects all the performance key figures You need. Look for "How to Paper" on Service.sap.com

[Former Member · Accepted solution]

thx,

I was just kidding with the clock...

[Former Member · Accepted solution]

I need to create a SAP note. I've tried to enter in SAP Service through SAP Session but it doesn't work.

My account doesn't allow me to search notes and to create messages using SAP but it brings me to SAP Service MArketplace.

How can i craete a message with my account?

Please help me! It's URGENT!!!!

[Former Member · Accepted solution]

Torsten -

The BW Statistics info (assuming your site loads the Technical Content cubes) has a lot of query performance data. Tran ST03N in Expert Mode can provide summarized query perfromance info. Table RSDDSTAT (browse with SE16) captures the atomic query data that eventually gets loaded to the BW Tech Cont cubes. It will identify DB, OLAP, Master Data, Authorization, Front End time components of query response. It's worth a look to be sure you understand where your processing is taking time.

I would make sure you have compressed cubes and created aggregates before I would go to the trouble of splitting the cube. I would review the data model for the cube as well. A bad data model is a bad data model, whether the cube is split by year or not.

You might want to search the forum and SDN on query performance. There's lots of material out there.

[Former Member]

Hi Torsten,

Welcome to SDN!

Shortly, one of the ways I’d propose:

Create copies of your cube (I assume one cube for each year). In update rules of each cube (most likely in start routine) filter data by dates belonging to the particular year.

Load data from the original cube to all copies.

Create a multiprovider on all your new cubes. Make proper identification and selection of chars and key figures (each of them must be selected in MP).

Copy queries from an original cube to the multiprovider. I think all the filters in the queries will remain.

Best regards,

Eugene