Does Zoho Analytics support Relational modeling?

Does Zoho Analytics support Relational modeling?

Yes, Zoho Analytics supports relational modeling of your database. There are some limitations currently, which would be addressed incrementally to provide a powerful relational modeling capability in Zoho Analytics. The following are the important capabilities that are currently available:

  • You can create tables which have lookup columns between them. This helps you to create parent-child relationships
  • Zoho Analytics supports cascade-on-delete i.e. when you delete a row in the parent table, it will automatically delete the corresponding rows in the child table(s)
  • You can join tables using SQL Query table feature (Video on Creating Query Tables)
  • Zoho Analytics provides Auto-Join feature which automatically joins tables connected using lookup column, while creating reports.(Video on Auto-
    • Related Articles

    • What is the difference between Zoho Analytics and Zoho Creator?

      The key difference between Zoho Analytics and Zoho Creator is in-depth reporting and analytics vs online custom database application creation. Zoho Analytics enables you to easily create powerful and sophisticated reports with your data by creating ...
    • Analytics

      Overview Integrate Zoho SalesIQ with leading analytics platforms (Google Analytics, Clicky, KissMetrics Optimizely, Woopra, Piwik,MixPanel, HubSpot) and start collecting live chat related data into your analytics software. Measure your Live Chat ...
    • Does Zoho Analytics support SQL (Structured Query Language) Querying?

      Yes, Zoho Analytics supports full-fledged SQL based querying of your database. It understands SQL SELECT Queries written in any of the well-known database dialects including Oracle, Microsoft SQL Server, IBM DB2, Sybase, MySQL, PostgreSQL, Informix ...
    • What is Zoho Analytics?

      Zoho Analytics is an on-demand reporting and business intelligence solution that helps you get new insights on your business information through its powerful and flexible online business intelligence engine. You get powerful reports in minutes, with ...
    • Can Zoho Analytics be used as an Online Database?

      Zoho Analytics is an Online Reporting and Business Intelligence service. The features offered by Zoho Analytics specializes on providing in-depth, powerful and flexible reporting and analytical capabilities. It contains an in-built database grid ...