December 30, 2023 at 5:23 pm
I want to write a comparison article on ROLAP and MOLAP, and I have installed SSAS. During the installation process, there was a Tabular section and a Multidimensional section that I needed to choose from. As far as I knew, Tabular is specifically for ROLAP, and Multidimensional is tailored for MOLAP. However, it seems that both environments support both ROLAP and MOLAP. Which option is better, and if, for instance, your choice is Multidimensional, could you explain how ROLAP works within it? Additionally, what dataset or database would you recommend for analyzing and comparing both methods? Finally, if the dataset is two-dimensional or relational, should it be transformed in ssis into a data cube for MOLAP to function? Is such a conversion possible?
December 31, 2023 at 6:09 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
January 2, 2024 at 5:23 pm
I think Item #8 in this article might help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply