Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Which OLAP databases can I use for building cubes and performing multi-dimensional data analysis?

April 26, 2017analysis building Cubes Data databases multi-dimensional OLAP Performing

0

Posted

Which OLAP databases can I use for building cubes and performing multi-dimensional data analysis?

1 Answer

0

Posted

A. Cubes can be built and managed with Analysis Services of SQL Server. Analysis Services is included with the Enterprise, Standard, and Developer editions of SQL Server. Further Oracle 9i database also has full fledged warehouse building capabilities with relational and multidimensional systems. ERPJewels DTS can give summary information periodically to SQL server / Oracle for updation to SQL server / Oracle. General program with DDL statements have to be written in a client program by customer to update the SQL server/ Oracle. If the Baan production server also is OLAP server, (which is possible in case of SQL server & Oracle 9i) users can use forward integration of ERPJewels to use the database native OLAP services. All users need to do is to write a small after analysis program for each analyses, to update the same into native databases relational tables.