Hi Guys,
My table column has below values.
'#MULTIDIM ENTITY=[9801] AND UD20X=[Expense] AND UD3=[0129] AND UD2=[0000]'
I want to extract it in a way that ENTITY Value extracts 9801 then UD20X as Expense, UD3 as 0129 so on and so forth. I want to insert the value in a separate table.
Can anyone please help me how to achieve this.
There are the columns with multiple values as well
e.g.
#multidim ENTITY=[1811,1871] AND UD3=[1413,3001,3002] AND UD2=[4601]