EPMDimensionOverride with Excel Formulas?

[former_member1198299]

Hello,

I'm trying to create a report where the Column Axis Dimension TIME will have three members that change depending on the current month selected on a separate worksheet.

I don't know how to use the EPMDimensionOverrideFormula to get the third parameter to reference three cells on the other worksheet, cells E5 (Current month), F5 (Prior Month), G5 (Prior Year).

I can get the above formula to work no problem if I specify the third parameter as one of the cell references =EPMDimensionOverride("000","TIME",Selections!E5) but not with all three months cell references together?

[former_member186338 · Accepted solution]

Easy, just a basic Excel knowledge

=EPMDimensionOverride("000","TIME",Selections!E5&","&Selections!F5&","&Selections!G5)

resulting in comma separated list of members.

[former_member1198299 · Accepted solution]

That's very helpful, thankyou very much Vadim. Sometimes I just can't get the easy bits correct!!