CogInStr function fails with MSAS 2005

Hi,

Following MDX query works with MSAS 2000 but fails with MSAS 2005:

SELECT
{ FILTER([Product].AllMembers, CogInStr([Product].CurrentMember.Name,"*", 0) > 0) }
ON AXIS(0)
FROM [Sales]

Following error is thrown:

[ 1] Microsoft OLE DB Provider for Analysis S: Query (2, 32) The '[CogInStr]' function does not exist.

Any pointers on what needs to be done in order to support this query in MSAS 2005 would be appreciated.

Thanks and Regards,
Santosh

CogInStr - was not the built in funtion in AS2000, and it is not a built in function in AS2005 either. I suspect in your deployment somebody implemented custom UDF function with such name. You will need to implement it as a stored procedure in AS2005.

|||

Thanks for your response.
Yes, in AS2000 it was implemented as a UDF as shown below:

command = USE LIBRARY "CogUdf.CogRExp"
command = SELECT
{ FILTER([Product].AllMembers, CogInStr([Product].CurrentMember.Name,"*", 0) > 0) }
ON AXIS(0)
FROM [Sales]

Can you please give me some pointers (possible code snippets) on how I can convert this to a stored procedure in AS2005.

Thanks in advance,
Santosh.

|||Also, can't i use it in the same manner as it was in AS2000. i.e, through library function which i can execute using the USE LIBRARY call?|||

Please read BOL on the subject of stored procedures. Once they are deployed to the server, there is no need to do USE LIBRARY command anymore. For the extensive library of custom sprocs, you can check the following CodePlex project: http://www.codeplex.com/ASStoredProcedures

HTH,

Mosha (http://www.mosha.com/msolap)

|||The samples given in codeplex.com have been written in C#. Can stored procedures be implemented using OLE db for olap interfaces?|||You are not asking the right question. Take a look at the implementation of CogInStr - it doesn't use OLEDB for OLAP. You can easily replicate its functionality on C# or VB.NET or any other CLR language.|||

Sorry for the confusion.

I was trying to use the ASSP project with my MSAS 2005. I registered ASSP.dll under server assembly as a COM DLL type of assembly.

Later when I tried to run the following MDX query against the Adventure Works DW sample database, I am getting following error:

Query (1, 30) The '[ASSP].[FindCurrentMemberVerbose]' function does not exist.

Is there a link which demonstrate the use of these stored procedures with MSAS2005 and how to register it under Server/Database assemblies?

Thanks and Regards,
Santosh.

|||

I was able to use the Stored Procedure finally with MSAS 2005.

Thanks,
Santosh.