Password Protect Excel Output in BI Publisher

  • Post category:BI Publisher
  • Post comments:3 Comments
  • Post last modified:June 12, 2020
  • Reading time:3 mins read

One of the missing piece in BI Publisher earlier was the password protection for Excel 2007 Output and it has been introduced in 18c update. Earlier password protection was possible for PDF output only and there have been a number of bugs and enhancements pending around the feasibility for password protection for Excel Output. And finally Oracle has worked on…

Continue ReadingPassword Protect Excel Output in BI Publisher

SQL Query to get Geography Information

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
  • Reading time:5 mins read

In this article we will look into getting the Country, State, County, City and Zipcode information from backend tables. These queries will be handy when there is a requirement to get the Country Name, State Names etc apart from the Country Code and State Code which are present in most of the address tables. Countries:SELECT TERRITORY_CODE ,TERRITORY_SHORT_NAME ,CURRENCY_CODE ,DESCRIPTIONFROM FND_TERRITORIES_VLWHERE…

Continue ReadingSQL Query to get Geography Information

How to default date parameters in BI Report dynamically?

  • Post category:BI Publisher
  • Post comments:5 Comments
  • Post last modified:June 9, 2023
  • Reading time:4 mins read

For most of the BI Reports, we have the input parameter as "AsOfDate" alias sysdate or current date... Sometimes we also have a date range "From Date" and "To Date" to fetch transactions between those dates. And these dates need to have a default value when we open the report/schedule the report.  If the scheduled report includes date parameters, when…

Continue ReadingHow to default date parameters in BI Report dynamically?