Introduction to drilling, advanced drilling

Drilling is to change the level of dimensions and the granularity of the analysis. It includes a roll up and a drill down. Roll up is to generalize low-level detailed data to high-level summary data in a certain dimension, or reduce the number of dimensions; Refers to an analysis method that automatically generates summary rows.

Through the wizard, users can define summary lines for analysis factors, for example, for sales in each region and year, you can generate total rows for regions and years, or you can generate total rows for regions or years.

Drill down, on the other hand, goes from summarizing data to detailed data to observe or add new dimensions. For example, when a user analyzes sales by region or city, you can subdivide the sales of a city into sales for each year, and continue to subdivide the sales of a certain year into sales for each quarter. Through the drill-through function, users can have a deeper understanding of the data, and it is easier to find problems and make correct decisions.

Drill-through allows you to navigate through different levels of information within a report. in your business model.

, we define different levels of information, and these definitions also represent your approach to building your business.

You can extract from one layer of information to a lower or higher layer with detail. For example, if your data is organized by region, market, and store, and you can run a report that shows regional sales, you can drill down from a regional layer to show sales in the markets that make up that region. Instead, you can drill through the data from the store to see the market conditions in which the store belongs.

Hierarchical relationships sometimes refer to parent-child relationships. In the previous example, the region is the parent of the market, and the market is both the son of the region and the parent of the store; The store is a sub-market of the market.

If a composite measure exists in the report, another type of hyperlink.

Drillthrough appears. You can click on the measure header and break the composite measures into their simple measures. This is the same as performing a simple drill and selecting a "drill sub-measure" that doesn't have the selected row or column.

If you want to perform an advanced drill from a particular property, click More Options to connect to a particular property or metric within a simple drill scope. The drill --- advanced panel displays a down list, providing the option to drill through another layer or different layers within the same layer.

As an example of using advanced drillthrough to access properties in one tier to another, you can drill through from a subset of "Stores" in a geographic tier to a subset of "Customer Name" in a customer tier. Keep in mind that the tiers available to you are based on your company's model.

Use advanced drillthrough to drill through:

A new down list will appear. Click the "Update" button to display the properties in the selected layer, and then select the properties you want to drill through. If the DHTML is on, the properties are updated automatically and the Update button is not visible.

If you want to see the parent properties of a report, choose to keep the parent when drilling through the checkbox.

Click "Go".MicroStrategy Web sends a new report showing the details layer of the requirement.

To go back to a simple drillthrough, click back to go back to a simple drillthrough.

Note: Advanced drills are only available if you have the necessary MicroStrategy privileges.

"Diamond" is singer Karen Mok's ** "yes!".You Can Can. Lee Cheuk-woong and Jia Minshu wrote the lyrics, An Dong fought and raised the song and shouted, and Feng Yiji served as the MV director.

Diamond refers to polished diamond, which is a natural mineral that is the rough of diamonds. To put it simply, diamond is an elemental crystal composed of carbon that is formed under high pressure and high temperature conditions in the deep part of the earth. It is a symbol of love and loyalty.