Figure 3: Aggregate tables mapped into the Business
Model and Mapping layer
and Mapping layer to check out the new
aggregate logical table sources that will have
been automatically mapped in for you. For
example, Figure 3 shows the F0 Revenue
Base Measures logical table with seven new
logical table sources mapped to it, repre-
senting the seven in-memory aggregates that
were created by the Summary Advisor script.
TESTING THE IN-MEMORY AGGREGATES
So now that you have generated a set of in-
memory aggregate recommendations and
implemented them for your repository, you
can test the impact on your dashboards and
analyses. Using your Web browser, log in to
the Oracle Business Intelligence Web page
again, navigate to the Overview dashboard,
and try drilling into the History Overview
analysis. You should now notice a much
shorter response time as you drill into the
hierarchies in your data. T
Mark Rittman is
an Oracle ACE Director
and cofounder and
technical director of
Rittman Mead. He
writes for the Rittman
Mead blog, at rittmanmead.com/blog.
READ more about
Oracle Exalytics In-Memory Machine
READ more Rittman
When you provide a hot meal to a disaster
victim, or give blood to someone you will
never meet, train in first aid, or help a
member of our military, you join the
American Red Cross.
Your support makes the difference.
Because of you, the Red Cross can
respond to nearly 200 neighborhood
emergencies every day.
Click, text or call to join today!
1-800-RED CROSS | redcross.org
Text REDCROSS to 90999 to give $10
Text REDCROSS to 90999 to make a $10 donation to the Red Cross. Charges will
appear on your wireless bill, or be deducted from your prepaid balance. Msg & Data
rates may apply. Reply STOP to 90999 to STOP. Reply HELP to 90999