none
Getting error while processing dimensions and cube-source Oracle is Oracle 11 and SSAS is SSAS 2008 R2

    Question

  • Hi, 
    I am getting below error while processing dimensions and cube. Source is Oracle 11 a and SSAS R2.
    Internal error: The operation terminated unsuccessfully.
    OLE DB error: OLE DB or ODBC error: ORA-12154: TNS:could not resolve the connect identifier 
    specified.
    Errors in the high-level relational engine. A connection could not be made to the data 
    source with the DataSourceID of 'ds_Pharmacy', Name of 'ds_iDWH_PBMA_VIEW'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 
    'DIM_Order', Name of 'DIM_Order' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Order Desc ' attribute of 
    the 'DIM_Order' dimension from the 'Database_Pharamcy' database was being processed.
    Can you please help on this?
    Regards,
    Manjunath

    Saturday, October 12, 2013 5:22 AM

Answers

All replies