_||_BI_PASSWORD_||_
You have two ways to supply the password for the Oracle BI user:
Use a placeholder parameter (masked parameter) in the softcoding value and assign the value to the parameter in the grid. The above example used a placeholder parameter called BI_PASSWORD and defined the BI_PASSWORD variable in the grid. The _ | | _ prefix and postfix are markers for placeholder variables.
When used this way, the value is encrypted before it is saved into the database and is masked for future display.
Use plain text directly in the softcoding value.