You’re offline. This is a read only version of the page.
105
Hi,
I am not able to include one of client dimesion because of "&" sign in dimesnion's name.
Does anyone have an idee what to do in this case?
Thank you in advance
Br
Kacper
*This post is locked for comments
Good Morning Kacper,
Please test this carefully and let us know the result.
Also discuss with your colleagues how you can avaoid similar issues with findim IDs and special characters in the future.
As usual, if your question has been answered don't forget to verify.
Many thanks and best regards,
Ludwig
Hi,
that will be an option. Thank you for your time.
BTW
I wrote a post to you regarding consolidation:)
Thank you very much for your support
BR
Kacper
So, your findim is an operational unit, right?
Those findims usually have a number assigned that is specified by a number sequence and that avoids this kind of issue.
How many transactions do you have posted with this R&D findim?
Can you possibly create a new operational 'department' unit and transfer the balance from what has been posted to R&D?
Would that be a lot of work and is that feasible?
Best regards,
Ludwig
Hi,
it doesn't work. Someone wrote following on the MS forum:
You cannot rename the core dimensions of Business Unit, Cost Center, or Deparement. Just do not use those and create a custom one if you dont like.
Is that true because this is the Departement?
Br
Kacper
Hi,
What about using the filter without the square brackets? If this doesn't work then you would have to rename the findim. Renaming a findim might break the records in the datamart and you would have to rebuild it.
Best regards
Ludwig
Hi Ludwig,
doesn't work
Br
Kacper
Hello Kacpar,
Can you try entering [R?D] manually?
The ? is a placeholder that replaces the & symbol.
I have not tested this but it might work provided that you have no other findims that have 3 letters and that start with R and end with D.
Would be great if you could test this and let us know the result.
Many thanks and best regards,
Ludwig
Hello Kacper,
Can you save your screenprint as a picture and upload it once again using the 'use rich formatting' screen/button?
Many thanks and best regards,
Ludwig
Hi Andre,
please find attached file. This is occur (but not in tree definition) in coulmn definition-Dimension Filter. This is the reason why I need to create dimension filter in tree defintion
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (