Hi
I have the following query used to predict the values in 2006 based on cluster model built using 2004 and 2005 data. I'm using a prediction join on a cube containing the data. I can join a single dimension from the cube to a column in a the data mining model. However when I try to join to a column in a nested table I get this error:
Executing the query ...
Obtained object of type: Microsoft.AnalysisServices.AdomdClient.AdomdDataReader
Internal error: An unexpected exception occured.
Execution complete
The query I'm running is this
select t.*
, Predict([Time].[Deal Count])as predicted_deal_count
, Predict([Time].[Deal Revenue])as predicted_deal_revenue
, Cluster()
From
[Time]
prediction join
(
select {[Measures].[Deal Count], [Measures].[Deal Revenue]} on 0,
non empty {{[Time].[Month Number Of Year].[Month Number Of Year].members} *
{[Country].[KeyCountry].[KeyCountry].members} * {[Country].[Region].[Region].members}} on 1
from [DM]
where ([Time].[Year].&[2006-01-01T00:00:00])) as t
on
[Time].[Month Number Of Year] = t.[[Time]].[Month Number Of Year]].[Month Number Of Year]].[MEMBER_CAPTION]]]
and [Time].[Country].[KeyCountry] = t.[[Country]].[KeyCountry]].[KeyCountry]].[MEMBER_CAPTION]]]
and [Time].[Country].[Region] = t.[[Country]].[Region]].[Region]].[MEMBER_CAPTION]]]
I'm running SQL Server 2005 with SP2 CTP2.
Thanks
Sanjay
Given the limited error message - we need to try additional queries to see if we can narrow the problem down. Alternatively, you could send us a backup of your database - let me know if this is an option.
Can you see if this query works? Does it return what you expect?
select t.*
From[Time]
NATURAL prediction join
(
select {[Measures].[Deal Count], [Measures].[Deal Revenue]} on 0,
non empty {{[Time].[Month Number Of Year].[Month Number Of Year].members} *
{[Country].[KeyCountry].[KeyCountry].members} * {[Country].[Region].[Region].members}} on 1
from [DM]
where ([Time].[Year].&[2006-01-01T00:00:00])) as t
|||
Hi,
Your query works as expected, all the selected data from the cube is return. It would be possible to send you the cube offline, do you need the just the cube or the relational db as well?
Thanks
Sanjay
|||A backup of AS database with the cube and model is enough. Please remove any additional objects (e.g. cubes or mining structures) to reduce the database size. You can also do a process clear structure only on the Mining Structure to reduce the size even further. Try compressing it as well (although it should be compressed already).
You can send the data to jamie "at" sqlserverdatamining.com and we'll look into the issue
Thanks!
|||We are still looking into this issue - thanks for your patience.
