am trying to write a sql for the dimension attribute but facing some issues. i am not able to get when to use what. Like, there are Key columns , Name Column and value column. Then there is Usage and Order By. I am not able to find anything useful in links. Can some nody help me in providing me some links which will help in understand how the cube processes the attributes. The things i want to coincentrate is that i want to know what effects does setting the above property do to the way processing is done.