BOM is missing for one material in bex querey

[former_member183113]

Hi Folks,

we have a query and it is not showing BOM for one material. But i can see data in multiprovider. multiprovider having two cubes only

And i have seen query definitions....that is not a complex query also. only having some restrictions but they are not excluding missing BOM.

Query dont hav any formulas also. Just hav variable for selections only.  In RSRT also i could nt see BOM data for that particular material only.

others i can see....

Any suggestions??

Regards,

Raki

[RamanKorrapati · Accepted solution]

Hi,

Assuming as all connected targets have reporting symbol at manage-->request tab.

You can run attribute change run for 0material info object.

Later you can regenarate your query from RSRT and check it.

Thanks

[former_member183113 · Accepted solution]

small doubt Ram....in production can we do it?? i mean attribute change run for 0material??

[RamanKorrapati · Accepted solution]

Attribute change run nothing will cause in prod if your related transactions loads are not in process.

[former_member183113 · Accepted solution]

But i an see data in multiprovide..y we need to run attribute change  run.....

[RamanKorrapati · Accepted solution]

Without change run we can see the data at target level. But on reporting level we can't see.

thats why i suggested to run ACR.

[former_member183113 · Accepted solution]

hi....issue solved. there is a restriction on 0AEDAT (bom CAHNGED ON ). According to that this perticualr Material is not popualting with BOms........