Skip to Content
0
May 29, 2015 at 04:52 AM

Count total no. of records of hierarchical DME tree.

264 Views

Hi,

I have a hierarchical DME tree like below.

header(level 1)

---item (level 2)

----Sub-items. (level 3)

header_batch(level 1)

I want to count total number of records in the tree (count of all nodes). I used ref node id at all node(except header) and used aggregation of all ref ids at header_batch node.

I am able to get total records for item, sub items and header_batch. Please tell me how to count record for header.

if I enter ref ID at header then I get a syntax error, agregation can not be used for ref id of header as header and header batch at same level.

Please help to resolve this problem. Please note that I hav through all thread of internet for this but did not find exact solution for this problem.

Thanks in advance.

Regards,

Ratnesh