diddy (5) [Avatar] Offline
#1
Hi,

Are you sure parent='Manager Id' is current in the code below? [Copied from the parent child hierarchies section]

<Dimension name='Employee' table='employee' key='Employee Id'>
<Attributes>
<Attribute name='Supervisor Id' keyColumn='supervisor_id'/>
<Attribute name='Employee Id' keyColumn='employee_id' >
nameColumn='full_name' orderByColumn='employee_id'
parent='Manager Id' nullParentValue='0'/>
</Attributes>
<Hierarchies>
<Hierarchy name='Employees'>
<Level attribute='Employee Id'/>
</Hierarchy>
</Hierarchies>
</Dimension>

Thanks,
Diddy
julian.hyde (7) [Avatar] Offline
#2
Re: Parent-child hierarchies error?
You are correct. It should be 'Supervisor Id'. Here is the correct code:

<Dimension name='Employee' table='employee' key='Employee Id'>
<Attributes>
<Attribute name='Supervisor Id' keyColumn='supervisor_id'/>
<Attribute name='Employee Id' keyColumn='employee_id' >
nameColumn='full_name' orderByColumn='employee_id'
parent='Supervisor Id' nullParentValue='0'/>
</Attributes>
<Hierarchies>
<Hierarchy name='Employees'>
<Level attribute='Employee Id'/>
</Hierarchy>
</Hierarchies>
</Dimension>

I appreciate the correction. I have corrected the chapter. Please let me know if you spot any other typos.

Julian