Archive for the ‘web intelligence’ category

Webi Extension Points

May 12th, 2011

Our team recently had the opportunity to start building with Webi Extension Points and I was impressed.  The ability to manage the Web Intelligence Interface has improved greatly since the initial release.

The requirements were to create a report specific user interface that allowed the following in both the Webi Rich Client and the Webi Viewer:

1) Only rollout extension to users that need it

2) Export Panel only show if the report name matches the set of reports specified by the business

3) Actions limited if other criteria of report does not match (i.e. Record Count = 0)

If Prerequisite are met

Create an Export panel in Webi

– Populate with combo box of export formats

– Create Save Button

Gather File Name  from a variable Object value in the report

If user has selected XLS or PDF and clicked on save

– Stream IReport to XLS, PDF with file name defined in Name Object

– Provide User confirmation on download.

If user has selected ZIP

– Show password text field on panel

– Capture user password

– Stream IReport to XLS, PDF with file name defined in Name Object

– Create Zip file with password

Provide User confirmation on download.

In the initial execution we created the base functionality in Java and deployed a JAR along with the properties file.  In a production environment this is how it would be rolled out.  For moving quickly on the Prototype we shifted to Javascript which made previews a bit faster and made implementing swing almost fun.

I was amazed at how quickly that we could get the interface pulled together and working.    This opens up all types of possibilities for our Launch tools and client’s needs.  I am hoping that the Extension Points are brought back in the 4.X platform.

OpenDoc vs. CallReport

May 5th, 2010

We get a lot of question on how Open Document compares to Report Launch. In a conversation with our sales team I tried to summarize the vast differences. Opendoc is a single URL that can only call a single report at a time ….and for Webi can only return to the viewer or PDF

Report Launch’s “call report” is an application that will provide a consistent ways of calling both Crystal and Web Intelligence reports using single sign on.

  • On- demand refresh
  • On demand scheduling
  • Report List
  • Last Scheduled Instance
  • Last Bursted Instance
  • List of Historical Scheduled Instances
  • List of Historical Bursted Instances
  • It can also support the following formats

  • PDF
  • XLS
  • PPT
  • CSV
  • TXT
  • HTML
  • XML
  • These are the basics. There are also more complex features for complex solutions.

  • Cached Results
  • Report Parts by Name
  • On the fly Dimensional Slicing
  • – Challenge us with something you need and I can tell you if CallReport already handles that.

    Kevin McManus

    Java or .NET

    January 1st, 2010

    Recent Question: Do you have any recommendations on installing the .NET (IIS) vs Java (Tomcat) versions? I liked the ease with which we implemented the SSO hack in IIS on our XI R2 server but I’m not if we can do the same on the 3.1 version. Also I remember that on sometime the .Net versions sometimes did not have all the functionality as the Java version is that still true?

    Answer:I usually lean towards whatever web platform that IT has optimization expertise in. If they don’t have optimization expertise in either then for several reasons, I usually do the Java.

    However for SSO the IIS setup is less steps than the Java version. The IIS pass through can still be done but is not a great solution if you are doing things like scheduling out reports with email links back to the system and still wanting SSO.

    If you do go with Java,Normally I work with people to setup the Vintella Kerberos SSO so that there is only one web platform running on the server rather than the pass through.

    GBN/BOUG Conference 2009 Dallas

    October 20th, 2009

    Best Business Objects conference I have been to. What as missing in free entertainment was replaced with better content. More in depth training on Xcelsius, Universe Design , web intelligence and Crystal Reports.