New Topic

Category Data Sources

Product Version 7.2

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

Nagarjun shared this question 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

The same question

Replies (1)

Guest ●

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

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

Reply URL

Nagarjun ●

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

URL

Guest ●

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

URL

Guest ●

Hi Arjun,

good news, there is an easy way to get around this problem of not wanting to restart Yellowfin after doing backend modifications to the ReportFieldTemplate table!

Just run the web service called REMOVEVIEW immediately after your backend modifications and it will remove the current cached view, therefore Yellowfin will automatically reload the cached view values directly from the database the next time it needs them. You will find a complete example of this web services under the section title "REMOVEVIEW" in the following wiki article:

http://wiki.yellowfin.bi/display/USER74/Cache+Management+Services

Please let me know if you have any problems with it.

regards,

David

URL