Skip to Content
Former Member
Jan 08, 2009 at 06:47 AM

hierarchy display in the query


Hi All,

I am new to BI 7.0 and working on hierarchy loading in queries.

Following is my hierarchy structure region->country->city

Uder region i have ASIA, Europe

Under ASIA -> india, china

Under City, ASIA->india->Blore, ASIA->india->chennai, e.t.c

Following are the steps i followed:

1. Created two characteristics info object "zRegion, zCountry" with master datas.

Created one characteristics info object "zCity" with master data and hierarchy and with out time dependent.

2. Loading the master data to "zRegion, zCountry, zCity".

3. Rt. click on the city info object and create hierarchy. So i created hierarchy structure with 3 levels.

Region-> Country-> City

Problem: I am quering on Zcity, i am able to see the zcity values, when i try to dril hierarchy on region or country levels, i am seeing ' # ' symbol but not the master data i loaded.

I did see that master data loaded in the characteristic info object "zRegion, zCountry".

Can any body please help out to solve this issue?