Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

model from an OLAP cube, too many cases evaluated...

 
   Database Help (Home) -> Datamining RSS
Next:  When the hash will involve in explain plan?  
Author Message
Jeje

External


Since: Jan 14, 2008
Posts: 69



(Msg. 1) Posted: Thu Jan 31, 2008 10:36 pm
Post subject: model from an OLAP cube, too many cases evaluated...
Archived from groups: microsoft>public>sqlserver>datamining (more info?)

Hi,

I create a model from a cube and the case attribute contains 2.6millions of
members.
but for the specific cube I'm working on for my model contains data for only
1millions of members.

but the DM model continue to use and analyze 2.6m so most of the time my
prediction is "non existing".

So how I can insure that the model will use only members really used in my
source cube instead of all the members from the dimension?
I try some "not null" options and filters, but nothing change.

Thanks for your help.

Jerome.

 >> Stay informed about: model from an OLAP cube, too many cases evaluated... 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
singleton query agains OLAP based model? - Hi, I have created a decision tree DM model from a cube. now I try the singleton query, but how to create the query???? the only samples I found works against an RDBMS model. so I'm not sure how to write my query: SELECT flattened [Test Dec..

Reprocessing a mining model - I'm currently developing a user registration prototype. The aim is to classify certain types of users. However, after the registration I query a decision tree model in Analysis Services with DMX and I want to send the user data into the warehouse to....

time series against a cube in SSAS2005, how to?????? - Hi, I try to create a simple test data mining model to forecast the sales. my cube contains a time dimension with only the fiscal years. I create my time series DM model, select the years as the key time, but when I try to publish the solution I'm..

Collation Problem any help - Hello all : My problem is like the following I have an online databse with a latin collation, this database is using ntext and nvarchar values that was with our previous admin ok the problem is in the data is stored should use another collation (the...

Trying to cut down query times - I have a query that is based on two other queries that are based on tables in a database. All of the queries that are used for this final query use grouping and totals. In the application I am making, I need to choose a date range to select the subset....
   Database Help (Home) -> Datamining All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]