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!