Jump to content

BIRT Developer Center Download


Photo
- - - - -

Problem with drillthrough hyperlinks using crosstabs in Maximo 7.5


  • Please log in to reply
3 replies to this topic

#1 Kyuuri

Kyuuri

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 09 May 2016 - 11:57 PM

I'm using Birt 3.7.1. against Maximo 7.5 and has run into an issue concerning adding drillthrough hyperlinks on data elements in crosstabs.

 

The hyperlinks work fine in the Eclipse html viewer but after importing the report to maximo klicking a hyperlink generates the following error:

 

"Error 500: Error occured in server, check serverlog for detail"

 

After some digging I managed to find the server log and it hints that the issue is caused by a null pointer exception in ReportRequestProcessServlet (see attached serverlog.txt).

 

By method of comparisson of hyperlinks between regular working drillthroughs and ones generated by a cross-tab element (I tried this on 2 different crosstab reports). It looks to me like the report request token is not included in the generated hyperlink causing an invalid report request. Which pretty much has me stuck.

 

Has anyone else encountered this issue? Is there a known workaround or ideas for a workaround?

I'm thinking of manually generating the drillthrough hyperlink by using a dynamic text hyperlink. I've done some light test by copy pasting working hyperlinks into browser and the approach seems to work (as long as the attached request token is till active/valid). The problem is, I don't know how to fetch or generate a valid report token for the current session...

Attached Files



#2 fdezgretel

fdezgretel

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 28 June 2017 - 09:51 AM

I have exactly the same problem as you. Did you find any solution???



#3 wwilliams

wwilliams

    Junior Member

  • Members
  • 331 posts

Posted 29 June 2017 - 07:25 AM

http://www-01.ibm.co...uid=swg21700360

"Drilling down in cross-tab reports with data cubes is not available with the Open Source Eclipse/BIRT version embedded within Maximo. The commercial version of BIRT has this feature available with its BIRT data analyzer."

 

I had to re-write my sql using pivot to get the output in a crosstab format for the hyperlinks to work.



#4 fdezgretel

fdezgretel

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 03 July 2017 - 06:33 AM

Thank you very much for your answer! I'll do the same