Append variable into dimension

[ramanannad]

Hi Experts,

Have an inquiry on how do we append a value from a front-end variable into a loaded field from data source ?

Visualization :

Source table(excel file):

Name	Sales
MrA	100
MrB	101
MrC	102

frontend Variable(achieved thru an input box extension):

Variable	Value
vTstname	MrD

Expected Output :

Name	Sales
MrA	100
MrB	101
MrC	102
MrD	-

Or just ignoring the measure, we just need :

Name
MrA
MrB
MrC
MrD

Hope you guys any an idea about this, cheers

Ram

[arvind_patil]

HI Ramanan,

I think You Can replace field but you cant append row .

So i Suggest add extra Value in Back end and replace it with variable.

Thanks,

Arvind Patil