Microsoft KB Archive/245629

= DOC: Cannot Call a Stored Procedure to Populate a Local Cube in INSERT INTO Clause =

Article ID: 245629

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server OLAP Services
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q245629



SUMMARY
The OLAP Services Books Online for SQL Server 7.0 (msdssbol.chm) contains an error in the "Listing Cube Elements" topic:

'* Note: The SELECT clause might just be passed through to the relational database. So a stored procedure could be passed in, for example.. The same comments are mentioned in the VBADOCreateCube sample, which is included with the MSOLAP\Samples\samples.exe file on the SQL Server 7.0 CD-ROM.

This is a documentation bug. When you select cube elements to create a local cube, you cannot use a stored procedure name in place of a valid SQL SELECT statement. You must use a valid SQL SELECT statement that specifies all of the dimensions and measures you want to include in the local cube.



MORE INFORMATION
If you replace the SELECT clause in an INSERT INTO statement with a stored procedure call, you will get this syntax error:

MS OLAP OLE DB provider "Syntax error, expecting SELECT, near '{CALL sp_myproc}'

