Chapter 6: Cognos 10 on Windows 2008 R2 – Need to know subjects

Environment: Server Operating system: Windows 2008 R2 DB: Oracle 11G Cognos version: 10.1 Oracle: Oracle 11G 32 Bit (!!!) needs to be installed – Cognos engine (Datasources) needs 32 bit Installation. JDBC Driver: Need to move ojdbc5.jar file driver from <Oracle direcotory>\jdbc\lib to <Cognos directory>\webapps\p2pd\WEB-INF\lib directory Please note: Cognos doesn't support jdbc 1.6 ! SQL … Continue reading Chapter 6: Cognos 10 on Windows 2008 R2 – Need to know subjects

Chapter 5: Enable Auditing in Multitenant Environment of IBM Cognos 10.2 BI

In today’s scenarios where many ISVs and partners are willing to provide ‘Analytics as a service’, they need a Business Intelligence platform which provide multitenancy environment with auditing/logging capabilities yet easy to manage.   The IBM Cognos platform provides complete auditing capabilities that enable auditing and managing system usage in multitenancy environment. The information logged … Continue reading Chapter 5: Enable Auditing in Multitenant Environment of IBM Cognos 10.2 BI

Chapter 3: Loading data from xml files into DM Tables

Loading dimension data into jobs dimension table Load the data into the dimension table with the script on the DB server based on that we copied the files into the source directory of the DB server (D:\Temp) 1cRevertCognosMachinesMainCI Example truncate table XMLwithOpenXML; INSERT INTO XMLwithOpenXML(XMLData, LoadedDateTime) SELECT CONVERT(XML, BulkColumn) AS BulkColumn, GETDATE() FROM OPENROWSET(BULK 'D:\Temp\1cRevertCognosMachinesMainCI.xml', SINGLE_BLOB) … Continue reading Chapter 3: Loading data from xml files into DM Tables