Duplicate names or formula exceeds 255 characters

If multiple members have the same name or if the MPCData formula exceeds 255 characters, data is not shown in the worksheet.

If formulas exceed 255 characters because descriptions are too long or if the database includes duplicate names for members, you must use the unique name for the member by removing the dimension parameters from the MPCData formula and replacing it with the unique names for the dimension and member, according to this syntax:

• XMLA Syntax: "[<unique dimension name>].&[<unique member name>]"
• XMLA Example: "[Unit].&[5]"