- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2024 01:53 AM
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:
Reference:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2024 02:43 AM
Hi @Stimson ,
Sure:
1. Create the breakdown source:
2. Create automated breakdown
3. Create breakdown mapping in the automated breakdowns related list.
(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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2024 05:19 AM
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:
This will show that, the field reference "cmdb_model"
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2024 02:06 AM - edited 01-16-2024 02:12 AM
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.
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2024 02:36 AM
Since I'm new to platform analytics workspace can you help me create it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2024 02:43 AM
Hi @Stimson ,
Sure:
1. Create the breakdown source:
2. Create automated breakdown
3. Create breakdown mapping in the automated breakdowns related list.
(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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2024 04:38 AM
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