MicroStrategy Optimizations for Vertica

Forum to discuss topics related to accessing and using Vertica via MicroStrategy

Moderator: NorbertKrupa

Post Reply
User avatar
Site Admin
Site Admin
Posts: 1739
Joined: Sat Jan 21, 2012 4:58 am

MicroStrategy Optimizations for Vertica

Post by JimKnicely » Mon Nov 05, 2012 8:55 pm

Vertica-specific SQL Syntax
  • CASE expressions
    Sub queries
Multi-pass SQL for analytical sophistication
  • Union All support
    Support for temporary tables
Seamless support for key Vertica features
  • Vertica function library
Extensions to Vertica functionality
  • Aggregate awareness with physical summary tables
    Middle-tier computation of calculations not available in Vertica
    Middle-tier caching via Intelligent Cubes
    Report caching
Jim Knicely


Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “MicroStrategy”

Who is online

Users browsing this forum: No registered users and 1 guest