Hello I loaded several tables from sql and created relationships between them. But as soon as I try to add fields from another table
inside the pivot table I get an error message. Can someone please help to fix this?
============================
Error Message:
============================
Exception from HRESULT: 0x800A03EC
----------------------------
----------------------------
The command was canceled. Please press F1 to get the help topic "Excel Window: PowerPivot Field List" for more details.
============================
Call Stack:
============================
Server stack trace:
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Office.Interop.Excel.CubeField.set_Orientation(XlPivotFieldOrientation RHS)
at Microsoft.AnalysisServices.XLHost.Addin.ExcelInterOpUtil.AddToFields(String cubeFieldName, XlPivotFieldOrientation pivotOrientation, Int32 positionIndex)
----------------------------
at Microsoft.AnalysisServices.XLHost.Addin.ExcelInterOpUtil.AddToFields(String cubeFieldName, XlPivotFieldOrientation pivotOrientation, Int32 positionIndex)
at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivot.SetFieldOrientation(PivotArea location, IGeminiColumn column, Int32 positionIndex)
----------------------------
at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivot.SetFieldOrientation(PivotArea location, IGeminiColumn column, Int32 positionIndex)
at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivot.AddToFieldListInternal(PivotArea location, IGeminiColumn column, Int32 positionIndex)
at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivot.MoveField(IGeminiColumn column, PivotArea source, PivotArea target, Int32 positionIndex)
at Microsoft.AnalysisServices.XLHost.Addin.FieldListControl.MoveFieldInternal(IGeminiColumn field, PivotArea sourceArea, PivotArea targetArea, Int32 targetIndex)
============================
inside the pivot table I get an error message. Can someone please help to fix this?
============================
Error Message:
============================
Exception from HRESULT: 0x800A03EC
----------------------------
----------------------------
The command was canceled. Please press F1 to get the help topic "Excel Window: PowerPivot Field List" for more details.
============================
Call Stack:
============================
Server stack trace:
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Office.Interop.Excel.CubeField.set_Orientation(XlPivotFieldOrientation RHS)
at Microsoft.AnalysisServices.XLHost.Addin.ExcelInterOpUtil.AddToFields(String cubeFieldName, XlPivotFieldOrientation pivotOrientation, Int32 positionIndex)
----------------------------
at Microsoft.AnalysisServices.XLHost.Addin.ExcelInterOpUtil.AddToFields(String cubeFieldName, XlPivotFieldOrientation pivotOrientation, Int32 positionIndex)
at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivot.SetFieldOrientation(PivotArea location, IGeminiColumn column, Int32 positionIndex)
----------------------------
at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivot.SetFieldOrientation(PivotArea location, IGeminiColumn column, Int32 positionIndex)
at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivot.AddToFieldListInternal(PivotArea location, IGeminiColumn column, Int32 positionIndex)
at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivot.MoveField(IGeminiColumn column, PivotArea source, PivotArea target, Int32 positionIndex)
at Microsoft.AnalysisServices.XLHost.Addin.FieldListControl.MoveFieldInternal(IGeminiColumn field, PivotArea sourceArea, PivotArea targetArea, Int32 targetIndex)
============================