PA Breakdown showing unmatched records

shawshipra
Tera Expert

Hi All,

 

I have created PA reports on DBview and breakdown on sys_choice with the DBview but breakdown shows unmatched records. What could be the reason?

 

Regards,

Shipra Shaw

6 REPLIES 6

andersbogsjo
Tera Guru

Hi!

Do you have Additional filter on the Indicator that doesn't match the Breakdown source?

can you provide screenshots of your Breakdown Sorce, Breakdown, and Indicator?

Regards

Anders

Hi Anders,

PFB screenshots of breakdown source, breakdown, mapping and indicator.

 

find_real_file.png

find_real_file.png

 

 

find_real_file.png

find_real_file.png

The fact tables are database view could that be an issue?

 

Regards,

Shipra Shaw

Also, when i select breakdown on widget the dashboard shows no data to display.

 

find_real_file.png

Then you will have to do a Breakdown mapping to that database view

Regards 

Anders