For Example, If I have compounded 0Material to 0SourceSystem, then
1. How the SID's are generated?. One SID table for 0material and 0source combination or a separate SIDs for each of 0Material and 0SourceSystem.
2. How the compounding effects cube modeling? If I include 0Material in one dimension, then 0SourceSystem is automatically included, or it must be included, or it may or may not be included.
3. How the compounding effects in query design and in BEx.