cancel
Showing results for 
Search instead for 
Did you mean: 

how to see all attributes of attribute view in EXCEL

rajarshi_muhuri
Active Participant
0 Kudos


Hi

When I am using SAP HANA MDX Provider in EXCEL , I can only see the attributes of a attribute view if they are part of a Hierarchy.

I am creating a level hierarchy for each attribute to get around this .

Is there a setting to enable that will allow all the attributes to show up in excel pivot ?

rishi

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Rajarshi,

not sure why you would want to see all the attributes as it will clutter your pivot grid, but the odc script for SAPNewDBMDXProvider seems to be working fine, except that you would be sending a clear text password which may not be acceptable in certain environments. also, i think SAP would prefer that you were using calc view rather than attribute view in the latest support packs.

have fun,

gm