Features

SSAS (OLAP Cube)

SSAS (OLAP Cube)

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

Features

Overview
Slicer
Remote Bind
DataEngine Service(DataEngine)
DataEngine Service(DataSource)
DataEngine Service(SSAS)
SSAS (OLAP Cube)
Calculated Aggregates
Customer
Occupation
Country
Customer Count (Sum)
Occupation:Clerical;Customer Count:0;
Occupation:Management;Customer Count:0;
Occupation:Manual;Customer Count:0;
Occupation:Professional;Customer Count:0;
Occupation:Skilled Manual;Customer Count:0;
Customer Count:0;
436
771
248
1,436
700
3,591
166
245
25
548
587
1,571
558
95
788
235
134
1,810
566
129
673
259
153
1,780
589
176
609
275
264
1,913
613
1,659
41
2,767
2,739
7,819
2,928
3,075
2,384
5,520
4,577
18,484

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.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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();
        }
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
@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>
  
}