Error on using VB in calculated members AFTER stepping up to Enterprise version ?

I have "succesfully upgraded" (?) our SQL2005 from standard to Enterprise version.
Before, following set worked like a charm:

CREATE SET CURRENTCUBE.[Now CY]
AS strtomember("[00 - Time].[00 - H - Calendar].[Day Name].&[" + format(now(),"yyyyMMdd") + "]");

But when I process the cube now, I get this error:

Error 1 MdxScript(Sales) (58, 74) The '[now]' function does not exist. 0 0

It seems like the reference to Visual Basic has been lost somehow
Curiously following calculated member works, even it also uses now() ?

CREATE MEMBER CURRENTCUBE.[MEASURES].[Now]
AS now(),
FORMAT_STRING = "yyyyMMdd",
VISIBLE = 1;

Any suggestions ?
please ;-)

/ geert larsen

denmark

Can you reproduce this problem in Adventure Works Enterprise Edition? Another thing to try is the qualified name: VBA![Now]()|||

Hello Deepak
Thanks for your reply
unfortunately the VBA![Now]() did not work
(And I have not installed the AdventureWorks )

BUT I have investigated a little further in the Assemblies and found that ie. the VBAMDX
is registred in C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdvbanet.dll
But this directory is empty ?
Now the file(s) are situated in C:\Program Files\Microsoft SQL Server\MSSQL.6\OLAP\bin\

I have tried to copy the files and re-register (regsvr32 msmdvbanet.dll)
but I get this error:
C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdvbanet.dll was loaded, but the DllRegisterServer entry point was not found.
This file can not be registered.

I hope this may give you (and then me) a hint

tia
/ geert larsen
denmark

|||Well, msmdvbanet.dll is not a COM server, therefore you cannot register it with regsvr32. There is something that went wrong during setup or upgrade, and the problem with VBA might not be the only one. I recommend reinstalling from scratch.|||

Complete un- and reinstall solved the problems *NOT FUNNY*

Thanks for advice

/ geert larsen

denmark

error message Only members of sysadmin role are allowed to update .....

Question to those who may have had this same error- it seems that I am not able to delete some of the reports that I have created. This just started happening recently and according to our system admin nothing has changed as far as permissions are concernced. We installed SP2 the other day and I was wondering if this could have anything to do with the error message below

by the way I am a member of the sysadmin group

thanks in advance

km

System.Web.Services.Protocols.SoapException: Server was unable to process request. > System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login. Only members of sysadmin role are allowed to update or delete jobs owned by a different login. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.DBInterface.DeleteObject(String objectName) at Microsoft.ReportingServices.Library.RSService._DeleteItem(String item) at Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId) at Microsoft.ReportingServices.WebServer.ReportingService2005.ExecuteBatch() End of inner exception stack trace

It looks like you are getting this error because the report has a schedule associated with it and most likely you recently changed the way you connect to the Report Server database. To fix this you will need to set the owner for all of the Report Server SQL Agent jobs to be the user that RS is using to connect to it's database.