cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BO Analysis for Excel & HANA - For Cubes Only ?

Former Member
0 Kudos

I have a lot of Calculation views in HANA that are 'Dimension' rather than 'Cube' variety.

I would like to display my dimension data in Excel.

However, when searching for HANA tables using Analysis For Excel, I am only able to see my cube views, and none of my dimension views.

Is this by design, or have I set something up wrong ?

If by design , why ?

How may I easily display my Dimension data in Excel ?

Hope some one can point me in the right direction,

Many Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

justin_molenaur2
Contributor
0 Kudos

Yes, only OLAP (cube) views will be read with AAO.

If you want to see the non-cube view, you must include at least one measure. This has been done before using a dummy "counter" in the aggregation node, but base it on something meaningful like the lowest grain of data.

Regards,

Justin