View results of my algorithm with Microsoft Association Rules Viewer

Question

Hi,

is there any possibility to show results of my own data mining algorithm in built-in Microsoft Association Rules Viewer?

I created very simple algorithm which does nothing and AlgorithmNavigator (parent of AlgorithmNavigationBase) builds the same tree as Microsoft Association Rules Algorithm for two frequent items.

When I want to look at rules, I get this error: No data exists for the row/column. This error may be related to GetStatistics() procedure which for MS AR returns some table, but for my algorithm it returns only empty table.

 

Could somebody help, please?

Thank you!

 

Answer 1

Hi,

Can you show us your statement?

 

---

Regards, Ryan Lambatan
Please "Mark as Answer" or "Vote as Helpful"

Answer 2

Could you tell me, what statement do you mean, please?

Answer 3

I don't think this will be supported by Microsoft. If you what to try to make it work

1. Attach Profiler to SQL Server when viewer is loading and review all the queries that the viewer sends. Make sure that they work for your algorithm and return similar data (column names, data types etc)

2. Try returning table with one row instead of empty table, see if it will make things better.

 

Can you describe the problem you are trying to solve? Why do you have to implement new algorithm? How is it different from AR?

---

Tatyana Yakushev [PredixionSoftware.com]

Answer 4

My algorithm gets cross-level hierarchical association rules from data, it's primarily optimized for IP addresses and domains. I cannot use built-in AR algorithm for that.

When I look into the profiler results I can see that for Microsoft Association Rules Viewer is called:

CALL System.Microsoft.AnalysisServices.System.DataMining.AssociationRules.GetStatistics('Ar')

returns table with columns MAX_PAGE_SIZE, MIN_SUPPORT, MAX_SUPPORT, MIN_ITEMSET_SIZE, ... and values 2000, 2, 2, ...

Then is called

CALL System.Microsoft.AnalysisServices.System.DataMining.AssociationRules.GetRules('Ar', 0, 1999, 1, 1, 0.17, '', True)

 

For my algorithm there is called ...GetStatistics('hAR') only, which returns empty table. What I don't know is if I can somehow generate this table and its data. Maybe is there any chance to create this stored procedure and return the same data as Microsoft Algorithm returns? Is it real reason why GetRules() is not called?

 

Thank you

Answer 5

Hi,

so what is the verdict, can my managed plugin algorithm used built-in Microsoft Association Rules Viewer?

Thanks.

Answer 6

Hi,

I guess that I can used Microsoft Association Rules Viewer, but I have to have Mining.Content in the same format like ms assoc. rule algortihm. 

I did custom managed plugin for mining sequential rules. And I would like to use Microsoft Association Rules Viewer for view results. I did navigator that returns content in the same format like ms assoc. rule algortihm, but procedure System.Microsoft.AnalysisServices.System.DataMining.AssociationRules.GetStatistics('MyModel') always return no data/rows.
So where can be problem? Mayby proc. GetStatistics has some constraints and my content did not pass that constraints.
Who knows.
Thanks for reply.