Steps to install 'R' Programming Language Software on Windows

Steps to install 'R' Programming Language Software on Windows

Following are the steps to install R Programming language software on windows system.

Step 0: Download R installable software from this link https://cran.r-project.org/bin/windows/

Step 1: Select installer & right click then run as Administrator. Select the preferred language (English)

Step 2: Opens the Windows R installation wizard.

Step 3: Select the destination location. The default location is C:\Program Files.

Step 4: This is main components of R installation. By default R installs both the 32 and 64 bit versions on your system. Select the appropriate installation type based on your windows machine 32 or 64 bit version.

Core Files: It is R main components files. It’s must for R installation.

Step 5: Customization options, proceed with default.

If you choose 'Yes', gives options as 
a) MDI - Single large window for R Console & Editor
b) SDI - Separate window for R Console & Editor

Step 6: This step will create the program shortcut & create folder in start menu. This

Step 7: Create desktop icon & Quick launch icon option.

Step 8: Installation is in progress.

Step 9: Click Finish to complete the installation process.

Now installation of R successfully done, Happy learning & Enjoy!

Multi Conditioned (AND and OR Conjunctive Operators) Filters

Multi Conditioned (AND and OR Conjunctive Operators) Filters.

In Advanced Setting, You can change the condition based on requirement using Arrows & Logical operators.

Example 1: Combination of AND & OR logical condition at inner level.

Example 2:  Combination of AND & OR logical condition at inner level.

This way using arrows we can handle the multi filters.

Thanks ! 

Yellowfin BI Not Allowed to Edit Report (i.e. Access Level Restricted)

Yellowfin BI Not Allowed to Edit Report

There are some scenarios where accidently changed the report access level so that affects the report access, If any column restricted in Yellowfin view then underlying column used in report couldn’t able to Edit. This is because of access level restricted for one of report column.

If column is restricted you can’t see that column in Yellowfin Report creation Panel. Here Camp Demographic column can’t see.

Report is not able to edit because of "Camp Demographic" column Restricted.

Change Access Level to “Global”.

After providing Access Level to “Global”, Edit option can see

Now you can edit the report, Cheers!

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 !

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 !

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!