官术网_书友最值得收藏!

Chapter 2. Setting Up an Analytics Semantic Layer and Public Objects

Semantics in general means the meaning of a message behind the words, so when we say semantic in terms of BI, it means the meaning of data from the user's perspective. It is the keystone of any data warehouse project, as it allows better understanding of requirements, the design of successive data models, and a link between the physical data model and the reporting tool, in our case MicroStrategy. In the previous chapter, we learned about setting up an environment for MicroStrategy, so in this chapter we can dig deeper and understand about the semantic layer and the objects needed to present data to an end user.

This chapter will cover:

  • BI architecture
  • The project design process
  • Defining schema objects
    • Creating attributes
    • Defining parent-child relationships
    • Building hierarchies
    • Creating facts
  • Defining public objects
    • Creating simple and complex metrics
    • Adding filters
    • Creating prompts
主站蜘蛛池模板: 乡城县| 曲周县| 淄博市| 三原县| 广宗县| 临江市| 襄垣县| 玉门市| 理塘县| 麻栗坡县| 保靖县| 万荣县| 托克逊县| 湖南省| 塔河县| 峨山| 政和县| 渭南市| 肇源县| 湛江市| 绥棱县| 泰安市| 临颍县| 尉犁县| 南靖县| 宁蒗| 化州市| 若尔盖县| 治多县| 家居| 运城市| 磴口县| 三门县| 绥芬河市| 梅河口市| 芜湖县| 永嘉县| 岗巴县| 图木舒克市| 射阳县| 兴和县|