BI4.0 Audit Universe on Oracle failing integrity check

[Former Member]

Hello,

I am trying to follow the Audit Universe installation steps as given in thread http://scn.sap.com/thread/3222860 but getting the below error in integrity check -

Regards,

Ameet

[Former Member]

Hi Ameet,

Check with the data foundation of your universe, to confirm the data foundation as in the snapshot

Open Business layer,goto change data foundation and select the Oracle Audit Data foundation from your project .

Change the Qualifier and Owner of the tables in Data Foundation by following below steps,

Right click on Table in data foundation

and select change Qualifier/Owner then select the Qualifier and Owner of the table.

Save the Business layer , check integrity now.

Hope above information helps you.

Regards,

Ambreen.

[Former Member]

Thanks a lot Ambreen,

This helped.

FYI for other users, you may need to Refresh Structure after the above steps in case there are a few errors.

Regards,

Ameet

[Former Member]

Hi,

As my information have helped you please mark it as correct answer and close the discussion.

Regards,

Ambreen

[Former Member]

Hi Ambreen,

I am unable to find the options to close discussion and mark your answer as correct answer.

Please suggest.

Regards,

Ameet

[Former Member]

Hi Ameet,

Please see this link

http://scn.sap.com/community/support/blog/2013/04/03/how-to-close-a-discussion-and-why

Regards,

Ambreen

[Former Member]

Dear Ambreen,

Sorry, I understand this can be annoying. But I am unable to
find the options/buttons to mark the replies as correct answer or helpful answer as
shown in the link

 

Not sure if this is something related to rights.

Regards,

Ameet

[Former Member]

Hi,

  i my case i am not able to change the Qualifier. shows disable also while checking the integrity i am getting error.

I am running with BO 4.1 with Sybase sqlanywhere.

Thnx

Sunil

[Former Member]

Hi Sunil,

Please check with your Database connection in IDT and Map the connection to data foundation and check.

Regards,

Ambreen

[Former Member]

Hi Ambreen,

  thanks for your reply.

  My database connection is already fine. its shows successful connection also i have mapped the connection correctly.

please advise.

Best Regards

Sunil

[Former Member]

Hi Sunil,

Can you please share your data foundation's connection tab screenshot.

Regards,

Ambreen

[Former Member]

Hi Ambreen,

Thanks for you very much for your kind attention ...

  Please find the screen shots.

[Former Member]

Did you get solution to your problem Sunil?? I am facing the same issue.

Thanks

Kriti

[Former Member]

You're installing an Oracle audit database and the MSSQL errors are being flagged....