Question: when to use multidimensional database?
Answer: Multidimensional databases are used mostly for OLAP (online analytical processing) and data warehousing. They can be used to show multiple dimensions of data to users . A multidimensional database is created from multiple relational databases.