Matrix Missing Data

Question

Hi,&nbsp;I am building a matrix tied to data in an&nbsp;SQL database.&nbsp; I seem to be missing data in the report but getting it in the query editor by connecting through Direct Query.In the below image, when basic filtering is used- H&amp;P 420 shows as 19 records instead displays only 13 rows in it.Any Help would be Great!&nbsp;

stachu · Answer

my guess is only 13&nbsp;out of 19 rows have data in the fact table - can you check?

bilakshmi · Answer

Thanks for your reply Stachu...Below is the screenshot of the query editor displaying 19 records. All i want is all these in the report.&nbsp;&nbsp;

Forum Discussion

Matrix Missing Data

2 Replies

Related content

missing data

missing data

Generating Missing Data

Inferring Missing Columns and Imputing Missing Data

Data source credentials missing