cancel
Showing results for 
Search instead for 
Did you mean: 

Office Analysis- Cross tab only ?

former_member297636
Participant
0 Kudos

Hello Experts,

Can we only create Cross tab in Office Analysis or Horizontal and vertical tables can also be created through it ?

Thanks

GD

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Gaurav,

you can select if the table is vertical or horizontal by placing the characteristics in the rows or columns area of the design panel.

Best regards,

Victor

former_member297636
Participant
0 Kudos

Hi Victor,

Thanks for your reply.

That sounds easy! However, Analysis would require at least 1 measure to be placed under ROW space, which makes it a cross tab. I'm not completely sure if we can place key figures/measures with free characterstics.

Each time i drag off all the measures from ROW space in the design panel it brings back all the measures there is in the BEx query.

Thanks

GD

bharathsap
Employee
Employee
0 Kudos

Hi Gaurav,

It is mandatory to have atleast one measure added to either rows or colums of a crosstab in Design Studio.

AO considers measures as a mandatory structure and all measures are grouped in the same structure.

When you try to remove all dimensions one by one, then removing the last measure will result in select all values state. So, all measures will be included in the crosstab. This is the expected behavior.

Regards,

Bharath

Answers (0)