Nilesh Patil's blog

    Click here

Download word file contains guide to deployement of BI server with MSSQL server database http://www.4shared.com/file/rfjMxWnU/A_guide_to_getting_started_wit.html

Eclipse :- For windows :- 1. Open Run Dialog > "your application" > Common Tab > Console Encoding > Other "set it to UTF-8" 2. Open Run Dialog > "your application" > Arguments Tab > VM Arguments > Add "-Dfile.encoding=UTF-8" and of course Window Menu > General > Workspace > Text file encoding should be set to "UTF-8" then you can run your application ( doesn't matter Standalone or inside Tomcat) Mac Os :- added -Dfile.encoding=UTF-8 to /Applications/eclipse/Eclipse.app/Contents/MacOS/eclipse.ini Eclipse Indigo :- simply by going to Edit > Set Encoding, then choosing UTF-8. e.g. this code will work: public class Hello { public static void main(String [] args) { System.out.println("english letters. русские буквы"); System.out.println("new Date()= " + new Date()); }

In MySQL, all the image types (jpeg, gif, png, bmp) can be fetched easily by drag-drop of the BLOB field. In Oracle though, none of the images can be fetched like this. As a workaround, the image types other than bmp, can be fetched following the steps below: 1. Connect to the database and write a query that fetches the BLOB field. Preview it to check if the query fetches any data. 2. Right click on the "functions" header and add a new function. 3. In the dialog box for the New Function, double click on the "Scripts" and select the BHSExpression. Click "OK". 4. In the "Expression" field for the "BHSExpression", copy the following code: Object getValue() { var blobObject = dataRow.get("BLOB_COL"); long blobLength = blobObject.length(); byte[] blobContent = blobObject.getBytes((long)1, (int)blobLength); return Toolkit.getDefaultToolkit().createImage(blobContent); } This Javascript code will convert the BLOB field to an image f

If you want to hide Buttons for New Report analysis view , Manage Content then make changes as below. Before changes :- Step -1 ) go to biserver-ce\tomcat\webapps\pentaho\mantle\launch\launch.jsp Step -2 ) commented following code in launch.jsp (from line number 397 to 418 ) List buttonIds = new ArrayList(); buttonIds.add("launch_new_report"); //$NON-NLS-1$ buttonIds.add("launch_new_analysis"); //$NON-NLS-1$ buttonIds.add("manage_content"); //$NON-NLS-1$ ButtonInfo newReportButton = new ButtonInfo(); newReportButton.buttonCommand = "openWAQR()"; //$NON-NLS-1$ newReportButton.buttonLabel = Messages.getString( "UI.PUC.LAUNCH.NEW_REPORT" ); //$NON-NLS-1$ newReportButton.buttonImage = "images/btn_ql_newreport.png"; //$NON-NLS-1$ buttonOverlays.put(buttonIds.get(0), newReportButton); ButtonInfo newAnalysisButton = new ButtonInfo(); newAnalysisButton.buttonCommand = "openAnalysis()"; //$NON-NLS-1$ newAnalysisButton.bu