Multi-dimensional Member Formula gives error

[trond_valldal]

Hi everybody,

I'm trying to create a multi-dimension Member Formula in BPC (see pic 1). It accepts it when I do the processing (see pic 2), but when I try to use it in an EPM report, it gives an error (see pic 3). Is this a bug? Is the syntax incorrect? Not much help to find online, unfortunately.
For the record, I've tried using both comma (as seen) and ampersand (&) to link the two dimensions in the formula. They're both accepted when processing, but both give the same error in EPM.

Any input is appreciated.
Thanks and regards
Trond

md-2.pngmd-3.png

[former_member186338]

Incorrect syntax - tuple has to be enclosed in brackets:

([A_SUB_ACCOUNT].[6500],[A1_ACCOUNT].[A500000])-(...)

[trond_valldal]

Awesome --- thanks. Worked like a charm. 🙂

[former_member186338]

According to the forum rules, please accept the correct answer!