We had a requirement in which the a column had either pure numbers such as 123 or pure alphabets such as QWED. The requirement was to display 'Y' in a column if the value was a number and display 'N' if it was a character string.
While we can anyways have a case statement for each of the numbers i.e. 1,2,3,4,5,6,7,8,9,0, I found an easy way out by using the ASCII function.
ASCII function (more...)
This is a simple trick that presents the process to have a parametrized BIP report in OBIEE without the need to create new prompts in OBIEE.
1. Edit the dashboard and drag Embedded Content
in an OBIEE dashboard section.
2. Put the following URL in the Embedded Content Properties
http://<OBIEE presentration server>:<OBIEE presentation server port>/xmlpserver/<BIP report xdo file path starting from shared folders>?&_xmode=2
http://<OBIEE presentration server>:<OBIEE presentation server port>/xmlpserver/Supply+