Migrate dimensions in cubes to tabular

Question

Hi Experts,

I'm trying to replicate multidimensional cubes in tabular in order to deploy them on Azure.

Now I'm trying to re-create the hierarchies in each view. In tabular each hierarchy level has a source column, does it correspond to Key Column or Name Column in cubes dimension attributes?

And seems like we can only have one-level hierarchy in tabular? Is it possible to build Multi-level hierarchy in tabular like the multi-level attribute relationships we have in cubes?

Thank you,

Sida

Answer 1

Hi @何思达 ,

Welcome to the MS Q&A platform.

In Azure Analysis Services, the source column in each hierarchy level corresponds to the Key Column in cubes dimension attributes when working with tabular models.

Tabular models support multi-level hierarchies. You can create a multi-level hierarchy by adding multiple columns to the hierarchy in the desired order. For example, suppose you have a geography hierarchy with Country, State, and City. In that case, you can create a multi-level hierarchy by adding these columns in the specified order: Country -> State -> City.

To create a multi-level hierarchy:

<copied from the documentation page>

 To create a hierarchy, right-click a column you want to specify as the parent level, and then click Create Hierarchy. You can multi-select any number of columns (within a single table) to include, or you can later add columns as child levels by clicking and dragging columns to the parent level. When multiple columns are selected, columns are automatically placed in an order based on cardinality.

This will create a multi-level hierarchy in the tabular model, similar to the multi-level attribute relationships in cubes.

You can refer to the below documentation page on Tabular Model Hierarchies for general guidance. https://learn.microsoft.com/en-us/analysis-services/tabular-models/hierarchies-ssas-tabular?view=asallproducts-allversions

I hope this helps. Please let me know if you have any further questions.