Convert BOM T-SQL query to QlikView script.

[RobinhoQlik]

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?

[Brett_Bleess]

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

[RobinhoQlik]

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

[Brett_Bleess]

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

[wgonzalez]

Hi Robinho,

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

Thanks,

Wilfredo