topic Re: Convert BOM T-SQL query to QlikView script. in QlikView

Convert BOM T-SQL query to QlikView script.

RobinhoQlik — Sat, 16 Nov 2024 19:43:41 GMT

Hi,

I am trying to convert the attached T-SQL script to QlikView script, but it's not working. The T-SQL script is developed to generate a Build of Material (BOM) structure. The @ids is the variable which contains ID's from items so it gives the ID's for which a BOM structure should be calculated. The [dbo].[CCM_BOM] table consists of child and parent numbers:

CHILD_PARTNUMBER	PARENT_PARTNUMBER
123	789
222	789
589	123

So if I execute the T-SQL Script with the @ids = '789' I get following result: (level 0 because its top level)

Item	PARENT_PARTNUMBER	CHILD_PARTNUMBER	Lvl	PARTNUMBER_path
789	789	123	0	/789/123
789	789	222	0	/789/222

Can you help me converting the script to QlikView script?

Re: Convert BOM T-SQL query to QlikView script.

Brett_Bleess — Tue, 12 Nov 2019 19:09:41 GMT

Have a look at the following Design Blog post, believe that should help you with things:

https://community.qlik.com/t5/Qlik-Design-Blog/Bill-of-Materials/ba-p/1462792

Regards,
Brett

Re: Convert BOM T-SQL query to QlikView script.

RobinhoQlik — Wed, 13 Nov 2019 06:44:35 GMT

Hi Brett,

Thanks for the respond, I already looked at it but it will not fullfill my needs. We can have BoM's of more than 50 levels. And parts can be used in multiple BoM's. Levels are not clear, we only have parent child relation.

Regards,

Robbin

Re: Convert BOM T-SQL query to QlikView script.

Brett_Bleess — Wed, 13 Nov 2019 13:30:41 GMT

I would venture in that case you are likely going to have to start a discussion with your account manager and services to see if they can arrange for one of the consultants to review the use case etc. and see if they can come up with any ideas, I am doubtful Community is going to get you the response you want on this one, as it sounds like this is pretty entailed use case.

Regards,
Brett

Re: Convert BOM T-SQL query to QlikView script.

wgonzalez — Thu, 25 Aug 2022 21:39:59 GMT

Hi Robinho,

Did you find the script needed to explode the BOM? Can you share it?

Thanks,

Wilfredo