|
Home > Archive > MS SQL Data Warehousing > August 2005 > Dimension Properties in Excel 2K Pivot Table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Dimension Properties in Excel 2K Pivot Table
|
|
| Jérémie Gent 2005-08-05, 3:23 am |
| Hi!
I use Excel Pivot Tables as OLAP Cube Browser, for cubes which are on an SQL
Server Analysis Services Server.
This works fine and I'm hapy with it, but some of my cubes contain dimension
properties, that only Excel 2003 can show, and my company's unfortunately
working with Office 2000, Excel 2000 doesn't handle the dimension
properties.
Does anyone know an Add-in or something I could install for Excel 2000 to
access the dimension properties as well?
Or
Does anyone know a free asp web cube browser such as
http://www.microsoft.com/downloads/...&displayLang=en
(ASP, not ASPX if possible) but a little more enhanced? (with dimension
properties handling etc.) ?
Or
A version of Office web components that wouldn't need Office 2003? (Not sure
if it solves the problem though as I don't know OWC)
Thank you very much!
| |
| Dave Wickert [MSFT] 2005-08-05, 9:23 am |
| SQL magazine ran an article called "Member properties bootcamp" which talked
about various ways to use member properties even if you don't have member
property support with your tool. Check out: the July 24, 2003 issue.-- use
www.sqlmag.com and search for "member properties".
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jérémie Gent" <jer_kjr@hotmail.com> wrote in message
news:%23ySp76YmFHA.3120@TK2MSFTNGP09.phx.gbl...
> Hi!
>
> I use Excel Pivot Tables as OLAP Cube Browser, for cubes which are on an
> SQL Server Analysis Services Server.
> This works fine and I'm hapy with it, but some of my cubes contain
> dimension properties, that only Excel 2003 can show, and my company's
> unfortunately working with Office 2000, Excel 2000 doesn't handle the
> dimension properties.
>
> Does anyone know an Add-in or something I could install for Excel 2000 to
> access the dimension properties as well?
>
> Or
>
> Does anyone know a free asp web cube browser such as
> http://www.microsoft.com/downloads/...&displayLang=en
> (ASP, not ASPX if possible) but a little more enhanced? (with dimension
> properties handling etc.) ?
>
> Or
>
> A version of Office web components that wouldn't need Office 2003? (Not
> sure if it solves the problem though as I don't know OWC)
>
> Thank you very much!
>
|
|
|
|
|