Administration
- How do I modify the Yellowfin startup settings?
- How do I manage and setup LDAP groups in Yellowfin?
- How do I filter the list of groups returned from LDAP groups within Yellowfin?
- Changing the default scheduled task to synchronize LDAP groups & users in Yellowfin?
- How do I enable the Tomcat Management Console?
- With Multicast licensing, is it possible to restrict the users to Broadcast reports to non YF users (unlicensed users)?
- What is a JSON Data Type and Does Yellowfin Support it?
- Our broadcasts are still running even though we've deleted the Client Org that they were created within?
- Stacktrace error is missing from Yellowfin log file?
- Connection Error occurred selecting data: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000
- ORA-01017 error when connecting to Oracle database!
- "Failed to load values error - too many prompt values" displayed when running report
- What are all the Yellowfin log files and how is logging handled within the system?
- How to add a new JDBC driver for use in Yellowfin
- How to reset ANY Yellowfin user password by accessing ResetAdmin.jsp
- How do I change my user session timeout setting within Yellowfin?
- Is there a way to configure a Google BigQuery to only retrieve data from a specified Namespace?
- How do I backup and recover my Yellowfin database or export specific items from my database?
- How can I delete a tag in the database?
- How can I use the SQL Server Reporting Services (SSRS) functionality?
- How do I connect Yellowfin to a Hive Server 2 configuration?
- How do I provision the default user roles in Yellowfin?
- Is it possible for Yellowfin to interface with Active Directory for authentication?
- Is it possible to change the currency format to European standards?
- How do I turn on debug logging within Yellowfin?
- How can I turn on or off 'Ask' when multiple sessions are detected so we stop receiving 'Cannot log in from multiple hosts' errors message?
- How can I reduce or shrink the size of our Yellowfin log file?
- Can reports created in JasperSoft iReports or BIRT be uploaded to Yellowfin?
- How do multiple clients run the same report with different data sources?
- How can I access my report created in Yellowfin from the web?
- What is the difference between Same and Default row shading?
- Is there a way to limit the file size of the std.out or the catalin.out files?
- What are the ways I integrating or emdedding Yellowfin into a custom application or webpage?
- How to change Yellowfin's Java Path - WINDOWS
- What is the Yellowfin repository DB used for?
- Moving the JDBC ODBC bridge from Java 7 to Java 8
- Struts Related Startup Error in Yellowfin July 2016 Builds
- Connecting to the Yellowfin Repository DB (web.xml settings)
- how to turn on DEBUG logging for individual classes
- How to add new JDBC Drivers?
- How to disable the scroll bar on dashboard portlets
- How to add/remove/configure the Yellowfin Windows Service
- How to Upgrade Tomcat
- deploying YF 7.2 + into Weblogic - Failed to compile JSP
- Can Yellowfin scale?
- Can we rebrand Yellowfin to look like our product? How far can we really take this?
- Our database is huge, will Yellowfin be able to handle it?
- How do I integrate Yellowfin with my application?
- Why is my Yellowfin Database so large, and what can I do about it?
- How to export/import reports based off of CSVs
- How to take a clients Yellowfin folder, and have it start on your machine
- What is Yellowfin's 'info.jsp' Page?
- How to configure the Background Task Runner queue sizes
- Cannot find Views in Admin console in 7.35?
- Active Directory Federation Services (ADFS) and the Yellowfin SAML bridge
- How to Change Yellowfin's Default Listening Port
- LDAP Groups and Client Orgs
- How to limit the size of the Event tables
- How do I manage the health and adoption of my Yellowfin system?
- Setting Default Dashboard Tabs
- Queries to help reduce a huge Yellowfin DB by only keeping most recent 5 versions of reports
- Supported Languages
- Connecting to a database on Microsoft Azure via JDBC
- Minimum Database permissions required for Yellowfin Repository Database
- Bulk User Export Query
- How Access Filters work from a SQL perspective
- How to Reset Password in Amazon EC2 Yellowfin Instance
- Enabling nested LDAP group functionality in Yellowfin
- Yellowfin University - Access/Account Troubleshooting
Broadcast & Report Exports
- Broadcasting using CC recipients
- Broadcast reports individually instead of bulk sending
- How Broadcasts work
- Export to Excel (XLSX) using the Low Memory Option
- How to get Assign Filters option when configuring Advanced Broadcasts
- What happens when I import and replace a Report/View/Datasource
- I'm having problems exporting to PDF in 9.3 or above
Collaboration
- Does Yellowfin handle session replication for clustering?
- What if Yellowfin fails to start?
- How do I specify a Tomcat address for Yellowfin to use?
- What is a named user mean in Yellowfin?
- How do I change the default ROOT URL path for Yellowfin?
- Is broadcasting available with freehand SQL reports?
- What is the Yellowfin application server?
- How can I setup a report broadcast schedule that will send out bi-weekly on Tuesday and Thursday?
- What are the definition of Run Count, Average Run Time, Last Run mean?
- Timeline
- Discussion Streams
- Activity Stream
- Task Management
- Time Series Charts
- Creating tasks
- Adding a comment
- Timeline comments
- Creating discussions
- Collaboration comments
Data Sources
- How do I apply a timezone offset to a report?
- How does the In-Memory DB work, and will it make my reports run faster
- Data Source Connection Details : Amazon Arora
- What is a Yellowfin Connector, and How do I Use One?
- Create Your Own Connector
- How to select a new Driver while adding a Datasource?
- How to connect Generic database type jdbc driver?
- New view builder workflow offered in v7.3 release
- What's the new toggle feature do within the view builder interface?
- How does the new data profiling and automatic binning work to help with data setup and analyses?
- What are some metadata modeling best practices found in v7.3?
- Can I load a CSV or spreadsheet into Yellowfin?
- What database systems does Yellowfin support? Does it support 'big data'?
- How do I combine data sources in Yellowfin?
- How to use UCanAccess to connect to Microsoft Access Databases using JDBC only
- JSON Connector
- Connecting to Google BigQuery
- Grouped Data
- Top n Rank and Bottom N Rank
- Formatting tabular data
- Suppress duplicates
- Sorting data
- How to increase the connection timeout to the Yellowfin database
- Year over Year Comparison
- Does Yellowfin have a AWS Connector?
- Does Yellowfin have a Google Sheets Connector?
- Does Yellowfin have a DocuSign Connector?
- Does Yellowfin have a Facebook Ads Connector?
- Does Yellowfin have a Facebook Connector?
- Does Yellowfin have a Expensify Connector?
- How do I consume JSON data over a REST service?
- Does the JSON connector support Schema data sets?
- How do I consume JSON files via FTP?
- How do you convert separate Latitude & Longitude values into a POINT value for mapping?
- How can I analyze large JSON files in Yellowfin?
- Does Yellowfin support LineString in REST mode?
- Does Yellowfin have any JSON test files we can use?
- Troubleshooting Database Connections
- How to connect to MongoDB from Yellowfin
- How to Fix Fields Missing from Step 2 of View Builder and Reports
- Yellowfin 8.0.2 will be bundled with selected JDBC drivers
- Best practice and key considerations for CSV Data Sources
- How JDBCTimeout works
- How to use different schemas from a single database when using Client Source Substitution
Installation & Upgrades
- Yellowfin is unable to start after upgrade to latest java version?
- How to roll back Yellowfin to a previous version
- What is JVM Max Memory, and Why Should I Care?
- I receive error code 1 when trying to start a Windows service of Yellowfin
- Why does case sensitivity matter when installing Yellowfin with a PostgreSQL Database?
- I upgraded my Yellowfin from 6.3 to the newest build (7.1 20141223 ) and now I receive the error message "Error: org.apache.jasper.JasperException: Unable to compile class for JSP: "
- How to upgrade Yellowfin
- How to remove an index from the installer
- Replicating your Yellowfin environment
- Best practice for performing a Yellowfin upgrade
- Thinking of Upgrading to 7.2? Read These Documents First!
- Does Yellowfin offer help with upgrading to the latest release?
- Windows service not starting with 7.3 (Windows 8.1 and Windows Server 2012)
- Yellowfin 7.3 Server Specifications
- Installing Yellowfin on WebLogic 12c
- Can Yellowfin run in the Cloud?
- Upgrade a Yellowfin WAR Deployment
- Properly Installing Yellowfin on Linux With Systemd
- Installing Yellowfin for the First Time
- What happened to 7.3+ (aka 7.3 Plus) ?
- Where can I find the 7.4 installer?
- Restricting the amount of cores that YF runs on
- Configuring Yellowfin for Containerization
- Unable to install on SQL server with Windows Authentication
- SQL Anywhere DB required driver for installation
- Installing Yellowfin using a Microsoft SQL Server Named Instance on a specific TCP Port
- How to Install Yellowfin into AWS RDS MySQL
- Your browser is out of date and unsupported by Yellowfin - IE 11 and Yellowfin 9.2.2
- Encryption changes in 9.5/8.0.9 and issues with passwords
- What purpose does DATABASECHANGELOCK serve?
- How to make License files and JDBC drivers appear in the file explorer on Mac OS
- Upgrading Java
Integration
- Data visualization Best Practice Guide
- How to Replace the Yellowfin Loading Spinner
- Is there a list of web service error codes? Yes there Is.
- Google Chrome 84 could impact Embedded Yellowfin below 9.3
- Additional troubleshooting possibilities for REST API error codes
- Redirecting non-logged-in users to another URL for SSO entry into Yellowfin
- Invalid regular expression SyntaxError in Browser Console trying to load Embedded Content
- How Do I Enable Third Party Cookies?
Performance
- How do I get the info_threads page and what does this do?
- What is InfoThreadRunner and why do I care?
- What is Event Caching and how do I adjust the default settings?
- Yellowfin Internal Cache Options
- Volatile Data Sources - What is it and when do I need it?
- Where can I find how much memory is allocated?
- How to Learn Report Runtime Via The Yellowfin Configuration Database
- Yellowfin Performance Tuning or Monitoring
- Yellowfin Performance Analysis Snap Shot Tool
- How to Save a HAR file
- My Dashboard/Report is slow
Product Change Logs
- 7.1 Change logs: Patch and Release notes for 7.1
- 7.2 Change logs: Patch and Release notes for 7.2
- 7.3 Change logs: Patch and Release notes for 7.3
- Product Release Notes - Where the heck are they?
- Product Launch Webinar: v7.3+
- 7.4 Change logs: Patch and Release notes for 7.4
- Yellowfin release management
- 8.0 Change logs: Patch and Release notes for 8.0
- v9 Change logs: Patch and Release notes for Yellowfin Version 9
Report Builder
- How do I create Sub Tabs on a dashboard?
- My charts have suddenly disappeared or are not displaying at all?
- Can YF reports display Row Numbers like in MS Excel?
- How do I secure or hide a YF Report?
- Where does the report description date and time come from within Yellowfin?
- Why is the time series not showing gaps in data on reports?
- Dashboard displayed wrong result when using the browser back button?
- Can you assign multiple values to an access filter?
- Can I create a report that queries data from multiple data sources?
- How does the new v7.1 drill through functionality work?
- What is the criteria around how often and when a report on a dashboard tab is refreshed?
- Is there a way to set the Auto Refresh functionality for views and reports to OFF by default?
- Why can't I see the Drill Down option in my report builder?
- Is there a way to assume NULL = 0?
- How do I create a report and utilize the Ring charts as seen below in the Monitor dashboard?
- Our dashboards and reports do not seem to load well in IE8, does Yellowfin work with Internet Explorer? (IE8 IE9)
- Can I create a two field drill downs from the same hierarchy within the same report?
- How do I change the width of my dashboards?
- What is the best way to connect two databases, that have different data, but I need to join the data into a report?
- Can annotations be applied to any other data type than dates?
- What is the data type Integer and how does it connect to the Field Type options?
- How do you create a time based distribution using time dimensions?
- How do I sum a quantity relating to a specific end date within a range of dates?
- Where can I find Geo Polygon data or other Geo Pack details that I can use within Yellowfin?
- Does Yellowfin plan to support non-additive measures in the future?
- How do I format negative numbers in Yellowfin?
- GIS Resources
- How To: Create a KPI Scorecard
- turn off validation of calculated fields when saving
- How to perform comparative analysis within chart builder using set analysis.
- How to create calculated fields using the variance function.
- How can I setup customer colors for my metrics?
- How to use chart-level aggregation to change things like Sum, Average, Min, Max, Count, and Count Distinct.
- What has changed in the content creation canvas?
- Header & Column Lock not working? Check whether CUSTOMDASHBOARDSCROLLBARS is ON or OFF in Configuration
- Cached Values On Demand / Custom Query Cached On Demand
- 7.3 Set Analysis Feature
- Aggregate vs Group By in Custom Functions
- How to Add a Font to Yellowfin
- Tips to code and debug a JavaScript Chart in Yellowfin
- JavaScript Charting Libraries - Ski Team Examples
- What is a .YFX file?
- Calculated Field showing wrong value, incorrect result
- Multichart Canvas
- Big Number Charts
- Dashboard Filters
- Dashboard Sub Tabs
- Saving Dashboards
- Saving dashboards
- Dashboard Series Selection
- Dashboard Series Selection
- Dashboard help
- Calculated fields
- Advanced Functions
- Filters
- Use Prompt Filters
- Bookmarks and Snapshots
- Summaries and Sub totals
- Googlemaps
- Toggling map types
- Loading CSV
- Report Editing
- Report Editing
- Basic cross tab report
- How to create Co-Display Reports
- Section Reports
- How do I use a logo as a Axis tick label on a Bar Chart?
- Where can I find some D3 visualization examples?
- How to get barcode fonts working in your report tables.
- How to hide a Column Heading (i.e. how to have a blank column heading)
- Getting started with Yellowfin
- Creating your own Conditional Formatting customised icons (for developers)
- Creating your own Conditional Formatting customised icons (for non-developers)
- The 101 guide to designing beautiful analytics
- "invalid field name" or "multipart identifier <xxx> could not be bound" on calculated field insert
- How to Toggle SELECT and SELECT DISTINCT in Report Builders' SQL
- Differences Between Simple and Freehand SQL Calculated Fields
- How Report Sections work
- How Drill Down and Drill Anywhere work at the SQL level
- How arithmetic and aggregations interact in Calculated Fields
- How do the new Cached Filter options work in 9.5
Security
- How to remove access to information pages. List of Yellowfin information pages.
- Encrypting Yellowfin Traffic via HTTPS
- Apache Struts Vulnerabilities
- Concern Over Equifax Breach
- Apache Struts CVE List
- Apache Tomcat Vulnerabilities
- Security Best Practices For A Yellowfin Instance
- Tomcat Vulnerability - Ghostcat
- Tips for Troubleshooting SSL Issues
- Yellowfin and the SpringShell Vulnerability
System Configuration
- How does LDAP Single-Sign-On (SSO) work in Yellowfin?
- How do LDAP users work within Yellowfin?
- Installing Yellowfin Into an Existing Application Server
- new web services that are not documented as of yet
- LDAP Authentication Configuration in Yellowfin
- Converting Existing Yellowfin Users to LDAP Users
- How to configure the EventArchive time
- AD FS - Yellowfin SAML Bridge
- How to access Yellowfin via 'localhost' on a remote machine by using SSH Port Forwarding
- How to avoid having to restart Yellowfin after backend modifications to the Yellowfin database.
- Google Maps API Switched to Pay-As-You-Go Model
- OpenJDK with Yellowfin
- Configuring Yellowfin to authenticate via Okta
- Faster, fail-safe insights with a Yellowfin cluster
- JavaFX
- How to connect to a mail server that forces TLS 1.2
- Cluster Configuration Changes
- Setting up outgoing SMTP Server to send emails if Signals are Found (Gmail)
- ROOT directory is removed and yellowfin.war is re-deployed
- Could not load user with ipPerson 2
Yellowfin website & Licensing
- New to the Yellowfin community? Start here....
- Website Portal Changes Phase 1
- What is Yellowfin University?
- How Do I Login to Yellowfin University?
- How does concurrent licensing work in Yellowfin?
- License has been breached - Sysdate Skew detected error?
- License error, 'error: No license and Event Count Check'
- Why do I have the error License Breach: Event Count Check!
- Why do I have the error Licence Breach: Sysdate Skew detected when I try to login?
- How does concurrent licensing work within Yellowfin?
- Everything you ever wanted to know about the license / licence (no matter how you spell it) details page within Yellowfin!
- Is there another way to load the license other than through the Administration console?
- How to reset your portal login account used for the Yellowfin website
- How to get a login to the Yellowfin website
- Cannot log into the Yellowfin website
- Receiving error when logging into the Yellowfin website via the partner portal
- Yellowfin support policy & agreement
- How to use Community categories/articles/topics for RSS feeds
- Ticket/Topic Satisfaction Ratings
- Why do I have License Error on Concurrent Users but my license has not breached?
Uncategorized
- Grant admins access to view all current Private Reports - Stored Procedure
- The Yellowfin Task Scheduler
- Rollback change for Tomcat 8 and higher
- TimeZone Settings in Yellowfin
- Converting BMP, JPG, PNG etc. to SVG image for custom logo
- Oracle Java changes subscription offering
- Limitations of Exporting Content
- Configure SSL for Data Source connections
- How the database connection pool works
- JDBC Verify/Verify Source - What is it and when do I need it?
- How to add database JDBC drivers to the installer