none
OLAP Cube Builde error RRS feed

  • Question

  • Hi,

    when i am bulding OLAP cube in Project server ,i have get error,please check below italic font

    ===== Initiating OLAP database build process =====
    [7/25/2013 10:47 AM] Cube build request message has been added to the Project Server queue
    ===== Verifying and running pre-build server event handler =====
    [7/25/2013 10:47 AM] Verifying and running pre-build server event handler
    ===== Determining database and OLAP database structure =====
    [7/25/2013 10:47 AM] Cube build initialization started
    [7/25/2013 10:47 AM] OLAP database and cube structure was determined successfully
    ===== Building database and cubes =====
    [7/25/2013 10:47 AM] Cube build session started
    [7/25/2013 10:48 AM] 18 of the NT accounts that correspond to users that have 'View Olap Data' permission could not be added to the Project Server default OLAP role 'ProjectServerViewOlapDataRole'
    ===== Verifying and running post-build server event handler =====
    [7/25/2013 10:48 AM] Verifying and running post-build server event handler
    ===== Processing OLAP database =====
    [7/25/2013 10:48 AM] Process OLAP database session started
    ===== Process Completed =====
    [7/25/2013 10:48 AM] Failed to build the OLAP cubes. Error: Failed to process the Analysis Services database EPM on the EPM2010DB server. Error: OLE DB error: OLE DB or ODBC error: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.; 28000.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'EPM', Name of 'Timesheet List' was being processed.
    Server: The current operation was cancelled because another operation in the transaction failed.

     


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS

    Thursday, July 25, 2013 8:22 AM

Answers

All replies