Skip to Content
author's profile photo Former Member
Former Member

SID Generation failure- Flat file

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

SID ERROR.png (176.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on May 15, 2015 at 06:47 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 13, 2015 at 11:15 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on May 13, 2015 at 08:26 AM

    Hope below thread will helps you

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 13, 2015 at 08:26 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 13, 2015 at 08:36 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Kodanda Pani KV

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.