Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Mastering Business Intelligence with MicroStrategy

You're reading from   Mastering Business Intelligence with MicroStrategy Master Business Intelligence with Microstrategy 10

Arrow left icon
Product type Paperback
Published in Jul 2016
Publisher Packt
ISBN-13 9781785884405
Length 396 pages
Edition 1st Edition
Arrow right icon
Authors (4):
Arrow left icon
Neil Mehta Neil Mehta
Author Profile Icon Neil Mehta
Neil Mehta
Himani Rana Himani Rana
Author Profile Icon Himani Rana
Himani Rana
Ning Ma Ning Ma
Author Profile Icon Ning Ma
Ning Ma
Dmitry Anoshin Dmitry Anoshin
Author Profile Icon Dmitry Anoshin
Dmitry Anoshin
Arrow right icon
View More author details
Toc

Table of Contents (13) Chapters Close

Preface 1. Getting Started with MicroStrategy FREE CHAPTER 2. Setting Up an Analytics Semantic Layer and Public Objects 3. Building Advanced Reports and Documents 4. Advanced Visualization Techniques 5. Customization of MicroStrategy 6. Predictive Analysis with MicroStrategy 7. Accelerating Your Business with Mobile Analytics 8. Data Discovery with MicroStrategy Desktop 9. MicroStrategy System Administration 10. Design and Implementation of the Security Model 11. Big Data Analytics with MicroStrategy 12. MicroStrategy Troubleshooting

Schema objects

Schema objects represent different components of the logical data model and are directly mapped to a column or columns in the database. Attributes, facts, functions, and operations, hierarchies, partition mappings, tables, and transformations are all schema objects; however, three schema objects comprise the core of project definition and will be covered in this section:

Schema objects

Attributes

Attributes are the descriptive part of the database. They provide information about the data; for example, customer name and city are attributes. The SELECT clause of a SQL statement is based on these attributes.

The following is the report with the Policy Number and Broker Name as an attribute:

Attributes

When we see the SQL for this report, the Policy Number and Broker Name will be shown in the SELECT clause as follows:

Attributes

Attribute types

We have three different types of attribute:

  • Compound attribute
  • Homogenous attribute
  • Heterogeneous attribute

Compound attribute: Uses two or more columns as its ID. It is like...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime