OC4J password

Let's say that we've installed BISE1 with different passwords for the accounts and we forgot the one for OC4J. The next step is to reset the password for OC4J and replace it with a new one.

First thing to do is to stop OC4J. For Unix users they can do it with the follozing command: ORACLE_HOME/opmn/bin/opmnctl stopproc ias-component=OC4J but for Windows is much easier:

Next thing to do is to locate and open the file "system-jazn_data.xml":

Find into this file the following tags and replace the text for with a new one (in my case I used mypassword123). Don't forget to prefix it with the symbol ! and it should conform to following:

• must contain at least five characters, but not more than 30
  
• must begin with an alphabetic character. It cannot begin with a number, the underscore (_), the dollar sign ($), or the number sign (#)
  
• at least one of the characters must be a number
  
• can contain only the following characters: numbers, letters, and the following special characters: US dollar sign ($), number sign (#), or underscore (_)
  
• cannot contain any Oracle reserved words, such as VARCHAR.

After replacing the old encrypted password with a new one (don't worry about the encryption because after restarting the OC4J it will encrypt the text you entered there all by it's self) we just have to delete cached password data from C:\oracle\bise1\bi\oc4j_bi\j2ee\home\persistence\ascontrol\ascontrol\securestore

In the end you just have to start OC4J and try logging to the OAS with the new one.

Good luck and have fun!

Navigation - Dashboard and Answers

In column properties there is a possible option to interact with data or column header and navigate to other report passing also values.

We can use this action in 3 ways:
1. we can navigate from a table through a column header
2. we can do the same thing through the value of a cell in the table
3. we can do it also from a chart.

The navigation can act also as a pop-up menu by entering multiple navigation targets with labels:


Here is is how we can do this:
into the report criteria chose a column to set up a navigation action and enter it's properties ("Column Properties"). There chose the tab named "Column Format" and you'll find out 2 labels called "Column Heading Interaction" and "Value Interaction". In this case we'll chose the value interaction and select from the drop-down menu "Navigate". Hit "Add navigation target" and chose the report to navigate and fill in a Caption for it. Do this multiple times and as a result you'll get a pop-up menu:



For the interaction to work properly, and pass also the values, we should use the same column as a filter and set it up as "is prompted".

To do the same thing with the "Navigate" interaction in a chart, after choosing the same options into the report criteria and filling in the targets in the column properties, we should do it also into the chart properties. To use multiple columns with their values into the target reports, each of the column should have the same targets and caption.