Solved

SQL Server Data Tool in SQL Analysis Services

Posted on 2014-11-12
2
143 Views
Last Modified: 2014-11-12
Is there any example to illustrate how to use the SQL Server Data tool to browse a cube ? In previous version, there a indication to show "Drop Row Field", "Drop Filter Fields" and "Drop Column Fields" but it doesn't appear in this version. All drag field as align as row column. How to set filter for this version ?

Tks
0
Comment
Question by:AXISHK
2 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40437765
The Browser for the 2012 version (which I presume you are in) is really annoying - the 2008R2 version was much better.

Either:

1. Drag it into the bit above which says "<Select dimension>" - that's still the same as last time, or
2. Export it to Excel (by clicking on the Excel icon) and use it as a PivotTable.
0
 

Author Closing Comment

by:AXISHK
ID: 40439027
Tks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question