sreya_1234

 Profile Answers by sreya_1234 Questions by sreya_1234

• Nov 12th, 2007

 

Accessing LOVs in the report:-
Go to Tools -> Universes -> select a universe and click on "List of Values" -> select an object from the table -> display - here you will get list of values for the object which ypu have selected.

RishiBO

 Profile Answers by RishiBO 

• Jan 20th, 2010

 

Adding to the above Point:
Setting Hierarchy in Universe

You can use the Hierarchies editor to view, create and rearrange existing object hierarchies in your universe.

Designer provides a set of default hierarchies for multidimensional analysis. These are the classes and the objects arranged in the order that they appear in the Universe pane. When you create objects, you should organize them hierarchically, to ensure that default hierarchies have a sense to users. You often need to create customized hierarchies that include objects from different classes. In these cases you need to create a new hierarchy.

To view hierarchies in the universe

1. Select Tools > Hierarchies.
   Or
   Click the Hierarchies button.
   The Hierarchies editor appears. Designer represents hierarchies with a folder symbol, and dimensions with a cube symbol.
   The left pane lists all the classes that contain dimension objects in the active universe. The right pane shows all the customized hierarchies that you create.

2. Click a hierarchy node (the + sign) to see the dimensions organized hierarchically.

3. Click Cancel.

To set up new hierarchies

You create a new hierarchy by creating a new folder in the Custom Hierarchies pane, then adding the appropriate dimensions in a hierarchical order.
You can delete a hierarchy or a dimension in a hierarchy by selecting the hierarchy or dimension and clicking the Remove button.

1. From the Hierarchies editor, click the New button.
   Or
   From the Hierarchies editor, select an object in the left pane and drag it over to the right pane.
   A folder representing the hierarchy appears in the right pane.

2. Type a name for the hierarchy

3. Press RETURN to apply the name.

4. Select the new hierarchy.
   The hierarchy is highlighted.

5. Expand a default hierarchy node in the left pane.
   This is the hierarchy that contains dimensions that you want to add to the new custom hierarchy.

6. Click a dimension. To select a series of dimensions, hold down CTRL and click each dimension.
   One or more dimensions are highlighted.

7. Click the Add button.
   One or more dimensions appear in the right pane, under the selected hierarchy.
   The Unused objects only check box is a useful way to view only the dimension objects that you have not yet selected for inclusion in a hierarchy.

To rearrange the order of dimensions and hierarchies

You can rearrange the order in which the dimension objects appear within a hierarchy. To move an object, click it, and then click the Move Up or Move Down button. You can also re-arrange the order of hierarchies in the same way.
You can also move a dimension object or a hierarchy by drag and drop.