Intelligent cubes in Microstrategy
Intelligent Cubes: Topics: Intelligent cubes Intelligent cubes Vs Cache Manage and Monitoring cubes Cube Size and Memory usage Accessing Intelligent cubes Dynamic sourcing Intelligent cube & Security filters Intelligent cubes & Multi-tenant Architecture Intelligent cubes & Level Metrics Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. Intelligent cube is a pre aggregated set of data stored in intelligent server memory and it will give very quick access to the data without hitting the data warehouse. It is very simple to create an intelligent cube, it is same like a report creation. When we create and publish intelligent cube, it stores all the data in intelligent server memory as well as a copy in file system (secondary storage area -Hard disk). Whenever it reboots, it loads the data to memory from the file · Stores data in intelligent server memory and in disk We have two ways to access th