BOBI 4.0 AUDIT UNIVERSE ISSUE

[Former Member]

Hi,

Im using the Audit universe for BI 4 based on Oracle DB. I have downloaded this from SAP site.

With IDT, im able to open the the universe (dfx and blx). I have created a connection and published to repository.

Hence, im able to see the underlying table structure and values from .dfx.

I have linked my blx file to the dfx.

But when i tried to parse a object from the blx, it gives me "table or view cann't be found" and parsing fails.

An example object which i tried to parse.

"I830808"."ADS_EVENT"."EVENT_ID"

Even i removed the "I830808" from the above query and modified it as ""BO_DEV_AUDIT" and parsed, but still the error was there.

Our schema name is defined as "BO_DEV_AUDIT"

The user BO_DEV_AUDIT has sufficient permissions to run the query.

I think this universe is still considering the schema which the owner had defined.

Could anyone please point how this can be modified and the make the universe runnable in our environment

[Former Member · Accepted solution]

Hi Raki,

After creating connection and saving it to repository you have to change the Qualifier/Owner of the tables in Data Foundation by right clicking over the table and selecting new Owner/Qualifier for the table, do this for all the tables in the Data foundation.

then below screen will appear,

Here clickon to change the qualifier and owner,

then save the Data foundation and check integrity.

Hope above information helps you.

Regards,

Ambreen

[Former Member]

Rakesh,

Yes.  all the Audit tables still referencing the old schema names.

To change this Goto Data foundation Layer.

When you mouse over a table it shows

Details Qualifier: BOEXI40_Audit

            Owner:I830808

Right click the Table and Select Change Qualifier and Owner

Enter or select a new owner and qualifier for the table.

OR (Remove the Owner :I830808 from that field), it works.

Finally SAVE ALL and Publish to Repository.

Regards

Pardhu

[former_member182521]

Rakesh,

Seems all your Audit tables still referencing the old schema names.

You need to reference the new Schema in all your tables.(i.e.) from I830808 to  BO_DEV_AUDIT.

Try to do your modifcations at table level instead of Object level. Yoy can also do a replace all functionality by selecting all the tables. I have donre this in 3.1 and yet to check it in 4.0.

Also check the User credential which you used in data foundation layed has the necessary previleges to access tables in  BO_DEV_AUDIT schema. If you have used BO_DEV_AUDIT  there shouldn't be a problem as the user himself is the owner.

Regards,

Mani

[former_member182521]

Hi Raki,

This is the resolution for your issue.

http://bihappyblog.com/2012/08/28/businessobjects-4-0-oracle-audit-universe-woes/

Regards,

Mani

[Former Member]

Have you saved your data foundation after making the changes? Can you browse table data from your data foundation?