How do I display Code and Long Name together?

[Former Member]

Hello. I am using EPM Add-In Ver 10.0. I current have a report that displays Code (G/L account number) and Name (Short description of the account name) for the account dimension. I would like to be able to display Code and Long Name and I've been unsuccessful so far for the account dimension. I was able to display the Long Name on its own by clicking on the dropdown "Select Members Names to Display" in the EPM Member Selector window but I would like to see the account number (code) as well. I've been trying various EPM formulas but my knowledge is limited on that front and I was hoping to get some help and point me in the right direction. Thank you.

-Amit

[former_member186338]

Screenshots, please! Are you using BPC embedded or...

[Former Member]

Hi Vadim.

See Column A. Currently, I have the account number and the short name of the account displaying. Notice the description of the account is cutoff and not fully displaying. I would like to be able to show the account number and the long name of the account because the full name contains valuable identifiers for the account. My 2nd screenshot shows the selection I would make in the Report Editor to select the long name. The resulting report is displayed in the 3rd screenshot that shows the full description of the account. I am trying to display it where I can see the account number and this long name of the account. Sorry if I'm not explaining this well as I'm still learning the system but no one internally seems to know the answer. I'm not sure about your BPC question but my last screenshot shows how I access EPM. Its the EPM Add-In Prod link. I don't believe its BPC embedded.

[Former Member]

Hello Vadim. I'm posting again as I received a message saying my first reply didn't go through.

See Column A. Currently, I have the account number and the short name of the account displaying. Notice the description of the account is cutoff and not fully displaying. I would like to be able to show the account number and the long name of the account because the full name contains valuable identifiers for the account. My 2nd screenshot shows the selection I would make in the Report Editor to select the long name. The resulting report is displayed in the 3rd screenshot that shows the full description of the account. I am trying to display it where I can see the account number and this long name of the account. Sorry if I'm not explaining this well as I'm still learning the system but no one internally seems to know the answer. I'm not sure about your BPC question but my last screenshot shows how I access EPM. Its the EPM Add-In Prod link. I don't believe its BPC embedded.

[former_member186338]

Screenshots are not visible! Use "Insert Image" button to insert screenshot saved as a file!

"I don't believe its BPC embedded." In BPC standard you have only ID and single description! May be you have extra property?

[former_member186338]

Visible! Thanks a lot.

[former_member186338]

"I don't believe its BPC embedded." - looks like it's embedded!