Thursday, March 30, 2017

Steps for Yellowfin BI Uninstallation (Developer Version)

Steps for Yellowin BI (Windows Service)

When we installed Yellowfin in windows platform & windows as a service, Following steps are for uninstall Yellowfin BI software.

1) Stop the Yellowfin service from services.msc


2) Go to Yellowfin installation folder (D:\Yellowfin 7.3\appserver\bin) then type the command as “service uninstall yellowfin” in cmd to uninstall the yellowfin service.

Here yellowfin is the the service name.


3) Shift delete the Yellowfin installed folder ( i.e. D:\Yellowfin 7.3)

Now your Yellowfin successfully uninstalled.Enjoy !

Thursday, March 23, 2017

Steps for Yellowfin BI Installation (Developer Version)

Steps for Yellowfin BI Installation (Developer Version)

Following are the steps to install Yellowfin BI tool on Windows platform.

Prerequisites:
1) JRE version 1.6 or higher to install Yellowfin 7.3
2) Database (HSQL for testing/learning purpose only)
3) Yellowfin License ( https://www.yellowfinbi.com/ -- click on Try it Free & provide details to get license copy in your inbox )

Step 1: Select Language



Step 2: Installer home page


Click on Next button & accept the terms of license agreement to proceed.


Step 3: Select the packs to install.
a) Tutorial Content: Ski Team sample data, views, reports and dashboards.
b) Audit content: This pack contains views, dashboards and reports to explore various aspects of your Yellowfin instance, including administration items, content usage and user metrics.
c) World Countries Pack: This GeoPack provides geometry for every country on Earth.
d) US Zip Code Pack: This GeoPack provides geometry for states, counties and zip codes in the United States.





Step 4: Provide the license file.
If you don’t have download it from yellowfin official site. https://www.yellowfinbi.com/ -- click on ‘Try it Free’ & provide details to get license copy in your inbox



Step 5: Web Service Port & Web services
Provide the web service port (Let it be default) & Click on “Install Window service”.



Step 6: Select the Database type
Here it’s selected HSQLDB – it’s embedded with Yellowfin software. This type of installation for learning purpose only not for production.



Step 7: Installation is in progress.



Step 8: Installation Done, Yellowfin installed now.


 Installation successfully completed. Thank You !

Thursday, March 9, 2017

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.