Hello,

I have the following problems.

1)

There are two tables containing information about relationship:

Table geo_dict contains:
item_id
item_code -> used by fact table
item_name

Table geo_tree contains:
rec_id,
parent_id -> which points rec_id in parent-child relationship
item_id -> which relates to geo_dict.item_id


I'd like to create one dimension with parent-child relationship but the
item_name should be presented in hierarchy not parent_id.

I know that it can be realized with named query in data view, but this
dimension must be stored in ROLAP model so this solution won't work.


Do you have any suggestions?

Piotr J

Can you create a VIEW into the relational database?

Marco Russo
http://www.sqlbi.eu
http://www.sqljunkies.com/weblog/sqlbi

Piotr J ha scritto: