Infocube Partitioning

[Former Member]

Hi,

I want to partition an infcube by Fiscal Period. Since it is compunded with the variant, per SAPs recommendation I need to assign a constant to the Fiscal Variant object.

Refer Link Below.

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/f80a3f6a983ee4e10000000a1553f7/frameset.htm

My Question is :

If I set the provider specific property as a constant for the fiscal variant, what would happen if a new different value for the variant came in from the data source?

Anyone has any ideas?

Thanks

Shailesh

[Former Member]

Hi:

The correct link is:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/bff13df2-0c01-0010-6ba7-bc5...

Regards -

Ron Silberstein

SAP

[Former Member]

Hi Shailesh,

Can u bit more explain, how ur going to partition the cubes? is it from the option, Extras-> partition in the cube screen or will you going to have different cubes for different fiscal variant?

If you are planning to select the second option, just what u have to do is create number of cubes equals to the fiscal variant and in the start routine of the update rule, just restrict the record to that particular fiscal variant. Now you can give the fiscal variant a constant value since you are restricting it on that particular value. If the fiscal variant has some other value, its not relevant to this cube but will get into some other relevant cube.

Sriram

[Former Member]

Currently I have just one cube and currently there is data for just variant. In case a new company is created in R/3 with a new variant and new Co-Area, and the data flows into my cube, what would happen ?

[Former Member]

HI Shailesh

If you have assigned a constant against the infoobject in update rules, then some other company code willl also go in as the hardcoded company code. I dont think this is a gud design. So for this perpose, you can create multiple cubes, one for each company and in the start routine put a check on company code.

Hope i annswered youyr point. Please elaborate if i'm not.

Sriram

[Former Member]

Thanks Sriram. You did answer my question.

[Former Member]

Just to clarify, based on testing this is not it works. If you set a characteristic as constant in the infoprovider and then load data into it which has values different from the same. The load will fail for those records.

[Former Member]

Hi Shailesh,

You can have have dat in same cube also.

Instead of putting a constant write a routine.

If you get values from the source then use that else use the defaulted value.

Check this in update routine and write the code accordingly. if the value coming from source is empty put the defaulted value.

Hope this is what you are expecting.

Mey