Hello,
I have a requirement to create a report in OBIEE 12c either using BI Publisher or Analytics. We need to mimic the Accounting format from Excel (currency sign is left justified and numbers are right justified). The Currency format in OBIEE will not be enough to satisfy the requirement.
Example:
Product
| Price
|
|---|
| Hard Drive | $ 350.00 |
| Keyboard | $ 25.00 |
Also, we need to be able to display the report in OBIEE first and then be able to export it to Excel and PDF (so we can't just make an BIP Excel template and upload to BI Publisher as there is no preview option within OBIEE other than XLS). I attempted to create a Word RTF template that came close to achieving the Accounting format, but if the number goes over a certain character then the text will wrap.
I'm wondering if it's possible to enter some custom .js to permanently change the Currency format in Analytics to justify the dollar sign to the left and numbers to the right? Not entirely sure if this can work.
If anyone has any thoughts or suggestions on the matter, that would be great.
Thanks!