Configure Timeout Settings for Database Connection in Yellowfin BI

Configure Timeout Settings for Database Connection in Yellowfin BI

Usually timeout session error occurred when user session open long time & is then application close.

There are 3 timeout configuration options to consider;

1) Connection to Data source
2) Connection to the Yellowfin DB
3) Timeout setting on your Source instance (Out of scope Yellowfin).

Connection to Data Source:

Go to Administration -> Admin Console -> Data Source -> Connection (select data source)

Change Timeout Count: By default it is 180 seconds (3 min) & now changed to 480 seconds (8 min). You can change more than these seconds.

Connection to the Yellowfin DB:

Change the settings of yellowfin application file. The file is found in <Yellowfin directory>/appserver/webapps/ROOT/WEB-INF/web.xml.

Add following code:

<init-param>
<param-name>JDBCTimeout</param-name>
<param-value>1800</param-value>
</init-param>

Example:

Note: Prior to doing this activity please take backup of file.

Freehand SQL Field in Yellowfin BI Report

Freehand SQL Field in Yellowfin BI Report

Freehand SQL allows you to build a calculation/manipulation by writing the SQL.

·         In Yellowfin 7.0 version, you cannot to use a Freehand SQL field as a Filter in Report.(It may enhanced in future release)

·         If you want to use Freehand SQL field as a Filter you may need to explore ‘Custom Function’ or ‘Virtual Table’ in Yellowfin View.

·         Calculated fields are not allowed in Freehand SQL view.

·         SELECT, FROM, or WHERE clause not allowed here, directly use SELECT fragment of SQL.

·         Aggregate functions (AVG, MAX, MIN, SUM and COUNT) should not be used.

Step 1: Suppose we want to display initial letter of ‘Agency Type’ values,Online – O & Agency – A. Go to Ski Team View & Edit it.

Step 2: Drag Dimension from Calculated Fields -> Freehand SQL

Step 3: Write required logic in Formula, here “SUBSTRING(TRAVELAGENCY.AGENCYTYPE,1,1)” then Save & Activate.

You may use CASE..WHEN or any logic as per requirement.

Note: No SELECT, FROM or WHERE clause & No Aggregated Functions

Step 4: Drag the Freehand SQL field in Report & Run.

Thank You!

How to Recover Yellowfin BI 'Deleted' Reports

How to Recover Yellowfin BI 'Deleted' Reports

Sometimes reports may deletes accidentally, in general no reports physically deleted from the metadata of database.

Check the status of report from “ReportHeader” table from Yellowfin metadata database.

select ReportName, ReportStatusCode from [dbo].[ReportHeader] where ReportName =<<reportname>>

If report deleted then status would be “DELETED”.Following are the steps to recover the deleted report.

1) I have the report name “Report Dummy” & now I’m going to delete it.

Prior to Delete

After Deletion:

 

2) To recover the deleted report, update the ReportStatusCode=’OPEN’

3)  Check the report in Report Folder.

 Thank You !

Multiple tabs/browser for same user in Yellowfin BI

Multiple tabs/browser for same user in Yellowfin BI

By default Yellowfin BI able to open single browser only for same user, to open the multiple browser for same user, We need to disable the “Cookies” (Cookies=false) but this will work to open multiple browser only you can’t do multiple activities on single user login.

Go to Yellowfin Application Server: /appserver/conf/Catalina/localhost/ROOT.xml

Change cookies to false

<?xml version="1.0" encoding="UTF-8"?>

<Context docBase="D:\MBA\Yellowfin/yellowfin.war" path=""

   privileged="false" reloadable="false" swallowOutput="false" useNaming="true"

   xmlValidation="false" xmlNamespaceAware="false" xmlBlockExternal="false" cookies="false">

  <Manager className="org.apache.catalina.session.PersistentManager" distributable="false" saveOnRestart="false">

    <Store className="org.apache.catalina.session.FileStore" />

  </Manager>

</Context>

Note: Take backup prior to this activity

Stopping Auto-Refresh of Yellowfin BI Reports

Stopping Auto-Refresh of Yellowfin BI Reports

While building the report with multiple columns, arranging columns orderly or even simple change in report takes lot of time for report data preview.

So to address this, just “OFF” Report Data Preview & Chart Data Preview (If charts there in report)

After “OFF” the report setting, it asks “Refresh Option” to preview the data.

You can also minimize the Count of “Active Row Limit” & Turn-Off the “Auto Refresh”

Cheers, Enjoy!

How to change Yellowfin View for an Existing Report

How to change Yellowfin View for an Existing Report

Suppose I want to change Yellowfin View for an existing report to New Yellowfin View.

Ex: Report name is "Agency Sales by Profitability" & Yellowfin View name is "Agency_View". I have created New Yellowfin View i.e. "Agency_Sales_View" & now I would like to access this report from newly created Yellowfin View.

Step1: Go to Administration -> Admin Console

Then select Export option from Administration panel

Step 2: Select the report which you want to change the report View.                                                                               

E.g.: “Agency Sales by Profitability”

Step 3: Deselect the “Database View” (It asks while importing the report)

 

Step 4: Import the Downloaded Report

Step 5: Select New Yellowfin View & then Next ..Next

Select the required view then proceed ahead

 

Done..Thank You!

Data Source Creation in YellowfinBI Tool

Data Source Creation in YellowfinBI Tool

It demonstrate the oracle database data source connection

1) Log on to Yellowfin BI, Go to Data Source

 

2) Select the type of data source.

3) Provide Connection name & other details in New connection window & test the same.

 

4) Now you can able to create Yellowfin view