Maximo Open Forum

Steven Shull posted 03-15-2022 11:37

The difference between public & private QBRs is whether the EVERYONE/MAXEVERYONE (or whatever is defined in the MAXVAR in your system) is referenced in the security tab of the report.  If you add the appropriate group to the REPORTAUTH table it would make it public. You won't be able to do this from the UI as it only allows groups that have permissions to run a report in that application. You'll either need to insert this via the database or create an automation script to add the group.

Nikolaus Despain posted 03-16-2022 11:00

It looks like you want to make your Ad Hoc report a public report anyone can run, right?

Our process for report writing started with Ad Hoc Reporting. We would create an Ad Hoc report and use the Preview option and adjust until we got the report “close” (all the right fields in all the right places). Once it was close we would Save and Run the report. Once saved, we opened Report Administration, found the new report and then Exported that report. We renamed the report, opened it in BIRT and tweaked as needed (this made BIRT report writing easier because most of it is pre-built this way and you don't have to start from scratch!). We then went back to Report Administration and created a new report and imported this “QBR” renamed report. We were then able to treat it as any other report and make it as “public” as needed, like any other report.

We didn’t want to give everyone Report Administration access, so we gave them Ad Hoc report access and once their report was close, they would let us know and we would export and reload as a public report.

Aurelio Moura posted 05-07-2024 10:40

I used this "INSERT INTO" via database to make the QBR report public:

-- to find atributes, substitute report.rptdesign :
select reportnum, appname from report where reportname ='report.rptdesign';

-- to make QRB public, substitute reportnum, report.rptdesign and appname:
insert into reportauth (REPORTAUTHID,REPORTNUM,GROUPNAME,REPORTNAME,APPNAME)
values (REPORTAUTHSEQ.NEXTVAL,'reportnum','MAXEVERYONE','report.rptdesign','appname');