|Its is an single meta-data repository||It has two meta-data repository and based on a database·|
|Can be used on both web as well as a desktop tool||Cognos is an Web-based reporting tool|
|Supports Multiple Languages||Cognos has a Customizable Dashboard|
|Microstrategy reporting is fast||Cognos reporting is slow compared to Microstrategy|
Q. Benefits of Intelligent Cubes include?
Greater Efficiency – Intelligent Cubes are automatically generated and shared among all users whenever a report is executed by a user or pre-cached by the administrator or a user.
Easy to Use – Intelligent Cubes can be designed by mainstream BI users, using the same interface and the same operations as are used with basic OLAP analysis.
More Scalable Cubes – Intelligent Cubes do not need massive pre-calculations or pre-aggregations. The mid-tier Intelligence Server can do these calculations on-the-fly as the cubes are being used.
Increased Manageability and Reliability – Intelligent Cubes can be configured to expire or refresh automatically whenever underlying data or definitions change.
Increased Power for End-Users – The End-Users abe to drill seamlessly through to the full depth of the data warehouse, or slice and dice with speed-of-thought response time within the Intelligent Cube.
Q. Which of the End-user items leverage OLAP Services?
Microstrategy Web (Analyst and Professional versions), Microstrategy Desktop (Analyst and Designer versions) and Microstrategy Office can leverages the functionality that enabled by OLAP Services.
Q. What does an end-user need to do to take advantage of this?
The usage of OLAP Services is transparent to end-users. Users do not need to know the name and location of an Intelligent Cube, or even if it exists. OLAP Services works with Microstrategy Intelligence Server to automatically use the appropriate Intelligent Cube or create a new one to satisfy the end user request.
Q. How is security handled?
Intelligent Cubes used by OLAP Services automatically inherit all of the security provisions of every report object used within the Intelligent Cube, and those provisions are dynamically applied to each user’s security profile when the cube is accessed. If a user only has privileges to use four of the five metrics contained in an Intelligent Cube, that restriction will automatically and seamlessly apply when the user accesses the Intelligent Cube. The user will still have access to the Intelligent Cube for the four metrics he or she has privileges to use.
Q. Can I access Intelligent Cubes without OLAP Services?
Yes, with the appropriate version of Microstrategy Web or Desktop, certain functions leverage the Intelligent Cubes. These functions include: report formatting down to cell level, column aliasing, drilling, pivoting, page-by, adding metric thresholds, adding subtotals, ranking and sorting. Please see the Web and Desktop version comparisons to determine exactly which Web or Desktop version includes the desired functionality.
Q. Is OLAP Services sold as a separate product?
Yes, OLAP Services is sold as a separate product that is installed with Microstrategy Intelligence Server. It is licensed either on a per-user or per-CPU basis.
Get Updates on Tech posts, Interview & Certification questions and training schedules