Show Empties - In Memory
Hello,
I have built a new in-memory Pyramid model, and I have a table with a list of Pack Benches (numbered 1-10).
When I don't include a measure, it shows all elements of the dimension (see attached image 1).
However, when I add a measure, it only shows the elements with data against them, even if I select 'Show Empties' (see attached image 2).
I normally use tabular sources and this works - is there something I am missing on in-memory sources?
Thanks,
Alec
2 replies
-
Hi Alec Mason ,
The show empties options returns all the combinations that exist in the result set even if they are empty (null values).
In an MDX data source (like tabular) all the members from all the dimensions are always linked to each other and to the measures (putting same-dimension, different-attributes, combinations aside).
Because of that, when you ask to see empties, members with no data in the fact table will be retrieved.
In SQL (including the in-memory data source), when a join is preformed between 2 tables, some rows might be removed completely. In this case, PBNumber joined to Total only has these 3 items matching.If you will change, in the modeling tool, to left/right join (depending on how you linked the tables) instead of inner join, you could get the rest of the members back (because of the way SQL joins work).
Imbar
