|
<< Click to Display Table of Contents >> LOD |
  
|
|
<< Click to Display Table of Contents >> LOD |
|
In V8.5.1, Yonghong BI introduced a new calculation formula - LOD expression, which can facilitate business personnel, IT personnel or analysts to quickly and accurately calculate the above business indicators.
•Definition:
"LOD expressions" are used to run complex queries involving many dimensions at the data source level.
•Computational granularity:
Specify the dimension expression - Fixed: It may be rougher or more elaborate than view calculations. Depending on the dimension bound on the view and the dimension of the expression itself.
Include the dimension expression - Include: It may be more granular than the view level. Grouping includes not only the dimensions bound in the component, but also the dimensions specified in the expression.
Exclude dimension expression - Exclude: It may be rougher than view level granularity. The dimension specified in the expression is excluded when grouping.
•Case analysis:
We will use "multi-granularity expressions" to complete the following business analysis scenarios in the following sections:
1. How much does Florida contribute to sales profits across the Eastern Market?
2. What is the average annual total sales of each product category?
3. How to check the sales of a wide range of products at the same time?.
4. How to view the province under the market average profit and the province belongs to the market average profit standard situation?