How to get "data cell properties" in vba

[former_member354722]

Anyone know how to access EPM's "data cell properties" values within VBA? For example, the ActiveCell is on a data cell that you want to know the dimensionality of within vba. So, cell A1 "data cell properties" = VERSION=Actual; TIME=2010.TOTAL, etc. I want to use this cell info within my vba macro.

FYI, "data cell properties" are accessed by right clicking on the data cell, then "EPM", "Properties".

EPM 10 SP19 Patch 1 .Net 4

Build 8936

[former_member186338 · Accepted solution]

Hi John,

As far as I know there is no API function to get "data cell properties". But in general you know the location of page, column and row axis and you can simply find the related dimension members with a simple VBA code. In some cases you can use functions:

GetDataTopLeftCell(woksheet,report)

GetDataBottomRightCell(woksheet,report)

To ensure that the cell is in the data area.

Vadim

[former_member354722 · Accepted solution]

Hi, Vadim. Thanks for the suggestion. Too bad there's no API as that is very useful info. I wanted to use it to automate detail reporting. Using the cell property I could open another report and pass various values to that report's context.

I know a little about EPMlink and quick links, but even those would need to have dimensionality assigned. I don't want a column with EPMLinks either---simply wanted to right click a cell and "show detail report" (all via macro).

Thanks though.

[former_member186338 · Accepted solution]

EPMLink can pass context members - no relation with currently selected cell. As I already told you - you can use simple VBA code to get the members from column and row axis related to current cell... What is the issue?