This content has been marked as final. Show 2 replies
1) In DWH we go with surrogate keys and in rpd physical layer based on join definition foreign keys are defined.
I dont think these are equalent to Relational db keys
2) I might not understand it completely, if you want to go with filter kind then you might go with report prompts.
Since pivot table required a numeric column in measures you have to place any column irrespective of whether you need it or not.
For 2 column report Pivot table may not good view to use
If helps mark