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