7. Click Deploy and Close. The application and cube are listed on the Applications home page. 8. (Optional) To view the cube outline, expand the application row to show the cube row, then click Outline . See Viewing Outlines . Also see Creating a Cube from Tabular Data in Cube Designer . Connecting to a Cube in Smart View In Smart View, you can create a private connection using the quick connection method if you know the URL. The private connection URL is a concatenation of the cloud service instance URL that you use to log into Oracle Analytics Cloud - Essbase and the string /essbase/smartview appended to it. For example, essbase/smartview . 1. From the Smart View ribbon, click Panel. 2. From the Smart View panel, click Home and then select Private Connections. 3. In the text box, enter the URL with the /essbase/smartview string appended to it, for example, . 4. Click the connect arrow . 5. On the Login dialog box, enter your Oracle Analytics Cloud - Essbase user name and password, then click Sign In. Chapter 4 Connecting to a Cube in Smart View 4-5
5 Creating and Managing Cube Outlines An outline defines the structure of the cube through dimensions, members, and attributes. The outline structure, along with consolidation operators and formulas, determines how data is stored and calculated. • About Cube Outlines • Viewing and Editing Outline Properties • Adding Dimensions and Members to Outlines • Viewing Outlines • About Duplicate Member Names • Enabling Duplicate Member Names • Editing Member Properties • Setting Dimension and Member Properties • Naming Generations and Levels • Setting Advanced Cube Properties • Unlocking Objects • Removing User Data Locks • About Filters • Working with Attributes • Managing Outlines About Cube Outlines Dimensions and members represent data hierarchies. In an outline, each dimension consists of one or more members. The members, in turn, may have child members. This hierarchy determines the drill-path and, with unary operators, a child member's consolidation to its ancestry. Viewing and Editing Outline Properties 1. On the Applications home page, expand the application to show the cube row for the outline that you want to modify, then click Settings . 2. Select the Properties tab. 3. Select Outline . 4. Many of the entries are read-only. However, you can select the following: • Date format . 5-1
• Attribute Settings Prefix/Suffix Format Value . • Boolean, Date and Numeric – True Member Name – False Member Name – Date Member Names – Numeric Ranges Represent See Building Attribute Dimensions and Associating Attributes in Designing and Maintaining Essbase Cubes • Calculation Dimension Names – Name – Sum Member – Count Member – Minimum Member – Maximum Member – Average Member See Naming Conventions for Attribute Calculations Dimension Member Names and Understanding the Attribute Calculations Dimension in Designing and Maintaining Essbase Cubes .
You've reached the end of your free preview.
Want to read all 197 pages?
- One '16
- Oracle Corporation