Wednesday, June 22, 2011

OBIEE ODI Lineage setup

When setting up a OBIEE ODI Lineage RPD you might get the following error:

ODI-50036: Error creating V_LINEAGE_HIERARCHY Table. Check the logs.

image

The error might fool you. It means that your (work) repository schema doesn’t have the right to create a view.

Ask your DBA to run the following script:

grant create view to snpm1;
grant create view to snpw1;

Till Next Time

1 comment:

  1. Nice Information Sir.
    Kreesh:Integration between ODI to OBIEE11g successfully completed. All reports and Dashboards are working fine.
    We are facing so many issues but finally we succeeded.Default all lineage reports are working .I have one question here,Could you please help us ASAP

    Is it possible to create a report for the reports to select a column they see in the presentation catalog and show them the source column and table information and the transformations?

    I am looking for a report where the users can enter the source table and column and get the presentation layer information including all the transformation it has gone through and vice versa.

    ReplyDelete