Application Engine >> Dimension Queries >> Select leaves of a Parent Element

Venkat Varra

Hi,

Can you please help with syntax, how to select all base elements of a given parent element using dimension queries?

I would like to fetch all base jobs of given parent job code from Jobs dimension where job status is 1 and order by attribute. But below query return all base elements of dimension.

OLAPelementList JobsList = on olapConnection select leaves from dimensionName where @(att_obj_status)==1 order by att_obj_order asc;

Hence, currently i am using

OLAPelementList JobsList = OLAPGetChildElementList(olapConnection , dimensionName, ParentElement, true);

Please help, if dimension query can return values of given parent element.

Thanks & Regards

Venkat.

Process Intelligence Pursuing operational perfection, one step at .mp4

John Robson

Venkat

What you are trying to do is tricky and you can't do it with just a dimension query. Here is what I would try:
Create an OLAPElementList using a dimension query with the filter and order as above.
Create a second OLAPElementList using OLAPGetChildElementList as above.

Loop through the first OLAPElementList and for each element use the OLAPElementListContainsElement test to see if the element is also in the second list. If it is either add the element to a third OLAPElementList or use OLAPRemoveElementList to remove the element from the first list if it's not also in the second. Remove may or not work when you are iterating through the list but adding to a third list would be safe.

Assuming you add to the third list it has the correct order.

If this isn't performant - and you must test this with production volumes than come back to me and I will suggest a plan B.