Skip to Content
author's profile photo Hari M
0
Hari M

Start Routine in Transformation

Posted on Aug 23, 2016 at 07:30 AM 16 Views

Hi Friends,

I have wrong data in first level DSO and it passed to till cube and report showing wrong data.

This i can solve by using selective deletion in all layers, but i want to do through routine in transformation for permanent solution.

Wrong data is: Few plants having wrong currency, now i want to delete it, so how can we achieve this?

Thank you.

Regards,

Hari

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Aparajit Banik
    Aparajit Banik
    Posted on Aug 23, 2016 at 08:08 AM
    0

    routine will slow down abit in performance.
    did you think it to achieve by filtering out the currency which you dont want.
    Delete and reload by filtering the data in DSO and then to cube. (my understanding may be wrong as I am not getting exactly where the issue is)

    As you said :Wrong data is: Few plants having wrong currency, now i want to delete it,


    Do you mean the wrong currency is coming from the source.please check datasource PSA and then R3.Verify once. If the wrong currency is on BW side and you want to replace the currency with the correct ones then its different work around. Is it local currency or document currency or which one?







    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Hari M
      Aug 23, 2016 at 02:18 PM

      Hi,

      If you delete the records or make 0 the KF, the report is correct?, the total amount is the right one?

      If you can delete the amount, then

      Other approach instead of routine is to create a FORMULA in transformation... In Currency object create an IF condition based in PLANT.

      Regards.

      Ps. You can also do a conversion from Local Currency to other currency in DSO-Cube Transformation IF it is the case.

    Comment on This Answer

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.