Posts

  • 1-2 of 2
  • Barry Stamp
    BI Publisher Permissions5.0
    Topic posted November 16, 2018 by Barry StampBronze Medal: 1,250+ Points, tagged BI Publisher, Reports in General OBIEE public
    Title:
    BI Publisher Permissions
    Summary:
    BIP Security Permissions
    Content:

    Hi,

    I have to setup permissions on a folder which holds several reports but as I add a Full access permission a folder icon appears with a padlock states 'No access to the root - click to add Traverse permission upstream'. If I click on the padlock the folder icon has a green tick and states. 'Will set Traverse permissions up to root - click to retain parent's Traverse permission for this account'. 

    I have also given the BI Consumer role - No access to stop others from accessing the folder but I have in the past lock my team out of a folder by not picking the correct option.

    Can anyone suggest the best approach?

    Thanks.

    Barry

    Image:
  • Barry Stamp
    Oracle BI Publisher - Report on Report Job History1
    Topic posted January 16, 2018 by Barry StampBronze Medal: 1,250+ Points, tagged BI Publisher, Fusion, Report Delivery, Report Output, Reports, Scheduling or Agents, SQL in General OBIEE public
    Title:
    Oracle BI Publisher - Report on Report Job History
    Summary:
    Find a way to acquire all Report Job History listed and extract all data to Excel
    Content:

    Hi,

    I used to be an Apps DBA\Technical application Support on R12 EBS back in the day and I wanted to know if we can extract all jobs running within Report Job History within BI Publisher?

    If there is no obvious download 'all jobs and extract all'  button or does anyone know the SQL system tables which can help to retrieve all jobs history and their information such as when they were started, when they were run last, who owns the report.

    This would be similar to acquiring jobs within concurrent manager.

    Thank you all.

    Barry