Using Special Characters in Financial Dimensions

(0) Share

Report

Posted on by Abdo Khoury

14,855

Dear

from experience I know that it is NOT recommended to use Special Characters in the Financial Dimension and Financial Dimension Value

this could cause a lot of trouble in Management reporter, and other areas

Can someone confirm this ?

now is it ok if we include Special Characters in the Description of the FINANCIAL DIMENSION VALUE (not the code)?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

André Arnaud de Cal... 299,403 Super User 2025 Season 2 on at

Like (0)

Report

RE: Using Special Characters in Financial Dimensions

Hi Patrick,

The issues can be related to linking, filtering data based on characters also used as wildcards or Chart of accounts delimiter value. Select statements can have wrong interpretations.

If you use a question mark or other wildcard in the description, you might have the same issues.

What characters are you intending to use within the description?

Was this reply helpful? Yes No
Sohaib Cheema 48,893 User Group Leader on at

Like (2)

Report

RE: Using Special Characters in Financial Dimensions

Let’s keep aside the financial dimensions.

It’s not good practice to use special character anywhere. I remember many cases of past. One of our functional consultant used comma (,) as for sites of inventory.

I was reported “As we select a site, we cannot see related Warehouse.”

after diagnosis I came here at this line of code

queryBuildDataSource.addRange(fieldNum(InventLocation,InventSiteId)).value( _inventSiteId);

Microsoft standard Code was not having queryValue, so value was being read 1,2 instead of 12. Result was not warehouse in lookup

This is just one example, I can remember many examples like this.

I would recommend you, never use any special character, inside Primary Key Values. That really can ruin your day. Though for this case I know financial dimension table probably has RecId as primary key, but using special characters can bring trouble at any stage.

For description its fine, but for primary key its a bad idea.

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report

RE: Using Special Characters in Financial Dimensions

well mostly - (dash) and / (slash)

i just want to make sure so that we don't face any issue with the description later

Was this reply helpful? Yes No
Sohaib Cheema 48,893 User Group Leader on at

Like (0)

Report

RE: Using Special Characters in Financial Dimensions

can you kindly take a screenshot of screen, where you want to enter this hyphen(-) etc.

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report

RE: Using Special Characters in Financial Dimensions

i am referring to the Financial Dimension and Financial Dimension Code

Was this reply helpful? Yes No
Sohaib Cheema 48,893 User Group Leader on at

Like (0)

Report

RE: Using Special Characters in Financial Dimensions

I was trying to ask you screenshot for some reason, not sure why you cannot provide it. I know where those dimensions are located in GL.

Be careful, don't put hyphen(-) in dimension values, else you can face issue at DMF. for description its fine, you can use Hyphen or Slash.

Still, if you can provide a screenshot, it can be helpful for us to think better and suggest better

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Using Special Characters in Financial Dimensions

Hi Patrick, Do you plan to include different information into one single financial dimension? To me it sounds like that. If so please reconsider your financial dimension setup and probably work with two financial dimensions rather than a single "combined" one. All the best, Ludwig

Was this reply helpful? Yes No