SID Generation failure- Flat file

[Former Member]

Hi All,

I am doing a flat file load and i loaded the data successfully to DSO and then when i am loading to cube i am getting SID Generation error. It  says " No SID found for value 'gbp' of characteristic 0CURRENCY" The error screen is as follows. Please look into my issue..

Thanks,

Karthik

[former_member214415 · Accepted solution]

Hi Karthik,

Answers:

1. Yes, when you are using 0currency info object then it is necessary that currency For Ex: GBP should be maintained in TCURC Table in source system so check its available or not. If it is not there do the manual entry. Then you have to do this activity at BW side, Go to RSA1 - Source System - Select ECC - Right Click and select Transfer Global Setting - Rebuild the table.

2. if you have different currencies available for different key figures then you can create custom currency info object. But if it is quantity  key figure then you have to take 0unit info object.

Thanks,

Swapna Jain

[former_member214415]

Hi,

Maintain data in flat file in Upper case letters and hopefully you have used 0currency info object for currency GBP. Might be this currency GBP is not maintained in TCURC  table so check there or else do the manual entry.

Regards

Swapna Jain

[Former Member]

Hi Swapna,

Thanks. I have a couple of questions.

1) If i am loading a flat file, is it necessary that the GBP should be maintained in TCURC table when i am using "OCURRENCY" as a unit? 

2) If i have couple of currency key figures in flat file, can i use "0CURRENCY" as unit for both the key figures and load it to Targets?I think we have to use different Currency units like " 0LOC_CUURRCY" "0DOC_CURRCY" etc for different currency key figures, or else it will fetch an error. What do you say? I am facing this issue since yesterday..

Thanks,

Karthik

[RamanKorrapati]

Hi,

Seems like your new to bw. Are you working some where or doing won practice?

You need to understand some basics here.

Lets take examples

Key fig - 0AMOUNT, amount always comes with currencies like INR, USD,JPY..etc.

Another key fig type - 0QUANTITY, quantity always comes with units like KG,LTR,GM....

Based on your structure you can use currency or unit.

Questions.

1. If we want load currencies into bw then first we need to maintain them table levels. other wise we get sid generation issues. its basic things.

2. if you have multiple amount key fig in your structure then you can use multiple currencies.

one is 0currency and another create a custom one as zcurrency. 0loc_currecny and 0doc_currency not useful in your case.

Thanks

[former_member227168]

Hi karthik,

Can you explain what is "gbp",

your loading in DSO (Write optimezed) system will not generated SID,

when loading time before system will generated SID in CUBE level,

Please can you maintian flat file level GBP as a capital letters and load it once.

Thanks,

Ram.

[Former Member]

Hi Ram's

This is my flat file. Is there anything wrong with this. Its been long time since i have done a flat file load.

Getting struck here. Please check.

[Former Member]

Hello Karthik,

Maintain the data in UPPERCASE or check LOWRCASE checkbox option in your InfoObject. It will solve your problem...

Thanks

Ajay.D

[RamanKorrapati]

Hi,

What info objects yoy used in cube?

gbp is currency or unit?

Flat file shows as unit, but error shows as currency.

Can you check on that.

Lets assume as currency.

then have you maintained master data for 0currency?

if not then have you loaded currencies from ecc thru transfer global settings?

please check, whether currecny gbp is exist in bw side or not.

if they maintained as GBP then you can change your flat file data.

Thanks

[former_member227168]

Hi karthik,

your used key figure GBP is unit mesure or char,

flat file loading time its working fine,

when conversion time it will show error updated data in cube level.

1.you should maintian conversion currecy fields,

2. If info object is CHAR in cube level or DSO level u should maitiain small letter not allowe so maintian Info obeject level upper case click.

I have attached Exp file below the same.

Thanks,

Ram.

[Loed]

Hi Karthik,

Try to upload your data in CAPITAL LETTERS..I think no 'gbp' was found since you have GBP in your UNIT/CURRENCY measure..

Regards,

Loed

[KodandaPani_KV]

Hi,

GBP - is the currency

while load to BW system using flat file data source and flat file structure both are same structure.

use the 0CURRENCY info object while designing the data source.

check the data source preview data then check the PSA data.

thanks,

phani.

[Former Member]

Hi Phani,

Thanks for the response. If i have couple of currency key figures in flat file, can i use "0CURRENCY" as unit for both the key figures and load it to Targets?I think we have to use different Currency units like " 0LOC_CUURRCY" "0DOC_CURRCY" etc for different currency key figures, or else it will fetch an error. What do you say? I am facing this issue since yesterday..

Thanks,

Karthik

[former_member182346]

Hi,

Seems like UOM is not updated in BW w.r.t. ECC.

Go to RSA1 - Source System - Select ECC - Right Click and select Transfer Global Setting - Rebuild the table.

Then Try again to load the data in Cube.

I assume the DSO request is active only.

Thank-You.

Regards,

VB

[Former Member]

Hi Vinod,

In DSO it is loaded sucessfully. But in cube i am getting the issue. Can i create a new unit and assign to keyfigure rather than using ocurrency?

Thanks,

Karthik

[former_member182346]

Hi,

Just try to rebuild the global setting as mentioned earlier and see.

It should work.

Thank-You.

Regards,

VB

[Former Member]

Hope below thread will helps you