how to increase maximim itemsize in mining structure in ssas
-
Saturday, February 16, 2013 11:02 AM
Hi all,
tid name description 1 one ones 1 four fours 1 three threes 1 eleven elevens 1 six sixes 2 ten tens 2 eleven elevens 2 five fives 2 four fours 2 seven sevens 3 one ones 3 eleven elevens 3 twelve twelves 3 six sixes the above is my actual table
After doing market basket analysis i got ,like
Bundle of items Bundle size Number of sales one, eleven 2 2 six, eleven 2 2 four, eleven 2 2 six, one 2 2 six, one, eleven 3 2 from this i need description for bundle of items like u can observe i need one,eleven for that i need description column like ones,elevens
please help
All Replies
-
Saturday, February 16, 2013 1:50 PM
Hi,
this are some of the sample queries shared with adventure works db
http://www.sqlserverdatamining.com/ssdm/Home/Tutorials/tabid/57/Default.aspx
hope this link helps u
This is SSAS forum ..Request you to please post your query in Data Mining Forum for faster replies
http://social.msdn.microsoft.com/Forums/en-US/sqldatamining/threads
Best Regards,
Silna
Please feel free to ask if you have any doubts and remember to mark the correct replies as answers.- Edited by silna Saturday, February 16, 2013 2:16 PM
.png)
