MicroStrategy Intelligent Cubes – Learn MicroStrategy starting from Overview, Environment Setup, Desktop, Architecture, Components Overview, Importing data . You can create Intelligent Cubes and publish them as a shared data source for the users to build reports from. Intelligent Cubes provide the fast response time. Intelligent cubes are multi-dimensional, in-memory copies of data that can be queried and accessed by many different documents and reports. Basically, the.

Author: Vudozuru Salkree
Country: Malawi
Language: English (Spanish)
Genre: Education
Published (Last): 19 July 2011
Pages: 372
PDF File Size: 9.26 Mb
ePub File Size: 16.36 Mb
ISBN: 286-6-13720-519-7
Downloads: 74088
Price: Free* [*Free Regsitration Required]
Uploader: Taudal

Overview of Mobile SDK. In general, this method works the following way: Sharing sets of data among reports: Creating an Intelligent Cube is very easy. Are you sure you would like to use one of your credits tokens to micfostrategy this title?

Intelligent Cubes: Dynamic Sourcing vs View Reports

Level prompts Filtering based on attribute forms, elements, hierarchies: When the specific cases specified in the other methods are meet. Objects containing the drill map Order of precedence of drill maps: Opmerkingen of suggesties over de documentatie van MicroStrategy Suggesties voor verbetering van het product Productbeschrijvingen en verpakkingsinformatie van MicroStrategy.


Intelligent cubes are multi-dimensional, in-memory copies of data that can be queried and accessed by many different documents and reports. The report cache contains pre-calculated and pre-processed report data that is saved on disk and in Intelligence Server memory.


While a report cache is saved in memory and on disk, the personal Intelligent Cube is only kept in Intelligence Server memory. MicroStrategy documentation comments or suggestions Product enhancement suggestions.

SQL and analytical customization Metric column aliases: This website uses cookies to ensure you get the best experience on our website. Grazie per avere dedicato del tempo per fornirci un tuo commento.

MicroStrategy – Intelligent Cubes

A shared Intelligent Cube called an Intelligent Cube is a set of data that can be shared as a single in-memory copy, among many different reports created by multiple users. Whatever objects that you create inside the MicroStrategy layer gets stored in their Metadata database. There are some restrictions on the types of objects and functions that are supported, but most of the common stuff is covered, and more features are added each version.

Consolidations, custom groups, and derived elements Consolidations Consolidations: This allows MicroStrategy to treat it as a database in memory which is extremely fast and can be extremely flexible if you know the nuances of how to use them.

Report Details Displaying report details Enabling and disabling report details Levels of report details configuration Interaction of report details preferences and report details for reports Configuring report details settings Configuring the display of object name delimiters for report details Configuring report details Configuring the display of template details Including objects from the base or view report Displaying the base template name Interaction of report details preferences and template details for reports Configuring the prompt details Prompt details: Intelligent Cube Population methods in MicroStrategy 9.


Relational analysis with personal Intelligent Cubes. The disadvantage in this method is that the not normalized table is transferred through the network, which could be noticeable inteligent in slow network environments. The internal testing shows that this method is in general better than any other method, and that is why this method is the default one.

MicroStrategy | TN Intelligent Cube Population methods in MicroStrategy 9.x

If only certain lookup tables needeā€¦. The cube lives in both memory and as a file on disk, so when the server restarts or crashesthe can quickly be reloaded into memory. Outline mode Grouping data by page: Four steps to achieve data mining in MicroStrategy. Thanks for your feedback. Building an advanced security model. Meeting the MicroStrategy Community. Send us an email to leave your feedback.

After this process is done for each dimension, obtain one unique table for all the attributes and one fact table that contain the fact columns plus the lowest level attribute ID columns.