Share via

MDX Cube Hierarchy is behaving from Tabular Cube

Prabu, Chandran 41 Reputation points
2023-11-23T15:28:52.82+00:00

Capture.PNG

Cube is available in both MDX and tabular formats. The company wants whatever tabular template is available to be incorporated into the mdx version of the cube. However, there are some differences in behavior between MDX and Tabular. Please see the attached screenshot. When we drill down in the tabular, we get one more empty line to indicate the total of the first-level hierarchy, however this is not displayed in the MDX cube. Please let me know what the problem is. Thank you ahead of time.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,870 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,464 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alexei Stoyanovsky 3,416 Reputation points
    2023-11-24T11:37:45.9766667+00:00

    Cube is available in both MDX and tabular formats

    So far this seems your biggest problem: thinking there is only one cube with two minor variations. In fact, multidimensional and tabular engines are internally vastly different, so what you have are two distinct BI solutions that you tried hard to make as similar from end-user perspective as possible.

    The line with blank dimension member name most probably corresponds to the rows of the table you source your measure from that have no related rows in the table with the column used for the dimension.

    0 comments