Hi. I have this problem and i hope i can find some help in here.
When i’m creating views with the BAM excell plugin at the end of the Wizard i get the next error.
“The cube could not be created successfully. Please edit the view and validate the inputs.”
Error details:
Error description:
OLE DB Error: OLE DB or ODBC error.
Error Source:
Microsoft OLE DB Provider for Analysis Services 2005.
It’s worth mentioning that the activities and the views are succesfully created. The only thing that fails is the pivot table view creation.
I have BizTalk 2006. Excell 2007. Windows XP & SQL Server 2005