cancel
Showing results for 
Search instead for 
Did you mean: 

Load data from infocube

Former Member
0 Kudos

Hi,

I am trying to load the data from Infocube to Planning Area using tcode- TSCUBE.

I am seeing the message - 3468 combinationens of InfoCube are not contained in the BasisPlobStru.

Please explain me the meaning and tell me what needs to be done.

Also what is the date range we give in From and To field. date range of what ?

Thanks in advance

Prabhat

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

It means that infocube contains 3468 combinations that are not present in the MPOS. That is only a warning message and not an error message.

There are valid business scenarios where this message is acceptable.

For Example - You have 2 cubes.

1) History

2) Marketing adjustments.

You want to generate your CVCs only from your history Cube and are using Marketing adjustments cube only for loading and copying values.

Now in this case, if marketing sends data for couple of products for which there is no history, it means we have not generated CVCs out of those couple of products. Now when you try to copy data from the Marketing adjustment cube to MPOS, the program cannot find those couple of products to copy the data to. In such cases you get this message.

Incase you want to resolve this message, you have to generate CVCs from all of your cubes you are loading data value from and also for the entire horizon of the cube.

The From and To Dates determine the period for which you want to generate CVCs. For example assume there are 3 products P1, P2, P3

P1 has data between 01-2009 to 03-2009

P2 has data between 04-2009 to 06-2009

P3 has data between 07-2009 to 09-2009

Now in the from & to dates if you give just 01-2009 to 03-2009 only P1 CVCs will be generated.

Now in the from & to dates if you give just 04-2009 to 06-2009 only P1 CVCs will be generated.

Now in the from & to dates if you give just 07-2009 to 09-2009 only P1 CVCs will be generated.

And more than one will be generated if you overlap your from and to dates. Like if you mention 01-2009 to 12-2009 all CVCs for all 3 products P1, P2, P3 will be generated.

Hope this helps.

Thanks

Mani Suresh

Former Member
0 Kudos

Thanks a lot Mani for your detailed explanation.

I understood your point.

So 3468 combinations are not present in CVC. Fine but I should be able to see the values for the 2 combination what I have.

After running this process to load the data from infocube to planning area I go to the planning book then select the data view.

Then I double click the characteristics (product ) but I dont see any data in the keyfigure ( selected in key figure assignment ).

Am I missing something?

Thanks,

Prabhat Sahay

Former Member
0 Kudos

1) Ensure you have configured the correct versions for copying between infocube and PA.

2) Ensure you have those CVCs in the cube as well.

3) Check for which period you have the data and ensure that period is included between the From and To Dates of the Load data from infocube transaction.

Hope this helps!

Thanks

Mani Suresh

Former Member
0 Kudos

You mean to say that we should have all the CVC also maintained in info cube similar to MPOS.

But what if we are not giving the cvc condition to see the data in planning books.

Suppose if we have CVC - Plant Product Engine

PL, P1 E1

and in infocube we have Plant Product Engine Actual Orders

PL, P1 100

and then we load the data from info cube to planning area using TSCUBE then what should happen ?

In the planning book if we select product and give the conditions in selection profile like plant - PL so we should be able to see the data as I have not requested the condition to include Engine.

I should see Actual Orders (key figure ) to be 100 in my planning book.

NOTE : -- Plant,Product and Engine are characteristics.

Please correct me if I am wrong

Thanks a lot in advance for your help.

Prabhat.

Edited by: Prabhat Sahay on Sep 9, 2010 4:39 PM

Former Member
0 Kudos

If you copy P1 L1 = 100, it will copy at that level into the planning area.

Then in the planning book, if you choose P1 L1 E1, we have 2 scenarios..

Scenario 1 - There is only one Engine E1 under P1 L1 in which case 100 shows up.

Scenario 2 - There are multiple Engines E1, E2... En in which case 100 is disaggregated into lower value based on the disaggregation setting.

Hope this helps.

Thanks

Mani Suresh

Former Member
0 Kudos

Thanks Mani for your time and help.

I acknowledged your help

Edited by: Prabhat Sahay on Sep 13, 2010 8:52 AM

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

I guess you have loaded data in the Infocube and I assume that you are loading the data in DP planning area..

Next step here is to create CVC from that cube which forms the master data for DP planning area. Use /SAPAPO/MC62 to create CVC with the option of Create Characteristics Combination - load to worklist - Load data from InfoProvider.

Once CVC are created then try to load data in the planning area.

To and from date defines the date range of the data from the InfoCube that you want to load in planning area.

Thanks,

Amit Ranjan

Former Member
0 Kudos

Hi Amit,

I have already created CVC using Generate Immediately from infor provider.

There are 2 combinations but in infocube there are thousand of recordds but I got only 2 as only 2 rows had all the data.

Prabhat

Former Member
0 Kudos

sorry...I posted my comments twice.

Amit

Edited by: Amit Ranjan on Aug 20, 2010 9:21 AM