如何在使用c＃的excel add中填充OLAP多维数据集数据 [英] How Can I populate OLAP cube data in excel add in using c#

问题描述

我正在使用数据透视网格来显示我的 OLAP多维数据集数据。



我是以网络形式制作的，但是想要在Excel中使用Cube字段树（使用c＃添加excel）我可以将字段和标签从树拖放到excel.Is它可能吗？

我想在C＃excel中添加树控件并将其与我的立方体绑定然后它将在excel中打开之后我想拖放字段和标签excel sheet。

I am working on pivot grid to show my OLAP cube data.

I had made it in web form but want Cube fields tree in excel (excel add in using c#) by which I can drag and drop fields and labels from tree to excel.Is it possible?
I want to place a tree control in C# excel add in and bind it with my cube then it will open in excel after that I want to drag and drop fields and labels in excel sheet.

推荐答案

是的，有可能，请看看如何使用Excel查看和分析OLAP数据立方体：

Yes, it is possible, take a look at How to View and Analyze an OLAP Data Cube with Excel :

Quote：

使用Excel查看和分析OLAP数据多维数据集



1.在Service Manager控制台中，单击Data 仓库，展开数据仓库节点，然后单击多维数据集。



2.在多维数据集窗格中，选择多维数据集名称，然后在任务下，单击在Excel中分析多维数据集。例如，选择SystemCenterWorkItemsCube并进行分析。



3. 当工作表在Excel中打开时，您可以从数据透视表字段列表中拖放字段并创建切片器和图表。



a）例如，如果要查看当前打开的事件总数，请展开IncidentDimGroup，然后选择已打开的事件。



b）您可以添加其他字段以生成更复杂的分析。例如，您可以通过选择DisplayName字段来添加ComputerDim维度中的计算机，以查看影响不同计算机的事件数。



（可选）您可以保存工作簿到共享文件夹或其他共享位置，例如分析库。有关分析库的详细信息，请参阅如何使用分析库。

To view and analyze an OLAP data cube with Excel

1. In the Service Manager console, click Data Warehouse, expand the Data Warehouse node, and then click Cubes.

2. In the Cubes pane, select a cube name, and then under Tasks, click Analyze Cube in Excel. For example, select SystemCenterWorkItemsCube and analyze it.

3. When the worksheet opens in Excel, you can drag and drop fields from the PivotTable Field List and create slicers and charts.

a) For example, if you want to see the total number of incidents currently open, expand IncidentDimGroup, and then select Incidents Opened.

b) You can add additional fields to generate a more complex analysis. For example, you can add computers from the ComputerDim dimension by selecting the DisplayName field to see the number of incidents that affect different computers.

Optionally, you can save the workbook to a shared folder or other shared location, such as the analysis library. For more information about the analysis library, see How to Use the Analysis Library.

这篇关于如何在使用c＃的excel add中填充OLAP多维数据集数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！