I've created an analysis services project in BIDS with the intention of creating a mining strucuture. I notice that you cannot create a data source view based on a query and that it must be based on linking actual tables (via the access looking
GUI). In my scenario I have a very long and complicated query which uses temp tables to retreive the data I want to use for mining. Am I forced to insert this data into a table in order to create and use a mining structure? Or are there
other ways to do it?
View Complete Post