Hi,
I am getting below issue while restoring backed up Appset. It is getting failed at OLAP database phase. Please help me to resolve the issue.
#2.0 #2010 12 08 18:02:26:870#-8:00#ERROR#OLAPServerHandler##EPM-BPC-MS##45d0c96e-77a3-49c3-9fbb-2a73b40d7197###Olap9Manager : CreateDimension#########Plain##
==============[System Error Tracing]==============
[System Name] : OLAPServerHandler
[Message Type] : ErrorMessage
[Job Name] : Olap9Manager : CreateDimension
[DateTime] : 12/8/2010 6:02:26 PM
[UserId] :
[Exception]
DetailMsg : {Microsoft.AnalysisServices.OperationException: Errors in the high-level relational engine. The data source view does not contain a definition for the 'IS_INPUT1' column in the 'dimP_ACCT' table or view.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'BP_Consolidation', Name of 'P_ACCT' was being processed.
Server: The operation has been cancelled.
at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Process(IMajorObject obj, ProcessType type, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, ImpactDetailCollection impact, XmlaWarningCollection warnings)
at Microsoft.AnalysisServices.Server.Process(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
at Microsoft.AnalysisServices.Server.SendProcess(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
at Microsoft.AnalysisServices.ProcessableMajorObject.Process(ProcessType processType, ErrorConfiguration errorConfiguration, XmlaWarningCollection warnings)
at Osoft.Services.Platform.YukonAdmin.Olap9Manager.CreateDimension(String strOLAPDimName, String strDimType, String[] strProper, String strDesc, String strLevels, Int32 intMaxHier, Int32 intProcessOption, String dimTablePrefx, String strCube, Boolean bFormula, String[] strFormulaLevels, String strCommand, String& strMsg, Boolean bOnlySharedDim)}
==============[System Error Tracing End ]==============
Environment: MS BPC 7.5 SP03
SQL 2008
Thanks,
Suraj