I have a hierarchical DME tree like below.
---item (level 2)
----Sub-items. (level 3)
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.