Datamining a Olap Cube

I'm new to datamining and have gather some knowledge by following the tutorial that comes with sql server 2005.
I have following created a association mining model and tested it by using various DMX queries. I works quite satisfactory.

But I would like to use this mining model on a cube. Ie a calculated measure that would show top 1 recommendation for my customer portfolio.
My knowlede reaches to the extent that you need to feed data by using the OpenQuery or OpenRowset queries.
I would like to "stick" my model to the cube on some way and the extract values in the same manner as filtering criterias in stead of manually generating DMX queries.

I have googled a bit and searched MSDN without luck. Maybe I'm looking at this all wrong.

Is this possible?

Regards Bergur

Could this help?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1640504&SiteID=1

It presents an example of how to create a custom action containing a data mining prediction. Not really a calculated measure, but still a way to associate a prediction result with an cube cell.

Alternately, you could try this more complex approach:

- have your transaction data in the same cube

- build an OLAP mining model based on the cube

- use the MDXPredict MDX function to retrieve predictions from a mining model inside the calculated measure

Datamining a Olap Cube

I'm new to datamining and have gather some knowledge by following the tutorial that comes with sql server 2005.
I have following created a association mining model and tested it by using various DMX queries. I works quite satisfactory.

But I would like to use this mining model on a cube. Ie a calculated measure that would show top 1 recommendation for my customer portfolio.
My knowlede reaches to the extent that you need to feed data by using the OpenQuery or OpenRowset queries.
I would like to "stick" my model to the cube on some way and the extract values in the same manner as filtering criterias in stead of manually generating DMX queries.

I have googled a bit and searched MSDN without luck. Maybe I'm looking at this all wrong.

Is this possible?

Regards Bergur

Could this help?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1640504&SiteID=1

It presents an example of how to create a custom action containing a data mining prediction. Not really a calculated measure, but still a way to associate a prediction result with an cube cell.

Alternately, you could try this more complex approach:

- have your transaction data in the same cube

- build an OLAP mining model based on the cube

- use the MDXPredict MDX function to retrieve predictions from a mining model inside the calculated measure

Database 'XXX' does not exist

Hi.
I'm trying to make a asp.net page to connect to a olap cube.
When i trying to connect to my Analysis Server I receive the error:
Database 'XXX' does not exist.
My config is
-SQL Server 2000 Enterprise Edition SP3
-Analysis Services SP3
-MDAC 2.8
i already added <identity impersonate ="true" /> to web.config
My connection string is "Provider=MSOLAP.2;Data
Source=localhost;Initial Catalog=XXX;"
Thanksare you sure that the 'XXX' database exits?
what are the roles of this cube?
what is the authentication you use?
Message posted via http://www.droptable.com|||i'm sure that my database exists because i can use the MDX application (the
basic example provided with the installation of Analysis Services) to
execute queries.
I would like to succeed in querying the basic example of olap cube FoodMart
2000 in asp.net.
I use anonymous authentification
"allison via droptable.com" wrote:

> are you sure that the 'XXX' database exits?
> what are the roles of this cube?
> what is the authentication you use?
> --
> Message posted via http://www.droptable.com
>|||is IIS and AS running on the same box? otherwise this could be a classic
2-hop problem. The reason why the database might not exist is that you are
coming in anonymously and the NT Anonymous account might not have access to
the database.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"David Leclerc" <DavidLeclerc@.discussions.microsoft.com> wrote in message
news:FE7DA5F8-E258-4820-BB68-F3FA253ACB8E@.microsoft.com...
> i'm sure that my database exists because i can use the MDX application
(the
> basic example provided with the installation of Analysis Services) to
> execute queries.
> I would like to succeed in querying the basic example of olap cube
FoodMart[vbcol=seagreen]
> 2000 in asp.net.
> I use anonymous authentification
>
> "allison via droptable.com" wrote:
>|||Thanks, it's worked