How to define hirarchies

[Former Member]

Hi all,

I want my report to be displayed, based on customer groups. To be specific I want my report has group a in one column when I drill down it should display all the customers in the group with thier corresponding values.

If I am not wrong, we can do this at universe level using hirarchy editor. But how can I do it in the hirarchy editor?

Please give me some ideas, I am quite new to BO.

Regards

Ash.

[Former Member · Accepted solution]

Ash,

Check this link for creating time Dimension

http://it.toolbox.com/wiki/index.php/Create_a_Time_Dimension_/_Date_Table

[Former Member]

Hi Ash,

In the universe goto menu Tools --> Hierachies. Select Custom Hierarchies and Click on New and give it a name i.e Customer. Then drag in the objects from the list of the left in the order you want the hierachy to be... 1st - Customer Group and 2nd Customer. Save it and export the universe. Create your report...

Hope this helps

Jacques

[Former Member]

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.

To create a new hierarchy

1. From the Hierarchies editor, click the New button.

Or

From the Hierarchies editor, select a class 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.

Note: 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.

[Former Member]

Hi,

Thanks for your reply. It was really helpful.

My requirement is like I have to display the total revenue (dimension object) for the whole year and when I drill down from the total revenue of the whole year it should display the revenue for individual months. Is it possible to do this by creating a time dimension object? If so how can we create a time dimension manually?

Regards

Ash.

Edited by: Ash Pitt on Sep 17, 2008 1:46 AM