Posts

Showing posts with the label BI Publisher Version

How can I find the BIP version from output ?

In order to identify the version from the generated PDF output. In the generated PDF output from Publisher and go File->Document Property menu. PDF producer tells the XML Publisher version used to generate the report.

Cross Tabs problem with grouping and extra columns; possible bug?

Image
There was a question in BIP forum to get the dynamic column,.. User was Brian, he required , the number of column based on the data in the xml... This was the XML , he gave. He required this kind of output, which is obvious, but , by using the Cross-tab from the menu, and formatting , you cannot expect this output.. That is going to screw up the output. He was thinking, it is some kind of bug, its not a bug, the way he want can be done easily :). Little understanding of how report should work is required :) here is the solution :) Please click on the image to see :)

Wanna know BIP Version installed

Bang on to the sql*plus and try hitting this query You will come to know SELECT DECODE (bug_number , '3554613', '4.5.0' , '3263588', 'XDO.H' , '3822219', '5.0.0' , '4236958', '5.0.1' , '4206181', '5.5.0' , '4561451', '5.6.0' , '4905678', '5.6.1' , '5097966', '5.6.2' , '5472959', '5.6.3') PATCH, bug_number FROM ad_bugs WHERE bug_number IN ('3554613' , '3263588' , '3822219' , '4236958' , '4206181' , '4561451' , '4905678' , '5097966' , '5472959');