Share
Report
220Hi,
I have scenerio where I have filled dimension values in a table, now I need to fill the dimension name in table. I don't have default ledger dimension value here in this table. Thats why I can't use ledger dimention to find the value or name. Actually the report data volume is big. So, I need to update this table after filling the other values in table. While filling the dimension value I can't get the dimension name as it will slow down the process.
There are two methods in my mind to update these
1. If I can find the definition table where the actuall dimension values are saved, like the dimension BusinessUnit and ProjectCompetency data. But unfortunathly I did not find that.
2. If I can find a function where I can pass the dimension name (ProjectCompetency) and its value like '01' and I can get its name which is saved against the '01'.
Please help me to find the dimension name, thanks
| ProjCode | ProjCmpetency | Competency Name | BUCode | BUName |
| 001-002 | 01 | ? | 001 | ? |
| 001-003 | 02 | ? | 002 | ? |
| 001-004 | 01 | ? | 005 | ? |
| 001-005 | 03 | ? | 002 | ? |
here are the dimensions are defined
All responses (
Answers (
