on 08-03-2015 5:44 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.