在多维数据库中处理两个多维数据集 [英] Processing two cubes in multidimensional database

问题描述

您好。我试图解决一个错误，描述如下：

Hi. I am trying to solve an error that is described as follows:

有2个立方体cube1，cube2。这些多维数据集在一个多维数据库中。

There are 2 cubes cube1, cube2. Those cubes are in one multidimensional db.

我有2个excel文件。一个连接到cube1，另一个连接到cube2

I have 2 excel files. One has connection to cube1, and the other one to cube2

我正在尝试从c＃代码处理这些多维数据集，我遇到的问题是这个：

I am trying to process those cubes from c# code and the problem that I am facing is this one:

     如果我处理cube1并刷新连接到cube1的文件，它会更新。

      If I process cube1 and refresh the file with connection to cube1 it gets updated.

     如果我处理cube1并刷新连接到cube2的文件，则会出现如下错误：

      If I process cube1 and refresh the file with connection to cube2 it says an error like this:

它基本上说：

我们无法获得来自外部数据源的数据。

如果问题仍然存在，请联系外部数据源的管理员。

名为server-qa的分析服务器返回的错误消息是如下：

。立方体cube2不存在或尚未处理。

We were unable to obtain data from an external data source.
If the problem persists, contact the administrator of the external data source.
The error message returned by the analysis server named server-qa is as follows:
. The cube cube2 does not exist or has not been processed.

我使用的代码就是这个：

The code I am using is this one:

有谁知道可能的解决方法对此？

Does anyone know a possible work around to this?

推荐答案

当Excel抛出错误时 - 如果你的话，cube2是否有效打开与它的新连接？
$
处理cube1后cube2处于已处理状态？

（因为多维数据集上的ProcessFull通常不应处理root /共享维度，如果这些已经好的）



我刚刚处理了cube1与cube 2共享维度，同时保持2个Excel（O365 Business / 2019）工作簿打开（每个工作簿连接到不同的多维数据集： cube1，cube2）

对于测试立方体模型，使用最简单的星型模式，没有链接对象，远程分区等，通常没有高级功能。


没有任何Excel工作表抱怨任何错误，数据刷新和数据透视导航都没有任何问题。

When Excel throws error - does cube2 works if you open a new connection to it?
Is cube2 in processed state after processing cube1 ?
(because ProcessFull on cube shouldn't normally process root/shared dimensions if these are already good)

I've just processed cube1 having shared dimension with cube 2 while keeping 2 Excel (O365 Business/2019) workbooks open (each connected to a different cube: cube1, cube2)
For test cube model used simplest star schema without linked objects, remote partitions, etc., generally no advanced features.

None of Excel worksheets complained about any errors, data refresh and pivot navigation worked without any issues.

这篇关于在多维数据库中处理两个多维数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！