Partitioning InfoCubes

[Former Member]

I am making a change to separate our CCA Plan and Actual data into separate cubes, and also moving different years of the Actual data to separate cubes. I will be doing the homogenous partitioning, so I'll have several identical cubes. I can't remember if a datasource is only available once for an InfoSource, but I think it is.

If it is true that one DataSource to one InfoSource, then what is the best way to load the other cubes with their year's worth of data?

Thanks, Keith

[Former Member · Accepted solution]

Okay, thanks. We are on 7.0, but have just got there a couple months back, and we have not done anything using 7.0 transformation rules. I would like to do this change using 7.0. Can you point me in the direction of good documentation to do that?

[Former Member · Accepted solution]

http://help.sap.com/saphelp_nw70/helpdata/en/b2/e50138fede083de10000009b38f8cf/frameset.htm

[Former Member]

Hi,

datasource->InfoSource (one datasource only to one InfoSource;

InfoSource->datatarget1

->datatarget2

->datatarget3

...

One InfoSource to feed many datatargets in your case cube.

So you can with one Infopackage select from that datasource using that infosource select data from one year but feed one cube and with another infopackage select from that same datasource using that same infosource select data from another different year but feed antoher cube and so on.

Diogo.

[Former Member]

You mean I can go from the DataSource to multiple InfoSources? Then at the InfoSource level, determine the data I want going to each cube?

[Former Member]

No. I mean go from datasource to one infosource.

Then from the infosource go the respective cubes.

If you are on 7.0 you do not need infosources if you do not need them.

[Former Member]

You can go from that Infosource to how many ever data targets (cubes) you need. No problem.