how to create cross tab reports

Hi
I know this is one of the basic questions.But i never worked on full client before( i haVE webi EXPERIENCE). Can anybody tell me how to create crosstab reports?I just want to know how to start creating cross tab reports. This is my requirement:

                              Month1    month2  ......................month 12

Code Prod name

For each month, i need to show number of products sold in that particular month.

thanks in advance.


BOisBest :india: (BOB member since 2004-04-05)

drag your month column and drop on upper right hand side of your report table


matt_man2004 (BOB member since 2004-06-12)

Do some reading on the “Slice and Dice Panel”. It will be easier to understand.


Steve Krandel :us: (BOB member since 2002-06-25)

Thanks Matt and Steve. Well, understood how to create cross tab report. Now, I have to show something like this in report:


                        Month1........................Month2
Code  Name          X..............................X
                           2  ..............................2
                           |
                           |

once i show data for metric X under all the 12 months, i need to show the data for metric Y again for 12 months and so on. And all the new metrics X, Y, … are displayed on new pages. Is it possible to do through slice and dice panel? If not, what is the other way to achieve this? Any clues?


BOisBest :india: (BOB member since 2004-04-05)

How many Metrics(measures) you want to display? You can do it in two ways,

  • If you have few metrics you can dispaly them in a single crosstab like below,

	    Month1	Month2		

Code1	X	Y	X	Y

  • If you have lots of measures then you can group the related measures and dispaly them in different crosstabs…

Regards,
Mohan


cpmohanraj :australia: (BOB member since 2002-09-23)

Mohan,
I have 6 metrics and i want them to appear below months, but for all 12 months i want to display X first. After X data is over, i want to display Y data and so on.


BOisBest :india: (BOB member since 2004-04-05)

Brief sketch:
Create two crosstabs, one for measure x, another for measure y. Position the crosstab displaying y relative (format table, tab appearance) to the crosstab displaying measure x.


Andreas :de: (BOB member since 2002-06-20)

So if i have 6 measures(metrics), do i need to create 6 cross tabs and then format the table, tab appearance?


BOisBest :india: (BOB member since 2004-04-05)

Though the obvious answer is YES I think it is worth giving a try yourself :wink:


mkumar (BOB member since 2002-08-26)

I have one more question: What is the best practice for creating such reports, i mean where i have to show data in 6 crosstabs.

Practice 1 : Get all the measures and dimensions you need to build the reports in one query all at a time and then insert crosstabs based on this data.

Practise 2 : Get only the measures and dimensions you need to build one crosstab at a time and select ‘Build new query on the universe currently in use’ to get required dimensions from time to time.

In my report, i have only 3 dimensions which are same for all the crosstabs. The only thing that changes is the measure.
Please let me know,which practise should i approach. Again, i have to sort these records according to sales values. So i need to display same records(i meandimensions) for different measures.
Thanks


BOisBest :india: (BOB member since 2004-04-05)

In your scenario I vote for creating as few data providers as possible.


Andreas :de: (BOB member since 2002-06-20)

So Andreas, you mean to say, there would be only one data provider (query) but 6 cross tabs in my report, right?


BOisBest :india: (BOB member since 2004-04-05)

Yes. A report is (more or less) just a projection of the microcube(s) of one or more data providers.


Andreas :de: (BOB member since 2002-06-20)