BI Data Analytics

Problem: Setup HTML link on email Solution: Create Email ID data item in report query [Report Query].[Email ID]  Drag singleton with Email ID field and set property visible to NO. In Singleton, drag Hyperlink object and change properties Text Source:  Source Type = Report expression  Report Expression: Email ID field URL Source Source Type = Report expression Report Expression: 'mailto:'+[Report Query].[Email ID] 

This Post contains quick tips for various tools used in Project work. Database:  DB: Oracle 11g How to Extract Year from Time Stamp: Select   extract(YEAR FROM A.DW_CRTE_TS) from  table  A How to Extract year of previous day from Time Stamp: Select   EXTRACT( YEAR FROM A.DW_CRTE_TS -1) from  Table A Note: The page will be updated for more tips based to help in BI implementation and Data Analysis

Steps: 1. On report page create Prompt Button with Type as "Back". 2. Add HTML item with below script before button --< script type="text/javascript"> function  ReturnLink() {     y=getFormWarpRequest().elements["cv.id"];     // if the report is running from reportStudio or the Portal objects are different     if(y.value == "RS")         oCVRS.rvMainWnd.executePreviousReport(-2);     else         oCV_NS_.rvMainWnd.executePreviousReport(-1); } --< /script> --< A HREF="#" onClick="ReturnLink()"> 3. Add HTML item with --< /a> after Back Button. Result: Now using Button, you can go back to previous page in all cases.