on 04-29-2015 6:45 PM
Hi,
I have downloaded the audit crystal reports and I believe I can directly use it. For some reasons the crystal reports is throwing error.
How can I view the sql for these audit reports and when I try to change the database in audit it is not working
Crystal reports-> crystal reports 2013
database for audit -> sql server 2012
Thanks
Bala
Assuming that you're on BO 4.1/CRS 2013, the audit reports that are available for download were written in Crystal for Enterprise against a .unx universe. To change the connection you have to update the universe in the Information Design Tool.
If you're trying to use the audit reports from a BO 3.1/CRS2008 system, they won't work. There were major changes to the audit database with the upgrade - ALL of the table names, etc. have changed.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dell,
The version we are using is sap bi 4.1 sp5. I could see all audit reports were created in 2011 which is 4.0 version, Hope these reports work perfectly for 4.1
Also can you let me know how to view generated SQL for these reports.
And when I tried to change the database connection. Following error is appearing in report
You have to use Crystal for Enterprise to view the SQL - and you MUST have the audit universe published from the Information Design Tool (IDT) to your BO system. Because they connect to a .UNX universe, you can't get to the SQL from Crystal 2013. Another way to see how the tables link together would be to open the audit universe in the IDT and look at the Data Foundation to see how the tables are linked together.
-Dell
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.