Cross Tab, use of Input and Output Context

building reports webintelligence
1

Hi,

I want to create a cross tab, with use of combination of Input and Output Context.

The data is as given below in Tabular Format.

Universe Name Table Name

Universe 1 Table 1
Universe 2 Table 1
Universe 1 Table 2
Universe 2 Table 2
Universe 1 Tab 3
Universe 2 Tab 4
Universe 1 Tab 5

The cross tab output with respect to the above data is expected to be like

                 Universe 1	Universe 2

Universe 1 4 2
Universe 2 2 3

Cross Tab Header and Column → Universe Name
Cross Tab Measure Variable ----> Count(Table Name)

Inputs are really required.

Thanks
Cross Tab.jpg

kiran.kotagiri (BOB member since 2006-05-15)