image_1.pngCopyright©2024 Yonyou Group All Rights Reserved.Without the written permission of Yonyou Group, no part of this user manual may be copied, reproduced, translated, or reduced for any purpose. The content of this user manual may change without notice, please stay informed.Please note: The content of this user manual does not represent a commitment made by Yonyou Network.OverviewApplication OverviewThe data platform is centered around comprehensive data construction, technically covering every link in the data chain from data collection, data processing, data governance, to data services, data applications, and data presentation. This provides full-link, multi-channel data services for businesses, enterprises, and users both inside and outside the ecosystem. On the business side, the goal is to achieve data-driven business innovation by aggregating and governing cross-domain data, supporting data asset management and data value transformation, abstracting and encapsulating data into services, and realizing business innovation. The application architecture of the data platform is as follows:image_2.pngThe Indicator Platform is a sub-product of the Data Platform, which includes dimension modeling and indicator management. Indicator management consists of indicator library management and indicator development. Indicator development supports the creation of atomic, derived, and composite indicators, while the indicator library supports the management of indicator business attributes, batch upload, and batch download. Dimension modeling is responsible for constructing the star schema in the dimension data warehouse, creating the DWD detail tables and DIM dimension tables. Atomic indicators aim to define the aggregation methods of indicators, while composite indicators aim to create the DWS layer of the data warehouse through data aggregation. The Indicator Platform builds an overall data hierarchy for a dimensionally visualized data warehouse, enhancing the efficiency of data applications. The indicator library module for business indicator management supports the definition of indicator business attributes, batch upload, download, etc. The application architecture of the Indicator Platform is as follows:image_3.pngApplication ValueStandardized data warehouse modeling enhances the performance of data analysis and presentation. The product can build both relational models and multidimensional models, providing systematic and visual online modeling and development capabilities. By standardizing the modeling process of dimensions and facts, it reduces the occurrence of multiple JOIN operations during data analysis, lowers the complexity of SQL statements, and thereby alleviates the pressure on the database engine during data analysis and presentation.The technical threshold is low, which is beneficial for the implementation and use of the product. During the design of the product, the data warehouse modeling and indicator management are created in a guided manner, reflecting flexibility and ease of use, simplifying complex theories into a simple drag-and-drop approach.Operation and maintenance are convenient, facilitating daily management for maintenance personnel. It supports the management of development tasks and logical table tasks, tracking task execution progress and status. Basic information, code, and corresponding generated instances can be viewed. Development tasks correspond to ordinary instances, while logical table tasks correspond to logical table instances. Instances are generated after the task scheduling starts running. In addition to viewing basic information and code, running logs can also be accessed for troubleshooting when errors occur, allowing for quick resolution. Both tasks and instances can view their dependency relationships.The product has high safety, ensuring the protection of enterprise data assets. It supports tenant isolation, facilitating collaboration among multiple departments while ensuring data security; it also supports project isolation, creating different physical spaces for different projects, which ensures data security and maintains clear processes, making task management easier.Application ScenariosScenario Display: Building Human Efficiency Analysis Application Based on Indicator Database Across DomainsBusiness DescriptionA certain company wants to build a human efficiency analysis dashboard based on financial and human resource indicators. Human efficiency analysis is a comprehensive process that requires in-depth analysis and evaluation from multiple aspects, including personnel, compensation, receivables, profits, etc., to ensure that the enterprise can effectively utilize human resources and improve production efficiency and competitiveness.Business Processimage_4.pngScenario Display: Building Consumer Behavior Analysis Application Based on Multidimensional Modeling TheoryBusiness DescriptionA company wants to classify customers based on their value and provide targeted product services and marketing models. There is an existing sales order table that needs to analyze important value customers and customer transaction volume based on relevant historical data. This way, relevant departments can take immediate action based on the analysis report to ensure the company's subsequent profitability.Business Processimage_5.pngApplication ListData Source ManagementTask ManagementBusiness SegmentBusiness DomainBusiness ProcessTime LimitProject ListDimension ManagementFact Table ManagementBusiness LimitationsIndicator ListOperation GuideDimensional ModelingOverviewDimensional modeling is used to manage fact tables, dimension tables, and summary tables related to indicator management. Dimension tables are associated with fact tables to form a star schema; atomic indicators and derived atomic indicators in indicator management are bound to fact tables in dimensional modeling; derived indicators in indicator management form summary tables in the DWS layer of the dimensional model.Overall ValueVisual Management Dimension Model;Standardized Indicators and Dimensional Models.Related ContentDimension ManagementFact Table ManagementSummary Table ManagementOverview of Dimensional ModelingThe overview of dimensional modeling is the information architecture of the dashboard page that displays various statistical indicators of the current tenant. It helps managers quickly view the information of the tenant, understand the overall product situation, and facilitates users to browse and click on the details they want to know more effectively.Quick and convenient access to view various metrics of tenants;Various chart forms allow viewing from multiple dimensions;Help users understand product capabilities;Effectively browse and click on the details you want to know.Dimension ManagementDimensions are extracted from physical tables and can be created as regular dimensions, hierarchical dimensions, or enumerated dimensions based on the physical table. Regular dimensions are single dimension indicators, hierarchical dimensions are dimension indicators with hierarchical relationships, and enumerated dimensions are dimension indicators containing enumerated values.When creating a dimension, it is necessary to ensure that the table name is unique within the schema; otherwise, the dimension table cannot be created.When creating a dimension table, please operate correctly according to the page requirements, otherwise the creation will fail.Column NameDescriptionChinese NameChinese description of the dimension table, 100 charactersEnglish NameEnglish description of the dimension table, 100 charactersTypeTransaction, Periodic SnapshotCreation MethodNew: Ordinary Dimension, Hierarchical Dimension, Enumerated Dimension, Time Dimension Registration: Relational Model Registration for Ordinary Dimension, Physical Table Registration for Ordinary Dimension, Physical Table Registration for Hierarchical DimensionStatusOnline, DraftOperationsOnline: Offline, Online Edit, Initialize Data, Move Position, Scheduling Operations: Publish, Delete, Edit, Move Position, ScheduleDimension ManagementEnter the 【Dimension Modeling -> Dimension Management 】 function to access the dimension list page, where you can view all dimensions within the current project, including virtual dimensions. However, the dimension list does not support the creation of new virtual dimensions.image_6.pngDimension management is used by users to manage dimensions within the project. It can filter according to the directory structure of the data domain on the left side. Users can add, publish, edit online, edit, delete, set as public dimensions, move positions, and perform scheduling operations on dimensions.image_7.pngAdd NewClick the button and select the dimension type you need to add. The content to be filled in varies for different dimension types, so choose according to the specific synchronization requirements.image_8.pngRegister Common DimensionClick the button to enter the registration page. Register the existing table as a dimension table, and fill in the basic information, field settings, and dimension associations.image_9.pngReleaseSelect the dimensions to be published, and click the button. Dimensions in draft status will be converted to online status after publication, and dimensions in online status can be associated with fact tables. Dimensions in online status must have their related tables or metrics that depend on them taken offline before they can be taken offline themselves. Dimensions in draft status can be deleted or edited.EditSelect the dimension that needs to be edited, and click the button to enter the editing page to modify the corresponding information.Online EditingThe dimension table task is in an online editing state, and it can be edited online for those that have no impact on downstream processes.Online editing supports modifying the Chinese names of tables, adding fields, adjusting scheduling cycles, etc.DeleteSelect the dimension to be deleted, click the button. Dimensions with no dependencies can be deleted, and deletion requires a second confirmation.Set as a public dimensionSelect the dimensions that need to be set as public dimensions, and click the button. After being set as public dimensions, they will be visible in the public dimensions and available across projects.Move LocationSelect the dimension that needs to be moved, click the button, and modify the data domain to which the dimension table belongs.image_10.pngSchedulingSelect the dimensions that need to be configured for scheduling, click the button, and modify the data domain of the dimension table.Scheduling Method: Time Scheduling, Manual ExecutionChange 【Manual Execution 】 to 【Scheduled Execution 】 without judging the downstream.【Time Scheduling 】 changed to 【Manual Execution 】 to determine downstream.If there is a downstream and the downstream is manually executed, it can be modified;If there is a downstream and the downstream is time-scheduled, it cannot be executed. Remind "Downstream has manual execution, cannot be changed to periodic."image_11.pngimage_12.pngAdd Ordinary DimensionEnter the 【Dimension Modeling > Dimension Management 】 function, click the button, select , and you will enter the page to add a regular dimension.Basic InformationEnter the 【Basic Information 】 page, where you need to complete the Chinese name, English name, data domain, schema, main table selection, and primary key definition. The Chinese name should be input in Chinese characters, with a length of 64; the English name should consist of English characters and underscores, with a length of 100; the main table selection is the physical table that primarily sources the fields of t...
