Query Long run issue on Hierarchy node

[Former Member]

Dear Guru's,

Hi All,

i am executing Query with selections on calday and hierarchy node.

With selection calday as 13.10.2014 and hierarchy node as X getting executed with around 2000 records  just within a minute.

But while trying to executed with selection calday as 13.10.2014 and hierarchy node as Y getting executed 1 hr 2mins for just 168 records.

Please provide an solution on what could be the reason for this long run for particular hierarchy node and let me know if more details required.

Note:Query is based on Infoset (its making joins with infoobject Master data )

Regards,

Giridharan Rajan

[Former Member]

Hi Giridharan,

you check whether the hierarchy SIDs are updated properly, structure, to date are all fine.

check the difference between X and Y hierarchy.

Regards,

Prakasha A