ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

What is MiscroStategy ? MicroStrategy -Objects, Schema and more -Interview Questions/Answers

Updated on September 11, 2015

What is MicroStrategy?

MicroStrategy is a leading Business Intelligence tool which existing independently by itself (for now). Business Intelligence technology providing integrated reporting, analysis, and monitoring software that helps the decision support system in an organization.

What is MicroStrategy’s Technical Definition?

MicroStrategy is a Business intelligence tool with a ROLAP engine which can connect to almost any databases.

What is MicroStrategy means?

MicroStrategy is an object oriented model with an attractive and an easy to use graphical user interface for developers and end users. MicroStrategy is a reporting tool, which is used to create and send reports, also used to create ad-hoc report and dashboards for mobiles, emails.

There are main two version of this tool Web version and Client Version.

Web version: Generally web version is used for the users.

Client version: Generally client version is used for the developer.

Metadata, I-server, web server, and Narrow cast Server are the main components of the MicroStrategy.

What are the main roles in MicroStrategy?

There are main three different roles on MicroStrategy.

Administrator: By default, the role/person will have full access to the environment. In other words this role has full access to all the type of objects mentioned above.

Architect: By default, access to configuration objects is restricted.

Developer: By default, no access to configuration objects, use access to schema objects and full access to public objects.

MicroStrategy Brief View

Source

What is the RDBMS means?

RDBMS stands for: Relational Database Management Systems

What is Data modeler?

Someone who designs the project, and creates data model.

What is Heterogeneous mapping?

Heterogeneous mapping is used to map any attribute to the column which is not identical in names and but same in meaning.

What is OLTP?

OLTP stands for Online transactions Processing

OLTP is a system which deals with operation data.

OLTP is a class of program that facilitates and manages transaction – oriented application, typically for data entry and retrieval transaction in a number of industries.

What is OLAP?

OLAP stands for Online Analytical Processing

OLAP is a process where it allows its use to easily extract and view the data.

OLAP is computer processing that enables a user to easily and selectively extract and view data from different points of view.

What are the Differences between ROLAP, MOLAP and HOLAP?

MOLAP stands for Mutlidimensional Online Analytical Processing

In this form of storage, data is stored in the form of multidimensional cubes. Data is not stored in the relational database.

ROLAP stands for Relational Online Analytical Processing

As the name suggests this is a method which helps in manipulating the data using the clauses of the relational databases eg. Where clause

HOLAP stands for Hybrid Online Analytical Processing

HOLAP tries to combine the positive aspects of both MOLAP and ROLAP in order to leverage the storage and processing capability of data.

Advantages of MOLAP:

  • Fast in data retrieval (recovery)
  • Complex calculations can be performed very fast

Advantages of ROLAP:

  • Can use the relational database functionalities
  • Can handle large amounts of data

Advantages of HOLAP:

  • Faster performance of MOLAP
  • Drill through capabilities of ROLAP

What are the types of MSTR objects available?

There are only and only three types of object in MicroStrategy. They are same follows:

  1. Schema objects
  2. Application objects
  3. Configuration objects

Source

Schema Objects:

A schema is a collection of database objects. Schema objects are the logical database structure that characterizes database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database.

Schema objects are logical structures created by users. Schema objects characterize various sections of the logical data model, including logical data model components such as facts, attributes, and hierarchies. Report designers can use these schema objects to create application objects such as metrics, filters, templates, and eventually reports. The default schema objects in the Schema Objects folder are populated when you create a new project. The Schema objects are grouped into the following subfolders (types of Schema Objects).

  • Attributes
  • Facts
  • Functions and Operators
  • Hierarchies
  • Partition Mappings
  • Tables
  • Transformations

A schema is owned by a database user and has the same name as that user. There is no relationship between a tablespace and a schema. Objects in the same schema can use storage in different tablespaces, and a tablespace can contain data from different schemas.

Schema objects can be created and manipulated using SQL. As an administrator, you can create and manipulate schema objects, just as you do with the logical and physical structures of your database using Oracle Enterprise Manager. The underlying SQL is generated for you by Oracle Enterprise Manager.


Application/Public Objects:

These objects are used to deliver analysis of and insight into relevant data.

Application objects are objects that a report designer can directly manipulate, such as reports, metrics, filters, and prompts.
You can use each of these objects to add different types of reporting flexibility and functionality to a business intelligence application.

Public objects are just a folder in metadata which “mainly” holds application objects, it is not a type of objects. Security Filter is a configuration object even though it is created the way application objects are created.

Common application objects include (types of Application/ Public objects)

  • Reports
  • Documents
  • Filters
  • Templates
  • Metrics
  • Prompts
  • Custom Groups
  • Searches
  • Drill Maps


Configuration Objects:

Configuration objects are MicroStrategy objects which can be re used in multiple projects and they appear in the system layer. Configuration objects are MicroStrategy objects which can be re used in multiple projects and they appear in the system layer. Configuration objects are created using the Administration option in Microstrategy Desktop.

Object included in this category are:

  • Connectivity information – Data base Instances
  • User privileges – Users, Groups
  • Project administration
  • Schedules


What are the two types of schemas available in DataWare?

Star Schema and Snowflake Schema


What is Star schema?

Star Schema:

One fact table surrounded by all the three or 4 or 5 any no. of dim table. Symbol looks

like star schema. This is more de-normalized data.

In the star schema design, a single object (the fact table) sits in the middle and is drastically associated to other surrounding objects (dimension lookup tables) like a star. Each dimension is represented as a single table. The primary key in each dimension table is related to a foreign key in the fact table. A star schema can be simple or complex. A simple star consists of one fact table; a complex star can have more than one fact table.

Image Example of Star schema

Source
Source

What is Snowflake Schema?

Snowflake:

The snowflake schema is an extension of the Star Schema, where each point of the star detonates into more points. In a star schema, each dimension is represented by a single dimensional table, whereas in a snowflake schema, that dimensional table is normalized into multiple lookup tables, each representing a level in the dimensional hierarchy.

One fact table is bounded by different dim table but this dim table is splited into different levels.

This is more normalized data.

Image Example of Snowflake Schema

Source
Source

What is the difference between Star Schema and Snowflake Schema?

Star Schema:

  • De-Normalized data structure
  • More data dependency and redundancy
  • Query result faster
  • View Star Schema structure
  • Simple DB structure
  • No parents table
  • Category wise single dimension table
  • Don’t need to use complicated join


Snowflake Schema:

  • Normalized data structure
  • Less data dependency and no redundancy
  • Some delay in query processing
  • Complicated DB structure
  • View Snowflake Schema structure
  • Complicated join
  • Dimension table split into many pieces
  • It may contain parent table



Comments

Submit a Comment

No comments yet.

working

This website uses cookies

As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

Show Details
Necessary
HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
LoginThis is necessary to sign in to the HubPages Service.
Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
AkismetThis is used to detect comment spam. (Privacy Policy)
HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
Features
Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
MavenThis supports the Maven widget and search functionality. (Privacy Policy)
Marketing
Google AdSenseThis is an ad network. (Privacy Policy)
Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
Index ExchangeThis is an ad network. (Privacy Policy)
SovrnThis is an ad network. (Privacy Policy)
Facebook AdsThis is an ad network. (Privacy Policy)
Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
AppNexusThis is an ad network. (Privacy Policy)
OpenxThis is an ad network. (Privacy Policy)
Rubicon ProjectThis is an ad network. (Privacy Policy)
TripleLiftThis is an ad network. (Privacy Policy)
Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
Statistics
Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)