我想创建许多Analysis Services数据库,但不想手动创建Analysis Services表格项目。所以我运行了一些xmla脚本。数据库是在运行后构建的,但我不能显示或使用表中的值。当我运行DAX脚本"evaluate table_name"时,没有显示任何内容。
示例xmla脚本:
{
"创建":{"数据库":{"name":"SQA_200_12","兼容性级别":1200,"型号":{"文化":"en-US","数据源":[{"name":"SqlServer localhost SQATables","connectionString":"Provider=SQLNCLI11;数据源=localhost;初始目录=SQATables;集成安全性=SSPI;持久安全信息=false","模拟模式":"模拟帐户","account":"fareast\v-yanze","注释":[{"name":"ConnectionEditUISource","value":"SqlServer"}]}],"表":[{"name":"200_12","列":[{"name":"年份","dataType":"string","sourceColumn":"年份","sourceProviderType":"Char"},{"name":"Award","dataType":"string","sourceColumn":"奖励","sourceProviderType":"Char"},{"name":"类别","dataType":"string","sourceColumn":"类别","sourceProviderType":"Char"},{"name":"提名作品","dataType":"string","sourceColumn":"提名作品","sourceProviderType":"Char"},{"name":"Result","dataType":"string","sourceColumn":"结果","sourceProviderType":"Char"}],"分区":[{"name":"200_12","dataView":"已满","来源":{"query":"SELECT[dbo].[200_12].*FROM[dbo]][200_12]","dataSource":"SqlServer localhost SQATables"}}],"注释":[{"name":"_TM_ExtProp_QueryDefinition","value":"SELECT[dbo].[200_12].*FROM[dbo]][200_12]"},{"name":"_TM_ExtProp_DbTableName","value":"200_12"},{"name":"_TM_ExtProp_DbSchemaName","value":"dbo"}]}],"注释":[{"name":"ClientCompatibilityLevel","value":"400"}]}}}}
或者有什么不同的方法可以方便地创建分析服务数据库。非常感谢。
看起来您还没有处理模型。右键单击SSMS中模型数据库的名称,然后选择"处理"选项。