Column not available in breakdown

[sriihs]

Hi PA experts,

I want to create a breakdown by the Display Name on   one of the asset tables. But I cannot see that column when I try to create the breakdown.

If I create a report then it works because i use group by " display name". How can I achieve this with PA? Any suggestions please?

Thanks,

Sowmya

[Arnoud Kooi]

In the breakdown source, select sys_id as field of the table you want to create a breakdown on.

Once you use it, it will display the value of the field that is set as the display column in your dictionary.

[sriihs]

Hi Arnoud,

I tried that- at the breakdown source I selected the sys_id from the cmdb_sam_sw_usage and for breakdown mapping i selected the display name.

But it does not work, the scores are not collected for that breakdown.

Any idea on what I might be doing wrong?

[Arnoud Kooi · Accepted solution]

I have checked that table, the field you want to breakdown on is a string field.

Try utilizing vincentloffeld solution in this thread: Re: How can I create a breakdown by task type on the Time Card table?

I dont know that data, but if I look at the table, another option might be to create the breakdown source on table cmdb_sam_sw_discovery_model, and after that create a breakdown and breakdown mapping to the cmdb_sam_sw_usage table.

This would create a automated breakdown on discovery model, not display name.

[sriihs]

Hello Arnoud,

Yep it works with the manual breakdown solution as provided by Vincent.

Thanks a bunch for your help, appreciate your quick response!

Thanks,

Sowmya