Showing posts with label analysis. Show all posts
Showing posts with label analysis. Show all posts

Wednesday, March 7, 2012

Dont think Discretization function is necessary on the Analysis Service server in SQL Server 200

Hi, all here,

I am just wondering about the Discretization function available on analysis service server (which can not actually discretize data into user-defined expressions) . Isnt it redundant ? I mean since users can discretize their data more meaningfully based on their own expressions in database engine of SQL Server 2005.

Thanks a lot.

It is helpful in many circumstances. If you want a column discretized into statistically meaningful buckets, but there's no particular business reason for the breakdown, it is very useful. If there are particular business reasons for where the bucket divisions should occur, then you are correct, you should manually discretize apriori.

Eliminating a necessary preprocessing step for algorithms that don't support continuous values makes data mining easier for a wider range of people.

Tuesday, February 14, 2012

Does the OLE DB Provider for OLAP Services Work with RS

Thanks in advance for any and all help ...
I'm exploring using reporting services to report on analysis services data
sources. When I try to create the connection it gives me a data link error
'Provider is no longer available.' I'm not sure where in windows I manage
OLE DB providers, but I decided to install the latest version of MDAC. This
did not seem to do anything ...
Any ideas on how to get the provider installed?
Thanks!It does but you'll have to write the MDX yourself I'm afraid :(.
--
Brian Knight
SQL Server MVP
http://www.sqlservercentral.com
Reporting Services Resource Center -
http://www.sqlservercentral.com/rc/rc.asp?rc=105
"See Guy" <123@.123.com> wrote in message
news:%23MUEklRZEHA.3692@.TK2MSFTNGP09.phx.gbl...
> Thanks in advance for any and all help ...
> I'm exploring using reporting services to report on analysis services data
> sources. When I try to create the connection it gives me a data link error
> 'Provider is no longer available.' I'm not sure where in windows I manage
> OLE DB providers, but I decided to install the latest version of MDAC.
> This
> did not seem to do anything ...
> Any ideas on how to get the provider installed?
> Thanks!
>