SSRS: A summary report based on a parent-child recursive relationship is implemented in the Cube through an MDX query

I wrote an article about summarizing and aggregating this parent-child relationship in SSRS development (SSRS series-Using the group group attribute to implement a summary report based on parent-child recursion), the query in the example is based on the SQL Server relational database, which is based on the MDX parent-child dimension SSRS report.

Using the time dimension in the previous article (the SSAS series-about the design of parent-child dimensions) and the parent-child Dimension and (SSAS series-Custom Date dimension design), create the Cube and deploy it on this basis.

Of course, the time dimension may not be used in this example because the SSDT development tool prompts you not to create a cube that contains only one dimension while the cube is being created.

Once the deployment is complete, we can look at the corresponding dimension and measure data through MDX.

SELECT ([measures].[ Sales Amount]) on COLUMNS,
       NON EMPTY ([employee].[ Employees]. Members) in ROWS from
[Biwork_parentchilddemo]