Analysis Office table design API - All members

[mhajek]

Hi everyone,

I am struggling again with not very well documented AO feature. I am trying a very simple thing - to change style of all dimension members of one dimension by VBA. Understand, not the heading, but just all members.

The problem is, that when I write the VBA like this:

Result = Application.Run("SAPSetFormat", "TEST", "DS_1", "SAPExceptionLevel4", "DIMENSION", "CROWID")

Only the heading gets modified. No possibility to choose "all dimension members" as it states in the drop down when you do it using UI.

When I try something like this:

Result = Application.Run("SAPSetFormat", "TEST", "DS_1", "SAPExceptionLevel4", "MEMBER", "CROWID")

It just does nothing as it expects members to be stated explicitly.

When I list all the format rules by using SAPListOfDesignRules, rules changing Heading design and All members design look absolutely the SAME in the resulting object.

What I am missing?

Thank you,

Martin

[fmorgenstern]

Hi,

Your Attribute-Value, which you want the design changing, is missing. Please try like this:

Example:

lResult = Application.Run("SAPSetFormat", "Membertest", "DS_1", "SAPExceptionLevel1", "MEMBER", "CROWID;yourValue")