cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X

Multi Level Where Used Report

mbabu
6-Contributor

Multi Level Where Used Report

Hello Experts , Is there any way to generate " Multi Level Where Used Report" in windchill similar to "single Level Where Used Report" ?

10 REPLIES 10
avillanueva
22-Sapphire I
(To:mbabu)

Sorry if I am lost. The reports on the structure page are not where used reports. They go down not up. The Where Used tab and table are multilevel. Short answer is yes if you mean column differences. The only real difference between these reports would be how many levels you recurs up the structure.

mbabu
6-Contributor
(To:avillanueva)

sorry for the confusion, i was referring below report. 

mbabu_3-1681194457397.png

 

mbabu_2-1681193940732.png

 

HelesicPetr
22-Sapphire I
(To:mbabu)

Hello @mbabu,

No, there is not possible to create multilevel report in query builder (Report Management). 

If you need multilevel report you need to crate own customization to achieve your needs. 

 

I mentioned how to add attributes to a Where used table, but it is really not possible to add a usage attributes this way as a quantity. 

 

There is another way how to customize the table but you need to know how to  create classes with code. 

From my view I would create own function that shows own where used table. 

 

PetrH

 

mbabu
6-Contributor
(To:HelesicPetr)

Hello Petr, Thanks a lot for the detailed explanation. For better understanding, how to create own function that shows own where used table [ for retrieving BOM qty]? do we need to execute in programing level? do you have any reference for this? 

HelesicPetr
22-Sapphire I
(To:mbabu)

Hi @mbabu 

Yes,

 

First you should learn how to create customization

 

A catalog overview can help to understand what you can customize in general.

it is located in your Windchill installation

Check this page in your Windchill 

https://server.comp.com/Windchill/app/#netmarkets/jsp/componentCatalog/treeComponent.jsp

 

Also check help center where you can learn how to implement customization 

Link to HelpCenter

 

Where to find custom tool

Link to HelpCenter

 

customization guide where are many examples how to customize Windchill

https://www.ptc.com/en/support/article/CS60345

 

PetrH

 

mbabu
6-Contributor
(To:HelesicPetr)

Thank you so much Petr for the guidance!

d_graham
17-Peridot
(To:mbabu)

@mbabu 

I’m going to echo what @HelesicPetr  has already stated with a little more explanation.

 

A single level report does not require adding (or  combining) results from different levels. A multi-level report does. And to add or combine from different levels requires looping, as you need to go through all levels to make sure you have ent missed any value that needs to be added or combined. This is not something Query Builder can do OOTB.

 

You can however, as Petr mentioned, write custom code to do whatever.


If something like this is required I use “Java Method” functionality in Query Builder. Once you’re in the realm of “Java Method” you can do pretty much anything.

Needless to say, you need to know Java and you need to understand how Windchill works under the hood.

HelesicPetr
22-Sapphire I
(To:mbabu)

Hi @mbabu 

The report does not exists OOTB.

 

As @avillanueva mentioned. 

You can go to the Where used tab on WTpart or Related Objects on CAD model

You can export the table to several file types,

Then you can work with the output and get all the highest assemblies.

 

HelesicPetr_0-1680784184381.png

 

If you need to add some attributes to the table check following thread

https://community.ptc.com/t5/Windchill/How-to-Customize-where-used-panel-s/m-p/786728

 

PetrH

mbabu
6-Contributor
(To:HelesicPetr)

Thank you PetrH,  the shortcoming of about option is it wont capture the "qty " of item, Unlike Single level BOM report . that's why I was checking do we have any way to fetch multilevel BOM with QTY similar to single level BOM report . It was there in Windchill in past , but it got removed [ article -CS83061] . Thank you again for the helping hands!

mbabu
6-Contributor
(To:mbabu)

mbabu_1-1681193806936.png

 

is there any way to get "QTY" in multilevel BOM similar to single level BOM report?

Top Tags