How can I obtain a list of a SSAS Cube's dimentions and dimentions' attributes

Posted by Scott Weinstein on Stack Overflow See other posts from Stack Overflow or by Scott Weinstein
Published on 2010-03-31T21:01:02Z Indexed on 2010/03/31 21:03 UTC
Read the original article Hit count: 677

Filed under:

olap

|

ssas

I have a user asking me to list the dimensions and dimension attributes of our SSAS cube.

I susspect I could generate this via AMO, but I'm wondering if there's an MDX query or SSMS option to show the same info.

Any ideas?

© Stack Overflow or respective owner

Related posts about olap

MDX lekérdezések az Oracle OLAP-hoz

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Az Oracle OpenWord-ön, 2009. október 12-én jelentette be az Oracle, hogy elkészült a Simba Technologies MDX eszköze az Oracle OLAP eléréséhez: Oracle and Simba Technologies Introduce MDX Provider for Oracle® OLAP. Az MDX Provider for Oracle® OLAP eszközzel közvetlenül az Excel felületrol lehet elérni… >>> More
An OLAP client!

as seen on SQL Blog - Search for 'SQL Blog'
While surfing CodePlex I’ve come across a very interesting tool for all BI Developers who misses a decent OLAP client where to write, run & test MDX queries http://ranetuilibraryolap.codeplex.com/ I’ve not tested it yet, but I’ll surely do this week and I’ll post my impressions ASAP. The first… >>> More
An OLAP client!

as seen on SQL Blog - Search for 'SQL Blog'
While surfing CodePlex I’ve come across a very interesting tool for all BI Developers who misses a decent OLAP client where to write, run & test MDX queries http://ranetuilibraryolap.codeplex.com/ I’ve not tested it yet, but I’ll surely do this week and I’ll post my impressions ASAP. The first… >>> More
OWB 11gR2 – OLAP and Simba

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle Warehouse Builder was the first ETL product to provide a single integrated and complete environment for managing enterprise data warehouse solutions that also incorporate multi-dimensional schemas. The OWB 11gR2 release provides Oracle OLAP 11g deployment for multi-dimensional models (in addition… >>> More
Building dynamic OLAP data marts on-the-fly

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
At the forthcoming SQLBits conference, I will be presenting a session on how to dynamically build an OLAP data mart on-the-fly. This blog entry is intended to clarify exactly what I mean by an OLAP data mart, why you may need to build them on-the-fly and finally outline the steps needed to build… >>> More

Related posts about ssas

SSAS Maestro Training in July 2012 #ssasmaestro #ssas

as seen on SQL Blog - Search for 'SQL Blog'
A few hours ago Chris Webb blogged about SSAS Maestro and I’d like to propagate the news, adding also some background info. SSAS Maestro is the premier certification on Analysis Services that selects the best experts in Analysis Services around the world. In 2011 Microsoft organized two rounds of… >>> More
SSAS – Synchronisation performance

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
I’ve always thought of SSAS synchronisation as a clever file mirroring utility built into SSAS and i have never considered the technology as bringing any performance gains to the table. So, its a good job I like to revisit areas…. :) I decided to compare the performance of robocopy and SSAS Synchronisation… >>> More
Query Logging in Analysis Services

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
On a project I work on, we capture the queries that get executed on our Analysis Services instance (SQL Server 2008 R2) and use the table for helping us to build aggregations and also we aggregate the query log daily into a data warehouse of operational data so we can track usage of our Analysis databases… >>> More
SSAS: distribution of measures over percentage

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I am running a SSAS cube that stores facts of HTTP requests. The is a column "Time Taken" that stores the milliseconds a particular HTTP request took. Like... RequestID Time Taken -------------------------- 1 0 2 10 3 20 4 20 5 … >>> More
Preserving Language across inline Calculated Members in SSAS

as seen on Stack Overflow - Search for 'Stack Overflow'
Problem: I need to retrieve the language of a given cell from the cube. The cell is defined by code-generated MDX, which can have an arbitrary level of indirection as far as calculated members and sets go (defined in the WITH clause). SSAS appears to ignore the Language of the specified members when… >>> More