问题描述
大家好，
我们需要从内部SQL Server Analysis Services(多维模式)迁移到Azure Analysis Service.由于级别不是恒定的，所以我们有很多父子层次结构/参差不齐的层次结构.我正在浏览文档， 发现它在Azure分析服务中不可用.您能告诉我是否有任何解决方法，或者什么时候可用?
We need to migrate from on premise SQL Server Analysis services (Multidimensional mode) to Azure Analysis service. We have lot of parent-child hierarchies / ragged hierarchies as the levels are not constant. I was going through the documentation and found that it is not available in Azure Analysis service. Can you let me know if there is any work around or when it will be available?
https://docs.microsoft.com/zh-cn/sql/analysis-services/lesson-4-2-defining-parent-attribute-properties-in-a-parent-child-hierarchy?view=sql -server-2017
https://docs.microsoft.com/en-us/sql/analysis-services/lesson-4-2-defining-parent-attribute-properties-in-a-parent-child-hierarchy?view=sql-server-2017
推荐答案
您是否尝试过使用DAX公式和计算列来创建父子关系?我在这方面发现了一篇有趣的文章.
Have you tried out DAX formulas and calculated columns to create parent-child relationships ? I found an interesting article in this regard.
https://www.mssqltips.com/sqlservertip/5268/creating-ragged-hierarchies-in-sql-server-analysis-services/
https://www.mssqltips.com/sqlservertip/5268/creating-ragged-hierarchies-in-sql-server-analysis-services/
https://www.mssqltips.com/sqlservertip/5256/how-to-handle-a-parentchild-relationship-in-analysis-services-tabular/
https://www.mssqltips.com/sqlservertip/5256/how-to-handle-a-parentchild-relationship-in-analysis-services-tabular/
看看这些，让我们知道是否有帮助.否则，我们可以继续进行进一步的探索.
Have a look at these and let us know if it helps. Else, we can gladly continue to probe in further.
这篇关于关于Azure Analysis Service中的父子层次结构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！