New hierarchy node not available in Query Designer

[former_member320011]

Hi everybody,

I have some problem in query designer.

HR functional created some new node org unit in our current active hierarchy, I extracted to get this information.

After finished, I check under 0ORGUNIT hierarchy in RSA1, new node added in current hierarchy.

I want to use this new node in my query as restriction value of 0ORGUNIT.
Somehow this new node doesn't appear, so I can't select this new node.

Is there something missed?

Fyi, I already select the correct Active Hierarchy Display in my query designer.

Thanks beforehand.

Regards,

Herry

[cornelia_lezoch]

Hi Herry,

probably your info object is set to show only booked values.

Change it to show master data values.

regards

Cornelia

[swati_gawade]

Hi Herry,

If your varible is hierarchy node variable then check if any hierarchy is assigned to it. you can check this in your query definition. check if you are able to see any hierarchy name next to the variable restriction on  0ORGUNIT.

Hope this helps.

-swati.

[Former Member]

Hi Herry,

If the changerun has been done, please try to check if  the newly added node is now in the hierarchy K table. If not, you will have to reacivate the hierarchy after doing some dummy change. This can be some of the inconsistencies.

Regard,
Cecilia

[KodandaPani_KV]

Hi.

if you crated the master data for attr,text,hier for the 0ORGUNIT you need to check the bex query designer .

select the 0ORGUNIT check the hier tab option. select the active hier.

active the 0ORGUNIT attr/hier change run.

-Phani.

[RamanKorrapati]

Hi,

After your hierarchy load, have you ran attribute change run? lets try to run attribute change run and see .

Thanks