Random Thoughts

Views on life

Posts Tagged ‘Crystal Reports’

Drill down in XCelsius/Dashboard Design

Posted by Hemanta Banerjee on February 9, 2011


One of the most frequent questions I get is around configuring drill down in XCelsius (Dashboard Design). XCelsius is primarily a dashboard development tool and it is not meant for analysis. Thus the typical usage of XCelsius does not require the standard type of adhoc drill down analysis that one would normally do within say web intelligence. However there are some instances where you would want a dashboard where the user can select some high level KPI and then have the ability to look into the details of that KPI. This can done using the drill down functionality in XCelsius. Keep in mind although it is called drill down the behaviour more consistent with master-detail type of report rather than a traditional drill down. The video below shows this in more detail.

Click here to download the video

Drilldown functionality in XCelsius (a.k.a Dashboard Design)

 

So how can you build something like this. It is actually quite simple as you can see in the video below.

Click here to download the video

How to enable drill down in a pie chart

 

Combining this with the live office functionality discussed in the last post should allow you to build really powerful and interactive dashboards. You can download a more complete example from here.

Advertisements

Posted in BusinessObjects, XCelsius | Tagged: , , , , | 6 Comments »

Auditing III: How to enable auditing for Crystal Reports and WEBI viewing

Posted by Hemanta Banerjee on November 4, 2010


A couple of weeks back I had written an article on enabling auditing in BOE. The same functionality is available in Crystal Reports server as well. However I had missed out what activities can be audited. So writing this post to complete my previous posting. Below are the most of the common scenarios that the administrators want to audit.

Crystal Reports Cache Server: Viewing of Crystal reports is audited by Crystal Cache Server.

image

Crystal Reports Jobs: Can be turned on by enabling auditing for Crystal reports job server.

image

Destination Job Server: Will audit all jobs that output to emails, ftp, and file system.

image

Event Server: Audits all events that are registered on the BOE or Crystal Reports server.

image

Publication Job Server: Will audit all publication jobs.

image

WEB Intelligence: Audits access to all WEBI reports.

image

For steps on how to turn on auditing and how to look at audit data you can go to my previous posts on the same topic.

Auditing I: How to enable audits logging in BOE XI 3.1 

Auditing II: How to import the auditing reports in BOE

Posted in Administration, Audit, BusinessObjects | Tagged: , , , , , | 1 Comment »

 
%d bloggers like this: