本文介绍了在表格模型上创建物理关系的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
限时送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屋!
更多推荐
[db:关键词]
发布评论