14 docs tagged with "ssas"

Drive SSIS processing packages, including stored procedure execution and SSAS database processing, from a tiny metadata model that scales to many tasks.

Action editor in BimlStudio

Aggregation Design editor in BimlStudio

Generate SQL Server Analysis Services projects programmatically with Biml automation

Define dimension and measure group metadata directly on the underlying tables, then assemble a multidimensional cube with role playing dimensions and partitions.

Calculation editor in BimlStudio

Cube editor in BimlStudio

KPI editor in BimlStudio

Partition editor in BimlStudio

Perspective editor in BimlStudio

Build SSIS packages that ProcessUpdate every dimension in an SSAS database, either as a single processing task or as one task per dimension inside a parallel container.

Use AMO inside BimlScript to find the most recently processed partitions in each SSAS measure group and emit a Partition Processing task that targets only those partitions.

Generate SSIS packages that process every dimension, the most recent fact partitions, and cube indexes in an SSAS database from a single Biml script.

An introduction to Biml and BimlScript covering what they are, why they exist, the tools that author them, the wider product ecosystem, and where Biml fits beyond SSIS.