About b5noj

b5noj

HiIs it possible to set an EPM report to output to an excel table format instead of an excel cell range? Reason for needing the table is so I can then link the EPM report to a power query.Thanks

VBA - Expand member to base

Hi I'm currently using "api.ExpandMember" in my VBA code to expand members but I've noticed it use to expand to base but now isn't. I think it might be linked to my expand member options settings. Is there a command that forces the member to expand...

b5noj

Hi Is it possible to refresh and EPM report without activating or selecting a sheet?? I've always been told it's not good practice to select or activate a sheet when writing VBA. Example - Current method Dim api As Object api = Application.COM...

b5noj

Hi Is is possible with an EPM formula to retrieve a list of all base level profit centres that are below a specific parent profit centre? I know this could be done via a report for this example but I have a list of 10 parents that I need all the ...

b5noj

Ah thankyou. Such a long formula I felt like I'd read it loads to check for an error

b5noj

ok thanks"I've always been told it's not good practice to select or activate a sheet when writing VBA." - wrong idea! - Why?

b5noj

Is there a limit on the number of members you can use in the formula?Up to and including 6 members works fine=EPMDimensionOverride("000","PROFITCENTRE",I1&",BAS("&I1&"),"&I2&",BAS("&I2&"),"&I3&",BAS("&I3&"),"&I4&",BAS("&I4&"),"&I5&",BAS("&I5&"),"&I6&...

b5noj

Thanks Vadim. I've just realised what the issue was...it was the american spelling of "center" should of been the British version "centre"All working now and thanks for the member and base formula =EPMDimensionOverride("000","PROFITCENTRE",A1&",BAS(...

b5noj

Thanks. I've tried placing =EPMDimensionOverride("000","PROFITCENTER","BAS("&A1&")") above a report and it still doesn't change the outputs of the report below it. Where am I going wrong?Example below, on the left is what the report is showing (still...

User Statistics

User Activity

EPM report output to Excel Table instead of range

VBA - Expand member to base

VBA + Refresh referencing sheet name instead of selecting/activating

SAP BPC + returning base level profit centres from parent profit centres

Re: SAP BPC + returning base level profit centres from parent profit centres

Re: VBA + Refresh referencing sheet name instead of selecting/activating

Re: SAP BPC + returning base level profit centres from parent profit centres

Re: SAP BPC + returning base level profit centres from parent profit centres

Re: SAP BPC + returning base level profit centres from parent profit centres