Data load from DSO to CUBE fails

[Former Member]

I have a DSO which has 2 key fields - CUSTID and MATID and two key fields - Quantity and TotalSales. I have loaded some sample data from a flat file like the below

CUSTID                MATID                    QUANTITY                    TOTALSALES
C01                      M01                        PRINTER                      1000                                               
C02                      M02                        MOUSE                          500                                                 
C03                      M03                        KEYBOARD                    750                                                  
C04                      M04                        MONITOR                      1500                                              
C05                      M05                        HARDDISK                       800

And then I have created a InfoCube with 2 Dimensions - CUSTOMER and MATERIAL

CUSTOMER dimension has CUSTID as its InfoObject

MATERIAL dimension has MATID as its InfoObject

Now when I load data from DSO to InfoCube, it fails with the error - Process Terminated

But if I then move the MATID into the CUSTOMER dimension and delete the MATERIAL dimension and subseqently load data from DSO it succeeds.

I want to know the reason it fails as the system does not give any meaningful message

[Former Member · Accepted solution]

Try running the dTP in debug mode .

Go to Execute tab -> change the processing mode to 'Serially in the dialog process(for debugging).

[Former Member]

All,

I am not sure what went wrong in the first place. I deleted the data and repeated the steps and it did work this time. Thank you all for your suggestions

[Former Member]

Since Quantity is a keyfigure, it should have input in numbers ..

One reason can be because it tries to input text in quantity key figure ,

the solution can be : 1) make a new characteristic for quantity data and include it it material dimension

2)change the values of keyfigure instead of Printer,mouse and so on to numbers quantity values such as 10,20 etc .

Another solution can be :

1. Either mark both the dimensions as Line item dimensions so that it includes only one characteristic as the values in flat file are unique for both material and customer (the line item value can be seen in display infocube - dimension customer->right click properties .

2.Keep the structure as it is and try repeating the values for material , for e.g. M01 for both customer C01 and C02 .

[Former Member]

Hi Amrita,

My mistake. I put the wrong details in the post. The Quantity indeed had numerical values. I will try all options suggested - debugging, getting the exact error message or making the DIMENSION as line item. But what is intriguing is, why would the load fail if the Cube has 2 DIMENSIONS(with CUSTID and MATID in separate dimensions) and succeed if it has 1 DIMENSION (with both CUSTID and MATID in the same dimension). Any thoughts on that?

Edited by: srsapbibw on Feb 22, 2011 7:44 AM

[Former Member]

Hi

have you tried doing RSRV check for cube when you have 2 different dimensions??

might find something there.

Regards

Sudeep

[Former Member]

Hi Sudeep,

What is RSRV check and what is the procedure for doing it?

Thanks

[Former Member]

Hi

RSRV transaction is very suefull for checking such consistency problems.

goto RSRV transaction and select complete check and give cube name.

its very simple transaciton to use.

Regards

Sudeep

[former_member197993]

Hello,

Please provide the exact text of the error message you are getting for the failed data load,

and also the error code associated with the error.

Thanks and Regards

Barry