Crystal Docs
English
English
  • Welcome
  • Fundamentals
    • Crystal
    • Crystal Topics
  • Crystal Advisor
    • Access to Crystal
      • Signup
      • Login
      • Discover the Advisor
        • Notifications
        • Account
    • Talk to Your Data
      • Conversation
        • Request Topics
          • Entity-Based Conversation
          • Context Memory
          • Autocomplete
        • Request a Data Analysis
        • Disambiguation
    • Explore Your Data
      • Suggestions
      • Topics Overview
      • Filter Topics
      • Ask Topics
      • Past Questions
      • Change Chart
    • Analyze Your Data
      • Automated Insights
      • Insight Analysis
      • Alerts
        • Anomaly Detection
        • Threshold Monitoring
        • Topic Scheduling
      • Forecasting (Beta)
    • Report and Discuss Your Data
      • Export Topic
      • Share Topic
      • Data Storytelling
    • Customize Your Experience
      • Choose Language
      • Choose Theme
    • Crystal on Mobile
      • Siri & Shortcuts
    • Crystal on Microsoft Teams
      • Download Crystal on Teams
  • Crystal Console
    • Configure Crystal
      • Discover the Console
      • Choose Project Settings
      • Prepare Your Data
    • Create Topics
      • Topic Creation: Overview
      • Topic Creation: Connect
        • Supported Data Sources
        • Supported Data Fields
        • Manage Data Sources
        • Tutorials for Specific Data Sources
          • Connect Google Sheets
          • Connect Google BigQuery
          • Build a Web Connector
      • Topic Creation: Configure
        • Objectives and Visualizations
        • Data Binning
        • Configure Custom Entities
        • Configure Key Values
        • Modify Data Table
      • Topic Creation: Filter
      • Topic Creation: Train
      • Topic Creation: Topic Details
      • Topic Creation: Set Permissions
      • Topic Creation: Review and Publish
      • Specifc Visualizations Guides
        • Build a List Table
        • Build a Single Line Chart
        • Build a Multi-Line Chart
        • Build a Ranking Table
      • Topic Creation: Custom Topic Titles
      • Topic Statuses
      • Data Preview
      • Manage Your Entities
    • Manage Users
      • Discover the Users Area
      • Invite Users to Crystal
        • Invite Users Manually
        • Invite Users via Identity Providers
          • Enable the Microsoft Identity Provider
          • Enable the Google Identity Provider
      • Create and Manage Groups
      • Manage Permissions
  • Limitations
    • Limitations on Crystal Advisor
    • Limitations on Crystal Console
  • Support
    • Support on Crystal Advisor
    • Support on Crystal Console
  • Release Notes
    • 2024
      • Crystal Web
        • Crystal Web v2.59
        • Crystal Web v2.58
        • Crystal Web v2.57
        • Crystal Web v2.56
      • Crystal Mobile
        • Crystal Mobile v3.1.7
        • Crystal Mobile v3.1.6
        • Crystal Mobile v3.1.5
        • Crystal Mobile v3.1.4
        • Crystal Mobile v3.1.3
        • Crystal Mobile v3.1.2
        • Crystal Mobile v3.1.1
        • Crystal Mobile v3.1.0
        • Crystal Mobile v3.0.39
        • Crystal Mobile v3.0.38
    • Archive
      • 2023
        • Version 2.55
        • Version 2.54
        • Version 2.53
        • Version 2.52
        • Version 2.51
        • Version 2.50
        • Version 2.49
        • Version 2.48
        • Version 2.47
        • Version 2.46
        • Version 2.45
        • Version 2.44
        • Version 2.42
        • Version 2.41
        • Version 2.40
        • Version 2.39
        • Version 2.38
      • 2022
        • Version 2.37
        • Version 2.35
        • Versions 2.29-2.30
        • Versions 2.27-2.28
        • Version 2.26
        • Versions 2.24-2.25
        • Version 2.23
        • Version 2.22
        • Version 2.21
        • Version 2.20
        • Version 2.19
        • Version 2.18
        • Version 2.17
      • 2021
        • Version 2.15
        • Version 2.14
        • Version 2.13
        • Version 2.12
        • Version 2.11
        • Version 2.10
        • Version 2.9
        • Version 2.8
        • Version 2.7
        • Version 2.6
        • Version 2.5
        • Version 2.4
        • Version 2.3
        • Version 2.2
        • Version 2.1
