How to add Multiple business names for various fields using a excel file/ref table?

Nagarjun shared this question 1 week ago
Answered

Hello Team,


I am new to Yellowfin, i just want to know, is there any possibility to update the business name for multiple fields on one-go.


i have hundreds of Fields which needs to be renamed, doing manually is error prone.


Guide me the best solution for this.


Let me know if you need further more information on this.


Regards,

Arjun

Comments (3)

photo
2

Hi Arjun,

Yellowfin stores the business name in the column ReportFieldTemplate.ShortDescription, therefore if you did something like

UPDATE ReportFieldTemplate 
SET ShortDescription = <new value> 
WHERE ShortDescription = <old value>

then that would work, although you will only see the changes take effect after restarting Yellowfin (because the application's metadata is cached locally).

Having said that now I need to say this, we actually do not support backend modifications such as these, although we do try to help out if you really want to do it.

And if you must do it, then please remember to back up your Yellowfin configuration database immediately beforehand just in case something goes wrong!

regards,

David

photo
1

Hello David,


Thanks for the guidance, well that will not completely satisfies my requirement as we could not able to restart the yellowfin as multiple users will be working on it.

I felt it would be good there is an option like loading a master file to fetch the business for all the fields.


Thanks and regards,

Arjun

photo
2

Hi Arjun,

that's a pity, but yes I understand you don't want any downtime during the restart.

Please feel free to raise a new Idea in the Yellowfin Community about your idea of loading a master file.

regards,

David

photo