Features

SSAS (OLAP Cube)

SSAS (OLAP Cube)

The PivotEngine component connect directly to OLAP cube provided by SSAS server.

Features

Settings

Description

The PivotEngine allows to connect directly to OLAP cubes provided by SSAS servers.

Set the CubeService.Url and CubeService.Cube properties that specify how the component should access the service.

using Microsoft.AspNetCore.Mvc;

namespace OlapExplorer.Controllers.Olap
{
    partial class OlapController : Controller
    {
        // GET: Cube
        public ActionResult Cube()
        {
            OlapModel.ControlId = "cubePanel";
            ViewBag.DemoOptions = OlapModel;
            return View();
        }
    }
}
@using C1.Web.Mvc.Grid
@{
    ClientSettingsModel optionsModel = ViewBag.DemoOptions;
}
<c1-pivot-engine id="cubeEngine" show-row-totals="Subtotals" show-column-totals="Subtotals">
    <c1-cube-service url="https://ssrs.componentone.com/OLAP/msmdpump.dll" cube="Adventure Works"></c1-cube-service>
    <c1-pivot-field-collection>
        <c1-cube-field header="Customer" dimension-type="Dimension">
            <c1-cube-field binding="[Customer].[Country]" header="Country" type="DataType.String" dimension-type="Hierarchy"></c1-cube-field>
            <c1-cube-field binding="[Customer].[Occupation]" header="Occupation" type="DataType.String" dimension-type="Hierarchy"></c1-cube-field>
            <c1-cube-field binding="[Measures].[Customer Count]" header="Customer Count" type="DataType.Number" dimension-type="Measure"></c1-cube-field>
        </c1-cube-field>
    </c1-pivot-field-collection>
    <c1-view-field-collection c1-property="RowFields" items="[Customer].[Country]"></c1-view-field-collection>
    <c1-view-field-collection c1-property="ColumnFields" items="[Customer].[Occupation]"></c1-view-field-collection>
    <c1-view-field-collection c1-property="ValueFields" items="[Measures].[Customer Count]"></c1-view-field-collection>
</c1-pivot-engine>

<div class="row">
    <div class="col-sm-4 col-md-4">
        <c1-pivot-panel id="@(optionsModel.ControlId)" items-source-id="cubeEngine"></c1-pivot-panel>
    </div>
    <div class="col-sm-8 col-md-8">
        <c1-pivot-grid id="indexGrid" items-source-id="cubeEngine"></c1-pivot-grid>
    </div>
</div>

@section Settings{
    @await Html.PartialAsync("_OptionsMenu", optionsModel)
}

@section Description{
    <p>@Html.Raw(OlapRes.Cube_Text0)</p>

    <p>@Html.Raw(OlapRes.Cube_Text1)</p>

}
@section Summary{
    <p>@Html.Raw(OlapRes.Cube_Text2)</p>

}