Facts are objects created by and shared between MicroStrategy users. They relate numeric data values from the data warehouse to the MicroStrategy reporting environment. The facts you create allow users to access data stored in a data warehouse. Facts form the basis for metrics that are used in the majority of analyses and reports that users can create with MicroStrategy.
Facts are stored in the data warehouse in fact tables. These fact tables are composed of different columns, each cell representing a specific piece of information. This information is used to create a metric such as profit, which is a business measure.
Facts are based on physical columns in the data warehouse. When fact information is requested for a report in MicroStrategy, that column is accessed to retrieve the necessary data.
Like other schema objects such as attributes, facts are logical MicroStrategy objects that correspond to physical columns and tables. Unlike attributes, facts do not actually describe data. Facts are the actual data values stored at a specific fact level. A fact entry level is the lowest set of attributes at which a fact is stored.
Facts and attributes are necessary to define projects. In a MicroStrategy project, facts are numeric data and attributes are contextual data for the facts. As the project designer, you create projects that contain facts and attributes, which the users can include when building metrics and reports.
Microstrategy Related Interview Questions
|Informatica Interview Questions||IBM Cognos Interview Questions|
|Teradata Interview Questions||Adv Java Interview Questions|
|Cloud Computing Interview Questions||SQL Database Interview Questions|
|OBIEE Interview Questions||Qlik View Interview Questions|
|Tableau Interview Questions||Talend Interview Questions|
|IBM Cognos TM1 Interview Questions||Data modeling Interview Questions|
|Cognos ReportNet (CRN) Interview Questions||Qlik Sense Interview Questions|
Introduction To Advanced Reporting
Creating Freeform Sql Reports
Creating Olap Cube Reports
Data Mining Services
Custom Groups And Consolidations
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.