Posts

Showing posts from April, 2009

Hyperion driver to connect to MS Sql server.

Image
Using Hyperion driver to connect to Microsoft SQL server's for BI Publisher. Database Types like Microsoft SQL Server 2000 or Microsoft SQL Server 2005 Connection String = jdbc:hyperion:sqlserver://SERVERNAME:PORT;DatabaseName=DBNAME; Driver class = hyperion.jdbc.sqlserver.SQLServerDriver Once you click test connect , there you go!... Note : Microsoft SQL Server should be set up with mixed mode authentication.

Multiple copy

Image
In Bi publisher, to get the multiple copy , we can use the @section and xdoxslt:foreach_number to get the multiple copy, which i discussed long back. we can do with other options too. here is the other one. Create sub-template and then call them with different parameter. this will call the sub template twice, so the xml will be parsed twice.

Data across in Bi publisher

Image
To get the cross tab. 1. we need to find the number of columns to be displayed. 2. what is the element to be mapped as column ? 3. then create a table. 4. the first row of the table , we need to specify the colum heading. so use the @column command 5. then in the rest of the row where you wanted to display the value , use @cell command

Apex Upgrade

You would already have a directory structure similar to Default created folder for XE installation c:\oraclexe\app (created by the Oracle XE installation) c:\oraclexe\oradata (created by the Oracle XE installation) Create a folder called apex. c:\oraclexe\apex Download and unzip the latest Apex to the folder apex under Oraclexe Step 1 Open DOS CMD window and change default to the directory of the unzipped Apex kit. e.g. CMD> cd c:\oraclexe\apex Step 2 - Upgrade to Version 3.1 CMD> sqlplus system/password as sysdba SQL> @apexins SYSAUX SYSAUX TEMP /i/ Step 3 - Set images directory CMD> sqlplus system/password as sysdba SQL> @apxldimg.sql c:\oraclexe Step 4 - Set Admin password SQL> @apxxepwd.sql password Step 5 - Enable remote http connections SQL> exec dbms_xdb.setListenerLocalAccess (l_access => FALSE); Login URL: http://127.0.0.1:8080/apex Workspace: Internal Username: Admin Password: password

Hide column from the crosstab report

In crosstab or dynamic column report , we typically do the following. <?for-each-group@column:ROW;./FISCAL_YEAR?> If i have to filter out particular value from being generated from the dynamic columns or crosstab report. <?for-each-group@column:ROW[./FISCAL_YEAR !='2000'];./FISCAL_YEAR?>