• I still don't get it... then again SSAS leaves me confused on days that end with Y

    1. Say I have a well functioning cube.

    A. How do I turn data mining loose on it? I realize it's part of SSAS, but making it do anything seems confusing.

    B. How do I present the results of the Data Mining? Near as I can tell, the only way to do that is via the Excel Data

    Mining plug-in. Except of course the Excel DM plugin doesn't work with 64-bit excel.

    2. Do certain table designs work best for DM?

    3. Is there a simple way to bring the DM values into the cube itself? i.e. if I'm using the DM to extrapolate a growth curve, how would I have SSAS extend the line past the end of the data?



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]