How to achieve pivoting of the resultset from an Analytic or calculation view?

[former_member192417]

Hi Experts

Any comment or suggestion on how to achieve pivoting of the resultset from an Analytic or calculation view?

Thanks

Debraj

[ShyamPindiproli]

Hello Debraj,

Use the SAP HANA MDX Provider to connect to Excel and view the analytic views with hierarchies (Leveled or Recursive/Parent Child)

Check this out: Connecting to SAP HANA with Microsoft Excel 2007 PivotTables and ODBO

Regards,

Shyam

[former_member192417]

Thanks Subrahmanya

But my requirement is just to transform rows into columns while selecting data from HANA tables within HANA studio.

I checked that the PIVOT expression doesnt work in HANA as it would in SQL sever.

Is there any such expression or functinality avaialable within AN or CALC view?

Regards

Debraj

[former_member184768]

Hi Debraj,

There is no built-in function as such for PIVOT expression, but you can model the views using Calculated Columns i.e. Restricted columns or Calculated Columns using functions like IF construct.

Alternative is also to use a SELECT statement using CASE construct like mentioned here.

Regards,

Ravi