Is there any work-around for the below 30-char issue in PMF.
Assuming I have a Location dimension which has 4 hierarchy levels.
Level1 -> Country
Level2 -> State
Level3 -> Region
Level4 -> Branch
here Branch level contains data which is more than 30 char.
And I have a Measure "Sales" which uses this dimension.
I am facing data mismatch issue when dimension data(Branch) is greater than 30 char, as my database contains "Information Technology Outsourcing Center" where as PMF truncates this data automatically to 30 characters "Information Technology outsour".
one way is to truncate database value to 30-char and then compare, but I dont want to use this approach because my database has possible values like
"Information Technology Outsourcing Center - 1"
"Information Technology Outsourcing Center - 2"
which will again cause a mismatch issue.
any help is greatly appreciated.
Thanks in advance.
Windows, All Outputs