Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

New Breakdown source

Stimson
Tera Contributor

Hi Everyone, 

I'm trying to create a new breakdown source called parent product, I'm referring to a similar indicator source but cannot find out the element. 

Can someone help me find the element's name for the parent product in the choice [sys_choice] table?

New breakdown source:

Stimson_0-1705398754376.png


Reference:

Stimson_1-1705398781315.png

 

2 ACCEPTED SOLUTIONS

Hi @Stimson ,

 

Sure:

 

1. Create the breakdown source:

AndersBGS_0-1705401592533.png

2. Create automated breakdown

AndersBGS_1-1705401635189.png

3. Create breakdown mapping in the automated breakdowns related list.

AndersBGS_2-1705401742668.png

(Notice that "field" is parent.product)

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

Hi @Stimson ,

 

Sure,

 

What i knew from the start was what you stated initial "element's name for the parent product" and that you referred to the sn_customerservice_case table (due to the screenshot you send).

 

According to above, I went to the sn_customerservice_case in my PDI and looked at parent field which referred another case in the sn_customerservice_case. Based on this, I looked at the field configuration through the "form Design" as showed below:

 

AndersBGS_0-1705411044057.png

This will show that, the field reference "cmdb_model"

AndersBGS_1-1705411122269.png

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

6 REPLIES 6

AndersBGS
Tera Patron
Tera Patron

Hi @Stimson ,

 

As far as I can see from my PDI, the parent.produt is referring to cmdb_model table. 

Hence you should create your breakdown source for the table cmdb_product_model SysID, and the map the sn_customerservice_case table for parent.product. 

 

AndersBGS_0-1705399959345.png

 

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Stimson
Tera Contributor

Since I'm new to platform analytics workspace can you help me create it?

Hi @Stimson ,

 

Sure:

 

1. Create the breakdown source:

AndersBGS_0-1705401592533.png

2. Create automated breakdown

AndersBGS_1-1705401635189.png

3. Create breakdown mapping in the automated breakdowns related list.

AndersBGS_2-1705401742668.png

(Notice that "field" is parent.product)

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Stimson
Tera Contributor

Thanks, ♥ @AndersBGS, That was helpful. Can you please help me understand, how you concluded that the parent product was from the product model table?

This would help me in the future