Connect to Analysis Services 2005 from Excel 2007

I have recently discovered the ability to connect to an Analysis Service 2005 OLAP connection from Excel 2007. It looks and functions great. I do have one thing that am trying to do, however, that I am hoping it has. Does anyone know of a way that from the Pivot field panel, you can see the description metadata that is defined on the measures and dimensions in the Analysis Services cubes? It would be very useful if this come up in a tooltip or something. Otherwise, the business users will need a supplemental document while they are navigating the cubes.

Thanks in advance for your response.

I'd be interested in knowing how to do this as well.|||Sorry Guys, I don't think there is any way of accessing this data using the out-of-the-box functionality in Excel 2007. I even tried using the CUBEMEMBERPROPERTY() function in Excel, but it did not seem to be able to access the intrinsic properties like DESCRIPTION.|||Yikes! I thought Excel 2007 supported all SSAS2005 features? I can't express how useful and how much of a time-saver this feature would be. The "workaround" is that I'd have to create a big ugly document that our business users will have to print out and refer to. Even a simple tooltip that showed the member description in the dimension/measure browser would be immensely useful.

Is this something that we'd need to file w/ MS Connect?|||Thank you for your responses. I suppose I will have to put together a user-friendly on-line reference for people to use. Hopefully a future version will have this feature.|||

Unfortunately I don't think there is a section on Connect for Excel, otherwise this would definitely be the place to lodge such a query. I will see if I can find out if there is an avenue through which such a request can be lodged.

It is not an SSAS issue as the property is present, Excel just does not expose it. It might be possible to extend Excel to display the descriptions, but I have not had a chance to look into this. It would be possible to generate documentation from the meta-data in SSAS BI Documenter (www.bidocumenter.com) does this, but the documentation it produces might be a bit overwhelming for a business user.

sqlsql

connect data OLAP SAP BW from SQL Server 2000

We are now doing application in SQL Server 2000 that needs data from SAP. Unfortunately, we may not access data from the database itself.
We only may view data from SAP BW.
we consider how to get data from SAP BW.

Since we know that SAP BW is an OLAP system, how can we get the data from there without access the database?
Do you have any idea about it?
is there any connector tools that we can use?
Really need a help about this.

Thank you for any advices.

Regards,
Tyas

There are lots of extraction tools that cost money from various sources and I believe there is an export to text tool thats part of SAP.

connect data OLAP SAP BW from SQL Server 2000

We are now doing application in SQL Server 2000 that needs data from SAP. Unfortunately, we may not access data from the database itself.
We only may view data from SAP BW.
we consider how to get data from SAP BW.

Since we know that SAP BW is an OLAP system, how can we get the data from there without access the database?
Do you have any idea about it?
is there any connector tools that we can use?
Really need a help about this.

Thank you for any advices.

Regards,
Tyas

There are lots of extraction tools that cost money from various sources and I believe there is an export to text tool thats part of SAP.