dbTalk Databases Forums  

Pivot Tables with OLAP Cube - Dimension Properties Excel 2K

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Pivot Tables with OLAP Cube - Dimension Properties Excel 2K in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jérémie Gent
 
Posts: n/a

Default Pivot Tables with OLAP Cube - Dimension Properties Excel 2K - 08-05-2005 , 03:00 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 happy 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/t...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!






Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Pivot Tables with OLAP Cube - Dimension Properties Excel 2K - 08-05-2005 , 09:17 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 (AT) online (DOT) 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 (AT) hotmail (DOT) com> wrote

Quote:
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 happy 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/t...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!








Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.