This content has been marked as final. Show 4 replies
Is that something like ROW_WID=0?1 person found this helpful
In this case you no need to worry, these are required to join with fact table with all possible scenarios.
If something else let me/us know
if helps pls mark as correct/helpful
Yes I Check It In Database Level It Will Showing The empty Data.But I useing this is Column Report Level Showing Empty data related Factcolumn showing data.Then How to over come this..
I'm not clear what you say!.
If there is a record in dimension table with row_wid=0 and in the fact for the same column you might have value as 0
dim table value = fact table column value are matching
so you see a empty record.
Try to load data in required tables
Hope this helps
You apply filter condition on dimension Column and add all values to filter.
If helps pls mark as correct