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


The information in this article applies to:

  • Microsoft SQL Server OLAP Services 7.0
  • Microsoft SQL Server 2000 (all editions)
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()}'

REFERENCES

SQL Server 7.0 OLAP Services Books Online
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbBug kbdocfix kbpending KB245629
©2003 Microsoft Corporation. All rights reserved.