The first step in the data mining process is to build and train a model to apply to a set of data in the database. The next step is to use what was learned to mine a relevant set of data. This topic describes the process of building an apply task which mines the data and stores the results in the database. Creating an apply task includes the following steps:
Select the database to use.
Select the model to apply.
Select the set of data to mine with the algorithm.
Execute the algorithm against the data to generate a set of results.
After you apply a model to a set of data, you can modify the apply task and run the algorithm against a different set of data. For information about viewing results, see Managing and Viewing Data Mining Results.
Mining Wizard steps you through the process of building or modifying an apply task:
To build or modify an apply task using Mining Wizard:
Select File, then Wizards, and then Data Mining Wizard to launch the Mining Wizard.
Select the server computer, the application, and the database to use and click Next.
Complete one of the following actions:
Select Create a New Apply Task, click Next, and go to Step 4.
Select Modify a Saved Apply Task, click Next, and go to Step 5.
If you are creating a task, from the list of saved build task models, select a model to use and click Next.
The Algorithm column shows the name of the algorithm that was used to build the model.
If you are modifying a saved task, from the list of saved apply task templates, select an apply task and click Next.
In the left pane, expand all nodes, and then complete the following steps:
If you want to change the setting for how the framework handles missing values, select Choose mining task setting, and in the right-hand pane, select the desired option.
If you want to change any parameter settings, select Specify parameter values for the task , and in the right-hand pane, select the desired option.
Under each accessor, select each attribute in turn to view the MDX expression, if any, entered for the attribute. The values from the build model are automatically provided for the apply model.
Change attributes as necessary to apply the model to a different set of data.
For example, change the sequence to analyze a different period of time.
Click Next.
Select Save and execute mining task, Save mining task, or Execute mining task.
If you select Save mining task or Save and execute mining task, enter the Template name. The template is stored in the Data Mining—Mining Templates node. Templates enable you to reuse and modify information to build a series of models. You can execute saved models from the Mining Templates node.
If you select Execute mining task or Save and execute mining task, enter the Mining Result and, if desired, a Mining Result Comment.
Click Finish to execute the task and/or save the task template.
To view the progress of the apply task execution, see Managing Data Mining Sessions for details.
To view apply task results, see Managing and Viewing Data Mining Results for details.
“MDX” in the Oracle Essbase Technical Reference
Mining an Essbase Database in the Oracle Essbase Database Administrator's Guide
create mining task template (MaxL)
display mining session (MaxL)
alter system stop mining session (MaxL)