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
Hello Kacper,
Where do you want to include the dimension? Into a report, excel export, upload file, etc.?
Can you provide some additional details on that issue?
Many thanks and best regards,
Ludwig
Hi Kacper,
Please provide information about what you were trying to achieve and if you get errors, blank screens or something different.
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
Can you save your screenprint as a picture and upload it once again using the 'use rich formatting' screen/button?
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.
Hi Ludwig,
doesn't work
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
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?
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,
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Tocauer 4
Alexey Lekanov 3
Willem van Duren 2
