Wednesday, April 9, 2014

Scatter chart with lines between the points

In one of our Deski reports, we have a "funnel" chart.  This is essentially achieved with a scatter plot graph with lines drawn between the scatter points to resemble a line chart.  This allows us to draw odd lines, such as a funnels that don't really look like funnels.  :)  (Picture drawing a concentric circle for another visualization of what we are trying to accomplish).  So our problem is that we need to convert this Deski Report to Webi in order to move to BusinessObjects 4.1.  But we cannot seem to achieve this in Webi because the scatter plot in Webi does not draw lines between the points.  Any ideas out there?

Auditing Bug - high cpu, slow login, slow performance

So after months of working with SAP, we've finally identified a major problem that was affecting login performance and probably performance in general.  The culprit was Auditing!  The auditing folder was not being cleared out as it should be.  To be more precise, the files in the Auditing subfolder are supposed to be continually roll over and get reduced to 0 KB.  In my case, the files are stacking up and never getting removed.  If I stop the SIA, and rename the auditing folder and create a new auditing folder that is empty, then start the SIA again, the performance problems go away.  SAP has recommended a permanent fix to run a database script which will remove unique key constraints in the repo.