B: Click Refresh All from the Oracle BI menu in PowerPoint to refresh all the refreshable objects in the presentation.
C: Right-click Table and select Insert as List from the shortcut menu. The Edit Prompts and Levels dialog box appears. Accept the default options and click Insert.

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/biee/r1013/bi_addin/images/t20 105a.gif
Reference: Using Oracle Business Intelligence Office Add-Ins with Oracle Business Intelligence Enterprise Edition (10.1.3.4) on Windows

Explanation
You have three sort of fragmentation:
Fact-based / Dimension-based fragmentation
Content-based / Value-based fragmentation
Level-based fragmentation / aggregate navigation
You can combine the techniques above to construct powerful design that are known as Complex partitioning / fragmentation. When you fragment a dimension, you are automatically in a complex fragmentation.

The Catalog Manager workspace enables you to view and work with catalog objects. It displays the following folders for an open catalog:
The shared folder- Contains content that is shared among catalog users. This includes the preconfigured dashboards and analyses that are distributed with prebuilt applications, and other objects such as shared filters.
The system folder - Contains administrative elements of Presentation Services. Some of these elements are distributed with the product, and others are configured by you as the administrator, such as privileges. Avoid modifying any files in this folder. Presentation Services uses these files internally and modifying them might cause unexpected results.
The users folder - Contains content that catalog users with the appropriate permissions have saved to their personal folders, such as individual analyses.

Explanation/Reference:
Before you can run Oracle Business Intelligence 11g Installer, you must first create required Oracle Business Intelligence schemas in an unhardened database. You use a tool called the Repository Creation Utility (RCU) to create these schemas with the appropriate permissions and data.
Reference: Installation Guide for Oracle Business Intelligence, Additional Oracle Business Intelligence 11g Installer Requirements

Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.
See figure below.

http://123obi.com/wp-content/uploads/2011/04/25-04-2011-10-26-45.png