| a design problem(dimensional model) [message #93374] |
Fri, 01 October 2004 09:10 |
me
Messages: 66
Registered: August 2000
|
Member |
|
|
I am making a decision support system(benefiting the students)
One of the dimensions I have taken is of
Student whose attributes are discipline,student id, batch ,student status
and the fact table which contains registered seats in a particular discipline.
I need to find out which is the most popular discpline according to batch.
As Discipline and batch are both the attributes of a student ,how can i find this out(as onlyone can be chosen as the grain level).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
