Monday, December 26, 2016

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 !





Thursday, December 22, 2016

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

Wednesday, December 21, 2016

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!


Wednesday, December 7, 2016

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!

Monday, November 21, 2016

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

Thursday, September 8, 2016

About Yellowfin BI Tool

About Yellowfin BI Tool
Yellowfin – BI Tool:
Yellowfin is a business intelligence tool with high data visualization and analytical capability so users can solve problems with data and increase the performance of their business.

Yellowfin is designed & built by BI industry professionals. Yellowfin positioned in Gartner magic quadrant for third consecutive year.
Yellowfin rises in Gartner's Magic Quadrant - February 2016.
Yellowfin rises in Gartner's Magic Quadrant - February 2015.
Yellowfin debuted in Gartner's Magic Quadrant - February 2014.

Features:
·         Awesome Dashboard & Data Visualization
·         Collaboration BI (Annotation, comment, Storyboard, Time Line & Discussion)
·         Mobile BI
·         Location Intelligence
·         Cloud BI (Azure & AWS)
·         Data Discovery
·         IT Administration (web-based, integrated platform, Data Governance, Security, Easy to manage)
·         Simplified pricing
·         Embedded BI

Advantages:
·         Track business operations effortlessly from the dashboard.
·         Discover data from multiple sources and analyze them in more ways than before. Create more intelligent business plans from multiple actionable insights.
·         Visualize and explore data to spot trends and outliers.
·         Collaborate and access data with Yellowfin’s mobile app.
·         Share insights and communicate with other members effectively with compelling data presentations, interactive reports, and descriptive texts.
·         Collaborate and turn business intelligence into effective business strategies.

Yellowfin offers an innovative and flexible 100% Web-based reporting and analytics solution that is cost effective, easy to use and deploy. Yellowfin can reach any platform or device and is a leader in data visualization, location intelligence, mobile and collaborative BI.