I have a custom C# assembly with a static method that I want to call from the
report MDX. I have signed the assembly, copied it to the C:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
folder. I have also added the assembly to the GAC. In the AssemblyInfo.cs
file for the custom assembly I added "[assembly:
System.Security.AllowPartiallyTrustedCallers]" .
When I try running the report from Reporting Services I get the following
error: "An error has occurred during report processing.
Query execution failed for data set 'AIMDBA1_Cube'.
Query (7, 2) The
'[AdHocOLAPProcs].[AdHocOLAPProcs].[AdHoc].[FilteredDateSet]' function does
not exist."
I have included the report MDX below where
"AdHocOLAPProcs.AdHocOLAPProcs.AdHoc.FilteredDateSet" is the call to the
custom assembly .
================= SELECT NON EMPTY { [Measures].[Number of Queries Run] } ON COLUMNS, NON EMPTY
(
[ClientProjectDim].[Project ID].[Project ID].ALLMEMBERS *
[UserDim].[UserName].[UserName].ALLMEMBERS *
[QueryDim].[Status].[Status].ALLMEMBERS *
[DateDim].[YearStarted].[YearStarted].ALLMEMBERS *
AdHocOLAPProcs.AdHocOLAPProcs.AdHoc.FilteredDateSet (
[DateDim].[ShortDateStarted].ALLMEMBERS,
"[DateDim].[ShortDateStarted].&[2005-03-01T00:00:00]",
"[DateDim].[ShortDateStarted].&[2005-03-12T00:00:00]")
)
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM
[Ad Hoc] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE,
FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
=================
Any ideas where I am going wrong?
Thanks,
SteveI realize this doesn't help you Steve, but I'm having the exact same
problem.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment