Partial data of a compounded characteristic

[Former Member]

Hi,

I was wondering if you guys know of a easier way to suppress a portion of the compounded characteristic. Here is an example.

0GL_ACCOUNT is compounded with 0CHRT_ACCTS. Here are how the values displayed on the report.

GL Account

-

---

USNA/account1

USNA/account2

USNA/account3

USNA/account4.....

I need to know if there is a way to chop off the first five characters when this report is opened. If there is no way, I am thinking of using update rules to do it. But I thought if there is a requirement in future to display the chart of accounts and the gl account off of this cube, I will be at a loss.

Regards,

Abdul

[Former Member · Accepted solution]

Hi Siggi,

Thanks a lot. I tried your 1st recommendation and it worked like a charm. You have no idea how much time I am saving because of this. Otherwise I was planning on creating a new attribute without the compounding and load the master data.

Thanks again.

Abdul

[Former Member · Accepted solution]

Hi Abdul,

if you are satisfied with the answers, please assign some points by clicking on the stars.

regards

Siggi

[Former Member]

Hi Abdul,

1st possibility: put 0CHRT_ACCTS into the filter and restrict it to 'USNA'.

2nd possibility: put 0CHRT_ACCTS just before the 0GL_ACCOUNT in your rows and set the attributes to no display.

regards

Siggi