Powered by GitBook
On this page
  • Impacts on Conversation
  • Minimum Number of Configured Topics
  • Integration
  • Security
  • Complex Fields Types
  • Complex Fields Names
  • IAM
  • Groups
  • Console
  • Language
  • Topic Publishing
  • Topic Configuration
  • Maximum Configurable Values
  • Dynamic Filters
  • Join Tables
  • Fields Composition
  • Permissions

Was this helpful?

  1. Limitations

This page is constantly updated. Stay tuned!

PreviousLimitations on Crystal AdvisorNextSupport on Crystal Advisor

Last updated 9 months ago

Was this helpful?

As an Admin User, you need to be aware of the many possibilities that Crystal offers as well as of some limitations that you might encounter.

A deep knowledge of Crystal allows you to make the most of the experience!

Let's see an overview of the limitations in the Console's capabilities, broken down by Area and Feature and summarized.

You will also be redirected to the specific Feature page to find out more details!

Stay Tuned!

We are constantly working to improve our product: check out the section of this documentation to learn about most recent fixes and enhancements!


Impacts on Conversation

Minimum Number of Configured Topics

  • In order to guarantee an optimal conversational experience for the Member User, a minimum of 5/6 Topics must be configured in Console. With less Topics, Crystal might encounter training problems and not be able to recognize Entities.

Integration

Security

  • Crystal supports the connection to Data Sources with TLS >= 1.2

Complex Fields Types

  • At the moment Crystal is not supporting complex fields like:

    • “Json objects“ for Postgres

    • “LOB“ for Oracle

  • If such field types are present in a table, Crystal will not be able to use them in the Topic Configuration process, nor to preview the related data

Complex Fields Names

  • There are some restrictions on the use of special characters and punctuation signs in some fields, and in particular:

    • Crystal doesn’t support column names that contain special characters like .(),%$…

      • The presence of a special symbol inside a column name is causing the failure of the Topic retrieval

    • Crystal doesn’t support periods inside the schema name

    • Crystal doesn’t support column names that include "/" for dynamic filters

IAM

Groups

  • As of now, Crystal is not supporting Groups hierarchy (Groups belonging to other Groups)

Console

Language

Topic Publishing

  • It is not possible to edit a Topic without unpublishing it first

  • It is not possible to delete a Topic that is in the statuses of "publishing", "unpublishing" or "published"

Topic Configuration

  • It is not possible to select a “number” column in the "group by" field for a table without binning, even if the number is an integer

  • For Multi-Entity visualizations, it is not possible to use different aggregations or column types on Entities

Maximum Configurable Values

These are the maximum values available as you configure Topics:

  • Maximum number of Filters per Topic: 7

  • Maximum number of Filter Values ​​for a single Filter: 50.000

  • Maximum number of total Tables in the target DB: 40

  • Maximum number of Columns for a single Table: 24

  • Maximum number of Joins for a single Topic: 5

  • Maximum number of Topics: 100

Dynamic Filters

  • You can’t set a required Filter without a default value

  • You cannot have more than three mandatory filters (excluding the time filter)

  • At the moment, the Filter Values are updated only during the publication or depublication of a Topic: there’s no automated way to update the Filter Values without a training action

Join Tables

  • It’s currently not possible to join objects from different data sources

Fields Composition

  • It’s not possible to perform operations between different fields (es: column A + column B): you can create Custom Entities with aggregations instead

Permissions

  • A maximum of 1000 Filters can be allowed per User

  • Different logics for "Allow" and "Revoke" actions in Topics and Filters Tab

  • Missing visibility of permissions for inherited Topics / Filters

  • Missing visibility of permissions in Multiple or Mixed Targets selection

  • Missing "Revoke" option for Filters in Multiple or Mixed Targets selection


Please find out more details in the !

for Oracle, all the data types described are not supported either

Please find out more details in the !

Please find out more details in the !

Currently, Crystal Console is only available in the English language: the 5 languages supported (English, Italian, Spanish, French, German) refer to the languages available for and

Please find out more details in the !

Please find out more details in the !

Please find out more details in the !

Please find out more details in the !

Please find out more details in the !

Please find out more details in the !

Please find out more details in the !

Release Notes
related Feature page
here
related Feature page
related Feature page
training
conversation
related Feature page
related Feature page
related Feature page
related Feature page
related Feature page
related Feature page
related Feature page
Page cover image