December 01, 2006, 05:09 PM
Rohit NayakRegenerate Synonym after change in Dimension values?
Hello All,
I am running Webfocus 711 on Windows. Recently the data cubes that we use for reporting were updated with 2006 for Year dimension.However the synonyms were not pulling in 2006 in the values list.
So i went ahead and recreated synonyms thinking that would help. No change ...still no 2006.
Next I recereated one synonym with a different name...and viola 2006 shows up in the list of values.
I have tried restarting the services,the box etc....but nothing seems to make the original synonyms show up with the new value for year.
Any ideas on what is happening here and how to fix it ?
Thanks
~Rohit
December 01, 2006, 08:02 PM
N.SelphYou probably have an extra master file with the same name as the old synonym somewhere, and it is pointing to the wrong data.
Do
WHENCE
synonymname MASTER
to find it.
December 05, 2006, 03:48 PM
Rohit NayakThanks NSelph,
Your hint helped me track down a duplicate synonym file and delete.
~Rohit