problem loading data

[Former Member]

i have a problem . i am uploading a data into one of the custom cube . i am using extractors 2lis_03_bf,2lis_02_scl,2lis_13_vditm , when i upload the data . i can fill all the data in the different feilds . but when i see for some custom defined charcters . no data avalible in cube but they r avalible in sid tables. now how can i pull the data from sid or charcters into cube . thanks in adavance . thank u

[Former Member]

Hi Veda,

Have you solved your problem?

Best regards,

Eugene

[Former Member]

Hi Eugene thanks for asking. Problem not yet solved. I have a problem loading data into material through one of the department. . I have edit records for that particular record and forced it in. now i can see the data for my objects in 0material masterdata .coming to cube still i am unable to load the data into cube. My idea was to just add the 0material into the characteristics of each update rule for 2lis_03_bf.2lis_13_vditm, 2lis_02_scl. Thinking when I run the package they will automatically update the cube with data. I don’t know whether I am right or wrong. If I am wrong. plzLet me know. thnak you .or anything do be done to get the data from 0materil to cube.

[Former Member]

Hi Veda,

The datasources you mentioned are transactional data DSs.

Do you use another DS for loading 0Material? If you use just DSs for transactional data then they will create records in master data of 0Material (if there is an option in the Scheduler) without populating attributes.

Best regards,

Eugene

[Former Member]

hi Eugene

yes i am using only 3 datasources . and i dont have any option (if there is an option in the Scheduler) without populating attributes.now can u let me know how can i populate the masterdata of 0material for my objects in the cube.that would be greatly appericated . plz be bit detail b'cause i am new to bw plz thank u

[Former Member]

Ok, Veda.

In your R/3 system run tcode RSA5. Locate 0MATERIAL_ATTR and 0MATERIAL_TEXT datasources under SAP-R/3 - LO - LO-IO node. Click on 'Trans. DataSources' button for each of these DSs.

Then replicate DSs in BW etc.

You have to load data into 0MATERIAL BEFORE transactional data load.

Best regards,

Eugene

[Former Member]

ok Mr Eugene . i want to know one thing can i ur email id i can send u email in detail b'cause this is going very long . and today i am assigned for some reports. really thanks for ur help

[Former Member]

Veda,

You can mail me to ekhu2004@yahoo.com.

Best regards,

Eugene

[Former Member]

Hi Veda,

For getting what you want you have to load, first of all, master data for 0Material. Only after that you can load data into your cube.

That example of the transfer rules that you provided is in the 0Material loading process or in the cube loading?

How do you load 0Material?

Best regards,

Eugene

[Former Member]

Hi Veda,

This is unnecessarily getting too long.

It would help us if you could just write down in points, step by step, what (and how) have you done so far.

Pls be elaborate in your writing, it may take some more time. But atleast we'll come to know the problem.

Regards,

Vikrant.

[Former Member]

Hi Veda,

Just need a little confirmation from you, have you written any code in user-exit to populate your 'custom' fields? Can u see data for your custom fields in R3?

Pls do the extraction check in RSA3 in R3, and check whether data for your custom fields are retrieved correctly.

This would help us in pin-pointing the area where we can look fwd.

Regards,

Vikrant.

[Former Member]

Yes Mr.Vikranth i have return the user exist to populate the data and i went to the rsa3 and checked the data is perfect in the r3 . for my charcters. now i have data in the bw charters for charcters Z0260,Z0261, etc . there i have data . now how can bring this data into the cube . these allr navigational attributes .in the cube . i want to populate the data from my charcterstics into the cube . thanks in advance .

[Former Member]

Hi,

in this case, you need to activate the new objects as nav.-attr. in the attributes of your infoobject as well as in the cube. Therefore: In RSA1 goto your cube, right click on it and choose change. Click on the button Nav.Attributes and check the box for your required objects.

It might be necessary to do another 'change run', but normally not.

Now you will see your objects.

regards

Siggi

[Former Member]

hi i can see my objects r already selected has navigational attributes in the cube . but i can see the data for my charcters in infocube . when i go to infocube select the infocube contents . and select the chacrter . there i can see the data . when i select sid charter i cant see the data in the output. i am very sorry perviously i told i see data in sid. can u help . is this clear .thnaks in advance

[Former Member]

Hi,

for me this seems to be a bit of a mixture about attributes, nav-attributes, master data and transactional datasources.

If you have your new objects already available as nav-attrs in your cube, I can only imagine, that you didn't load master data or you didn't do the mapping for your new fields in the transfer rules.

Which datasource did you enhance? The one for the transactional data (the one going to the cube) or the one for the master date (tho one going to the infoobject that carries the new nav.-attrs)?

Please let me know.

Siggi

[Former Member]

