Dimension Member Source

Can someone provide any  documentation and use case for different Source Type in dimension properties section?