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

ID: Q245629

The information in this article applies to:

Microsoft SQL Server OLAP Services version 7.0

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()}'

REFERENCES

SQL Server 7.0 OLAP Services Books Online

Additional query words:

Keywords : kbdocfix kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug