Hi all,

I have two Time dimension (one for Calendar Time and one for Fiscal
Time). Each time dimension has three levels, (i.e. Year, Quarter, Month)

I have set the drill through options and I'm getting this error 'Unable
to drill through. Data source provider error. Incorrect syntac near the
keyword 'from',;42000'. The error only occurs for Fiscal Time. It works
well with Calendar Time but not Fiscal Time. Only, at the 'All' level
it works but does not work for year, quarter or month.

I have tried troubleshooting using SQL Profiler and SQL Query Analyzer
and realized that the query that MSAS is running to drill through is
missing a bracket at the end of the statement. Unfortunately, I don't
know where to add this bracket because this is an MSAS thing.

Any suggestions??

Audrey


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I am experiencing the same exact problem. I believe this to be a bug in the
code generator of MSAS.

Is there any way to raise this issue up to a bug report with Microsoft SQL
Server support through this newsgroup?

"Audrey Ng" <odd26uk (AT) yahoo (DOT) co.uk> wrote

Drill through is working fine with MSAS, how are you using Drill
Through ?
If you are using Drill Through in Excel or office web component then
there
are problem in that Code and its not working correctely. if you want
to make it
work you need to write code using ADOMD with genrate MDX query and
pass it to SQL DB. it is complicated method i spend lot of time on
that ..

Thanks
Kris





Audrey Ng <odd26uk (AT) yahoo (DOT) co.uk> wrote

I have changed the type of OLE DB Provider in the Data
Source
from
Microsoft OLE DB Provider for SQL Server
to
Microsoft OLE DB Provider for ODBC Drivers.

And now I can drillthrough in all levels.

I have changed the type of OLE DB Provider in the Data
Source
from
Microsoft OLE DB Provider for SQL Server
to
Microsoft OLE DB Provider for ODBC Drivers.

And now I can drillthrough in all levels.

I have changed the type of OLE DB Provider in the Data
Source
from
Microsoft OLE DB Provider for SQL Server
to
Microsoft OLE DB Provider for ODBC Drivers.

And now I can drillthrough in all levels.

This error is occuring in MSAS. On previewing and drilling through, it
does not work.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!