Just playing around with SQL Server 2012 and tried to browse cube; cannot see option of Drop Row Fields here / Drop column Fields here or Drop Filter Fields here. Is this bug or is there any other setting to change the view.
SQL Server Analysis Services (SSAS) is a multi-dimensional OLAP server as well as an analytics engine that allows you to slice and dice large volumes of data. It is part of Microsoft SQL Server and helps perform analysis using various dimensions.
Kyvos is the best SSAS MDX alternative solution that helps you scale your OLAP cubes on the cloud or an on-premise data lake, both because of its similarity to SSAS as well as the difference in the way it implements cubing, catering to modern data platforms.
If they decided to take it the OWC-based browser, the least they could've done was to give us something that had better -- not worse -- functionality. What a major pain to click the Excel button every time you need to verify the cube data while developing...
yes, you don't have that functionality anymore but on the other hand, you can drag and drop your fields and by clicking on the "design button" you can have the generated MDX, which was not possible on 2008.
I think its a fair trade :)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With