在表格模型上创建物理关系

本文介绍了在表格模型上创建物理关系的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

限时送ChatGPT账号..

是否可以在不使用 Power BI、Power Pivot 或 Analysis Services Table 的情况下在表格模型上创建物理关系?

Is it possible to create a physical relationship on the tabular model without using Power BI, Power Pivot, or Analysis Services Table?

更准确地说，我可以创建与编码(c#、 core)和使用包或库的物理关系吗?

To be more precise, can I create a physical relationship with coding (c#, core ) and using a package or library?

谢谢

推荐答案

with this package: Microsoft.AnalysisServices.Tabular此代码工作:

with this package: Microsoft.AnalysisServices.Tabular this code work:

using Server server = new();
server.Connect(Configuration["ConnectionString:SSAS"]);
var database = server.Databases.FindByName(Constants.SSASDB);
var fromTable = database.Model.Tables.Find("sourceTableName");
var toTable = database.Model.Tables.Find("destinationTableName");
SingleColumnRelationship columnRelationship = new();
columnRelationship.Name = "relationName";
columnRelationship.FromColumn = fromTable.Columns.Find("sourceColumnName");
columnRelationship.ToColumn = toTable.Columns.Find("destinationColumnName");
columnRelationship.FromCardinality = RelationshipEndCardinality.One;
columnRelationship.ToCardinality = RelationshipEndCardinality.Many;
columnRelationship.CrossFilteringBehavior = CrossFilteringBehavior.OneDirection;
columnRelationship.SecurityFilteringBehavior = SecurityFilteringBehavior.OneDirection;
columnRelationship.RelyOnReferentialIntegrity = false;
columnRelationship.IsActive = true;
database.Model.Relationships.Add(columnRelationship);
database.Model.SaveChanges();

这篇关于在表格模型上创建物理关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！