Thursday, January 18, 2018

Knowi Product Update Q4 2017

To see these exciting new capabilities in action, please join Lorraine Williams, Head of Success at Knowi, for a web demo on Wednesday, January 31th at 11:00 AM PT.

Lovin' Query Management

Our query capabilities are at the heart of what makes Knowi different.  We constantly add capabilities but in the past few weeks we've focused our efforts and added a number of enhancements:  

Join Builder
In addition to performance improvements to the Join functionality, we now provide query join assistance from within the Query page. The supported joins types are listed along with auto-detected key field candidates for each side of the join. You can, of course, still enter the join criteria manually.

Join Query Help
Save Query as Draft
You now have the ability to save a query in progress without creating an associated dataset and widget.  Go for that coffee break!

View Query Change History
Wondering who messed up your query?  Wonder no more.. you now have the ability to view an audit history of query changes. This is only applicable if the user has edit permissions for the query in question. From the Query Listing page, a history icon is now available.  When clicked, the user will username and timestamp of when each change was made.

Query Filters Suggestions
In Query, filters auto-suggestions and hit list filter capabilities can now be seen from within the Query Builder itself.

Join Post-Processing
You can now apply Cloud9QL functions to a dataset post join.

Preview Data at Each Join Step
You can now preview dataset results at each join step.  This can be especially useful when you have multiple join steps.

We're Getting Slacky

Slack integration allows you to trigger actions in your slack channel(s) for a given condition triggered by an alert. When the condition is triggered, we'll send a message to a predefined channel(s) including the attachment of full data or conditional data depending on the options selected.

Stranger Danger

Enterprise data security is top of mind for everyone.  Whenever we can, we leverage new security capabilities from our database partners as quickly as possible.

SSL Support
We now support SSL enabled MarkLogic and Datastax/Cassandra

Role-based access control (RBAC) Support
We now support RBAC in Couchbase 5.0

Access Control List
The system now supports the ability to create white and black lists of datasource assets (tables/collections/indexes). This will allow the datasource creator to specify those assets available to subsequent queries. The datasources that support the ACL functionality are currently: Elasticsearch, Oracle, Knowi Elasticstore

Other Cool Stuff

Email Reporting Improvements
Parametrized Report Templates The Email Report function has been enhanced to pass in user-lever query filters, ensuring only the data the recipient is allowed to see is contained within the report. Any dataset attachments also adhere to the passed in parameters.

Analyze Grid Formatting
A number of usability enhancements we made including:
  • Ability to view statistical data for numerical columns
  • Added formatting options for numeric and data columns: currency, date, percent and decimal place
  • Ability to resize columns
  • Added Count option for column aggregation
  • Added 'does not equal' as an operand in the conditional grid formatting options 
Embed API Formatting
An option has been added into the JS Embed API that allows for auto-sizing of content based upon the full height of the dashboard. 

 New Datasources
Added support for
  • Apache Hive
  • Couchbase 5.0
Cloud9QL Enhancements
Cloud9QL Function AutoComplete
When adding a function in Analyze or preview modes, the system now gives a dropdown list of C9QL functions available along with autocompleting capability

A new CLoud9QL function has been added that allows you to control the display of numerical values. The format is NUMBER_FORMAT(<number>,<format>), and an example is:   select number_format(clicks,##,###.00) as Number of clicks

If your data is a JSON string, the PARSE function can be used to convert it into an object which can then be further manipulated and processed.

Provide an alternate value to be used in case the specified field doesn't exist or the value is NULL.


Post a Comment

Please share your thoughts. If you have a question, please reference our docs section at