处理 SSAS 表格 - 一个分区并保留数据库

Question

目标是刷新一个命名分区和其他具有默认"分区"架构的对象(其他表没有分区(，而无需定义表。

等：

{
"refresh": {
"type": "full",
"objects": [
{
"database": "Database",
"table": "Table1",
"partition": "P1"
},
{
"database": "Database",
"partition": "partition"
}
]
}
}

这是我们的实际代码：

{
"refresh": {
"type": "full",
"objects": [
{
"database": "Database",
"table": "Table1",
"partition": "P1"
},
//This code is confusing
{
"database": "Database",
"table": "Table2"
},
{
"database": "Database",
"table": "Table3"
}
....
//
]
}
}

Answer 1

你的代码是完全有效的。所有表至少有一个分区。出于此处的目的，您可以将表视为一个或多个分区的容器。

因此，在执行刷新命令时，必须定义将刷新模型中的哪些对象。在您的情况下

{
// the command you will run, "refresh"
"refresh": {
// The type of refresh, "full"
"type": "full",
// The scope of your command, an array of objects which will be refreshed
"objects": [
// First object, a single partition, "P1" in the table "Table1"
{
"database": "Database",
"table": "Table1",
"partition": "P1"
},
// The second object, the table "Table2" (technically, all partitions in "Table2",
// which in your case is 1 default partition)
{
"database": "Database",
"table": "Table2"
},
// The third object to be processed, "Table3"
{
"database": "Database",
"table": "Table3"
}
// More objects to be processed 
, ...
//
]
}
}

不能定义"多维数据集中的一个分区和所有其他内容"的命令。您可以定义一个由单个分区和每个单独表显式组成的事物数组。