Forum Discussion
Redundant, mostly empty rows upon Matrix drilldown
I have set up a simple matrix to track bond values as their prices change. The fact table includes the bond purchase quantity and original price, along with the account holding the asset and the pur...
Hi Anonymous
Firstly, let me confirm with you as follows:
What i get from your statement:
1. you have two tables: fact table, dimension table,
their relationship is fact table( many) to dimension table( one) based on column [symbol].
2. you create a matrix, add columns [symbol], [account], [purchase date] to the "Row" of the matrix,
add [Quantity],[Current price],,ect in the "Value" of the matrix.
3. finally, your matrix show many blank rows when drilling down to "Account" or "Purchase date".
If there is any wrong, please correct me.
In addition, please show some screenshots, or give your expected results.
Best Regards
Maggie