时间戳

首页 > 解决方案 > 维度 OLAP Cube 无法处理

ssms - 维度 OLAP Cube 无法处理

问题描述

我尝试制作维度 OLAP Cube，但是当我处理维度时，结果是这样的错误：

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <Parallel>
    <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400" xmlns:ddl500="http://schemas.microsoft.com/analysisservices/2013/engine/500" xmlns:ddl500_500="http://schemas.microsoft.com/analysisservices/2013/engine/500/500">
      <Object>
        <DatabaseID>SSAS_siakad1</DatabaseID>
        <DimensionID>DI Mprovinsi</DimensionID>
      </Object>
      <Type>ProcessFull</Type>
      <WriteBackTableCreation>UseExisting</WriteBackTableCreation>
    </Process>
  </Parallel>
</Batch>
    Processing Dimension 'DI Mprovinsi' completed.
        Start time: 4/5/2021 8:28:17 PM; End time: 4/5/2021 8:28:17 PM; Duration: 0:00:00
        Processing Dimension Attribute '(All)' completed.
            Start time: 4/5/2021 8:28:17 PM; End time: 4/5/2021 8:28:17 PM; Duration: 0:00:00
        Processing Dimension Attribute 'NAMA PROVINSI' completed.
            Start time: 4/5/2021 8:28:17 PM; End time: 4/5/2021 8:28:17 PM; Duration: 0:00:00
Errors and Warnings from Response
    Internal error: The operation terminated unsuccessfully.
    The following system error occurred:  The user name or password is incorrect. 
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWH Siakad', Name of 'DWH Siakad'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DI Mprovinsi', Name of 'DI Mprovinsi' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'NAMA PROVINSI' attribute of the 'DI Mprovinsi' dimension from the 'SSAS_siakad1' database was being processed.
    Server: The current operation was cancelled because another operation in the transaction failed.

我应该怎么做才能解决这个问题？谢谢你提前

标签： ssmsssasolap-cube

解决方案

我会检查 SSAS 实例是否在安全属性中将您使用的用户注册到全进程，以及用户是否在 SSAS_siakad1 多维数据集中拥有 ProcessFull 的权限。尝试手动处理尺寸。

推荐阅读