Facts table is different on Indicator source and Breakdown source

[Shilpa44]

Hi,

The facts table is custom table in the Indicator source and the table has a field called Breakdown which is of choice type. It has same values as syslog_transaction table 'Type ' feilds and it was added manually to the Breakdown field in the custom table so sys id's are different .

In the breakdown source , the table is syslog_transaction table. Now, when i run the job i get the data from indicator source but i dont see the scores for each breakdown. Can someone tell me how can we relate Indicator source and breakdown source when the facts table is different.

Thanks,

Shilpa

[dharmesh rathod]

How was this issue solved?

[Adam Stout]

You can't breakdown on something in syslog_transaction.  Breakdown Sources should be the options in the table (often sys_choice or a reference table like sys_user_group).  You do not want to breakdown by a large fact table like syslog_transaction or incident.  I would look at some out of the box examples or through the training materials to ensure your setup is correct.