It would be great if Microsoft could create something like a columnstore that has not only indexing but also tables for common storage. It is used to perform data aggregation and create user-friendly detailed reports. It is an enterprise BI platform for data discovery automates the creation of reports and dashboards so users have the freedom to do it on their own. This option is available in Oracle Database. Cognos (Business Intelligence tool): IBM Cognos Business intelligence is a web-based reporting and analytic tool. This would prevent us from having to pay for troubleshooting and hosting the server.' 'I would like to see more integration with other platforms.' 'I would like to see the integration with other platforms improved in the future.' 'We would like to have a common storage option in the SQL Server. We use the solution with a Korean provider supporting only MySQL rather than Microsoft SQL Server, which would be preferable and cheaper.

The way it is supposed to work is that it will prompt you to enter the date, then it will hard code the date in the SQL. It's not something a layperson can do.' 'I would like the SQL Server to be able to provide cloud support. It will not work in the databse SQL editor because the prompt here is a Cognos macro which will not be recognised by Oracle. 'The installation process should be simplified.' 'Linux-based editions are not yet proven to be on par with Windows deployments.' 'While this is a reliable product, it has room for improvement.' 'You do need to have technical knowledge in order to install the solution.

Cognos sql prompt