SSAS怎么样用asp.net进行前段展示?
我在SSAS进行了关联分析,然后想用asp.net进行前段展示,就类似于网站推荐系统那种,输入一个东西,猜你喜欢,然后调出关联分析的结果。
是不是用ADOMD做MDX查询就行了?调用微软的关联算法的MDX语句怎么写?
万分感谢!!! asp.net SSAS
[解决办法]
SELECT
FLATTENED -- Force reuslt to be a flat table
PredictAssociation( -- The method for invoking association prediction
[Association].[v Assoc Seq Line Items], -- The column reference of the association
INCLUDE_STATISTICS, -- one of the options: include stat in the result set
10 -- top 10 associated items
)
FROM [Association] -- The model being queried
NATURAL -- Automatically make the join based on column names
PREDICTION JOIN -- Specify the input by using a JOIN
(SELECT
(SELECT 'Sport-100' as [Model]) -- 'Sport-100' is the input category
AS [v Assoc Seq Line Items])
AS t