Should I use Different Dimension for this ? -
05-18-2004
, 06:52 AM
Hi All,
I have requirement to display OLAP data in this order :
By SalesmanSupervisor, By Salesman
By SalesmanSupervisor, By Salesman, By Customer
By SalesmanSupervisor, By Customer
By Salesman, By Customer
To get above variants of analysis how many dimension should I have ?
Is it necessary to have Two dimension for Salesman hierarchy ??
Dimension - 1 : SalesmanSupervisor, Salesman
Dimension - 2 : Salesman
OR
Do I only need just one Dimension : SalesmanSupervisor, Salesman ?
Thanks for your help,
Krist |