yes master data is loaded for all the charcters and they r assigned to 0material in the transfer structure . and written code for each charc ex:- for char 0260. and changes on for other charcters also .

move TRAN_STRUCTURE-matkl to l_pz0264.

select /BIC/ZNEXTLEVL from /bic/pz0264 into l_pz0263

where /bic/z0264 = l_pz0264.

endselect.

if sy-subrc <> 0.

RESULT = ''.

RETURNCODE = 4.

ABORT = 4.

else.

select MATL_GROUP from /bic/pz0263 into l_pz0262

where /bic/z0263 = l_pz0263.

endselect.

if sy-subrc <> 0.

RESULT = ''.

RETURNCODE = 4.

ABORT = 4.

else.

select matl_group from /bic/pz0262 into l_pz0261

where /bic/z0262 = l_pz0262.

endselect.

if sy-subrc <> 0.

RESULT = ''.

RETURNCODE = 4.

ABORT = 4.

else.

select matl_group from /bic/pz0261 into l_pz0260

where /bic/z0261 = l_pz0261.

endselect.

if sy-subrc <> 0.

RESULT = ''.

RETURNCODE = 4.

ABORT = 4.

else.

• there is no higher hierachy, so go out of here.

if l_pz0260 = ''.

RESULT = ''.

RETURNCODE = 0.

ABORT = 0.

exit.

endif.

select matl_group from /bic/pz0260 into l_pz0260help

where /bic/z0260 = l_pz0260.

endselect.

if sy-subrc <> 0.

RESULT = ''.

RETURNCODE = 4.

ABORT = 4.

else.

RESULT = l_pz0260.

RETURNCODE = 0.

ABORT = 0.

endif.

endif.

endif.

endif.

endif.

[Former Member]

Hi,

instead of checking your cube content, did you check the master data of 0material? Are the fields populated with the values you expect?

Additionally: are you running a query on the cube itself or on a multicube? If you are on a multicube, you need to add and identify the nav-attrs in the multicube as well.

regards

Siggi

Message was edited by: Siegfried Szameitat

[Former Member]

yes siggi ur right i cant see my data in the 0material . i right click and maintain master data i cant see the data for the charcters . where would have i went wrong

[Former Member]

Hi,

there can be a few reasons.

As you are selecting the data for the new fields out of the master data tables within BW, there might be no entries in these master data tables. Check them out.

I would recommend to debug the transfer rules for some special records, to also see if your coding works. You can do this (if you load to PSA first) by going to the monitor for the request and in the detail tab right click on the data package and choose simulate update. Then choose debug transfer rules.

Hope this helps!

regards

Siggi

PS: Don't forget to assign some points. This one is really time consuming!

[Former Member]

hi i have assigned u points but still my query is not solved can u . i tried everything to get the data into the material but i am unable to . i dont know the reason everything is perfect with the chars and i have loaded data into all chars and assigned them to 0material . and return routines. which i have sent u erlier . but still if i maintain masterdata i cant find charsdata in the output . how to bring the data into the 0material chars .

can u let me know siggi thanks in advance

[Former Member]

Hi,

did you activate your data? In rsa1, goto infoobjects->0material, do a right click and choose activate master data.

regards

Siggi

[Former Member]

yes i have done that

[Former Member]

Hi,

are you sure, your data is active in the cube (available for reporting)? Check it out in the request tab of the cube administration. Additionally, did you run your 'attribute and hierarchy change run'? If not, do so now. In RSA1, goto Tools->Hierarchy/Attribute Changes.

regards

Siggi

[Former Member]

siggi thanks for replay but that doesnt solve my problem .

my problem . i have the data in sid table for created charcters such has department subclass etc . the thing is when i go to cube and see the contents of the cube i can see the related chars have the data in sid table but when i go to cube and see they r no data . is there anything to do with update rules . or do i need do anything else to get the data from sid to cube .plz help aa

[Former Member]

Hi,

so if you see the data in the cube content I think there is an issue with activation. Do you have aggregates on your cube? Are the requests rolled up into the aggregates?

Let me know.

regards

Siggi

[Former Member]

yes siggi

i have rolled up the aggregates . but still i ant able to fill the department subdepartment class subclass which were created by me . do i need to right any upadate rules for them in the extractors to upgrade to the cube .

thanks look forward to ur replay

[Former Member]

Hi,

can you please tell me what you did so far?

1. You enhanced the datasource

2. you added some coding in the user exit to populate the new fields

3. you replicated the datasource

4. you added infoobjects to your infosource and mapped the new fields to the infoobjects in the transfer rules

5. you added the fields to your cube and you did the mapping from infosource to cube in the update rules

Did you miss one step? Did you do more?

Let us know.

regards

Siggi

Message was edited by: Siegfried Szameitat