Intelligence administration tool. Note that
this option will be listed on the Utilities
menu only if you are using Oracle Exalytics.
4. The Summary Advisor first uses log activity
to present aggregate recommendations.
Because you want to consider all
activity on your system for these recommendations, click Next on the first three
screens—Filter Logs - Logical Fact Tables,
Filter Logs - Time Window, and Filter
Logs - Execution Time Threshold—to
accept the default settings, which will
instruct the Summary Advisor to consider all log activity when making its
recommendations.
5. The Targets screen enables you to select
which physical database in your repository will be used to store the aggregates
recommended by the Summary Advisor.
Because you want to use Oracle Times Ten
In-Memory Database, select the details
that correspond to your Oracle Times Ten
In-Memory Database instance, such as
Database Schema: " 20 - RCU"..
"BIRCU_BIPLATFORM"
Connection Pool: " 20 - RCU"."RCU CP"
Capacity (MB): 200000
Click Add Target to register the target
database, and then click Next.
6. On the Select File Location screen,
click Browse to specify a filename and
a file system location for the script
the Summary Advisor will create for
you—C:\TEMP\summary_advisor.sql,
for example—and click Next.
7. The Stopping Criteria screen enables you
to place limits on how long the Summary
Advisor will spend generating recommendations. Again, click Next to accept the
default values, which place no limits on
the recommendation generation process.
8. On the Miscellaneous screen, leave
the Max size of any single aggregate
setting at its default maximum value
and click Browse to specify a location for
the script that can be used to rerun the
recommendation process—c:\TEMP\
rerun_advisor.xml, for example—and
click Next.
9. On the Run screen, click Run to generate
these recommendations.
Depending on the settings you chose
previously, the recommendation process
will take a few moments to run, and
then you will be presented with a list of
aggregate recommendations, as shown
in Figure 2.
10. On the Filter Aggregates screen, you can
select which aggregates will be included
in the script that the Summary Advisor
will generate.
For this example, leave all the aggregates selected and then click Next to
proceed to the final step.
11. On the final screen, Finish Script, click
Finish to direct the Summary Advisor to
create the specified scripts and close
the wizard.
CREATING THE AGGREGATES
At this point, the Summary Advisor has
created two scripts for you:
•;C:\TEMP\summary_advisor.sql contains
the aggregate definitions that you will need
to run through the nqcmd utility to create
or re-create the aggregate definitions in
Oracle Times Ten In-Memory Database and
the Oracle Business Intelligence Enterprise
Edition 11 g repository.
•;C:\TEMP\rerun_advisor.xml contains the
parameters you specified on the various
Summary Advisor screens.
Let’s now use the first script created by
the Summary Advisor to create the aggre-
gates it has recommended. To do this, close
the Oracle Business Intelligence administra-
tion tool; open a command-prompt session
(Start -> Run -> cmd.exe); and run the
nqcmd (nqcmd.exe) utility, using the fol-
lowing parameters:
C:\>"C:\Program Files\Oracle Business
Intelligence Enterprise Edition Plus
Client\oraclebi\orahome\bifoundation\
server\bin\nqcmd.exe" -d exalytics -u
biadmin –p welcome1 -s C:\TEMP\summary_
advisor.sql
After the script runs, you should see a
message indicating that several statements
have been executed successfully. You can
now reopen the Oracle Business Intelligence
administration tool, connect to your repository, and navigate to the Business Model
