Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSAS - Cube Browser - SQL Server 2012 RTM

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.

like image 784
Sreedhar Avatar asked Apr 13 '12 04:04

Sreedhar


People also ask

Is SSAS included in SQL Server?

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.

What is alternative for SSAS?

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.


2 Answers

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...

like image 50
Mario Avatar answered Sep 18 '22 16:09

Mario


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 :)

like image 23
Diego Avatar answered Sep 20 '22 16:09

Diego