I am having a contributor cube where the names of employees are entered by the users. while the name is stored correctly and displayed in CAC web fine it shows wrongly in the database when I publish it to SQL server view publish container.
The correct value is Langæble. but this gets published into the sql server as Langµble I am using cognos enterprise planning 8.1 and database server MS SQL Server 2005 both running on Windows server 2003 R2 SP2
I am using CAC publish view macro to publish the data to database(tried both advanced and the normal ones)
Configure application Admin options by adding -C (your_SQL_server_charset_code).
http://publib.boulder.ibm.com/infocenter/c8fpm/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.contrib_admin.8.4.0.doc/contrib_admin_id3601WP0053.html
What happens under the hood during publish:
- data is exported from XML files it's usually contained into a flat file
- data is BCPed from text file to publish container database
You can actually trace this process in temp folder. -C is actually a BCP option you can set up in admin console.
http://msdn.microsoft.com/en-us/library/ms162802.aspx
Thanks a lot Ykud.. it did the trick..
Best Regards,
Vasishta