Hi All,

I have a requirement that would use dimensions. I am completely new to this concept. If anyone can provide any inputs (code snippet would be superb) how to go about creating a simple dimension and then how to use it to draw reports, it will be a great help.

I am going through the manuals, but a working code, that I could just deploy and run would make the learning process much faster.

Thanks in advance for the help

This message has been edited. Last edited by: Kerry,

It all depends a bit on what your definition of a dimension is.
For some a dimension is a complete concept, for others it is just a simple BY statement.
So please elaborate a bit on exactly what your requirement is. By understanding precisely what you need, I think we can help you better.

Hi GamP,

I am not referring to BY clause. Let us take the example of LOCATION as a dimension and PERIOD as another dimension.

I can have an heirarchy like AREA -> REGION -> COUNTRY -> STATE -> CITY for the LOCATION dimension, and YEAR -> QUARTER -> MONTH as PERIOD dimension.

I want to know how I should setup the dimension (starting from their creation) so that I get optimal performance.

Let us take example of SFO (SanFrancisco). Let us say, we are trying to get the number of people joining the IBI Forum on a monthly basis across the Globe.

Now if there are 2 people who joined from SFO in October, and 3 in November, then when the user queries in the report, he should see the following:

Count for SFO for October: 2
Count for SFO for November: 3
Count for SFO in Quarter 4: 5
Count for California for October: 2
Count for California for Quarter 4: 5

So essentially, depending on what the user is querying for, he will get the values accordingly (computed of course).

I need tips on how to go about creating the dimension, how to organize my file for optimal performance, and if possible a report that is drawn using these dimensions (using computation logic)

Please let me know if you want me to explain further. Thanks for the help!!!

Do you have Developer Studio installed on your PC?
Because DevStudio has a very nice called the Dimenson Builder.
This tool makes it quite easy building your own dimensions using a visual method to do so.
I'd check it out, if I were you...