无法处理维度OLAP多维数据集

Question

我尝试创建维度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.

我应该怎么做才能解决这个问题？感谢您的预支

Answer 1

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