|
Home > Archive > MS SQL Server OLAP > September 2005 > Member Property
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]
|
|
| Sanju via SQLMonster.com 2005-09-27, 3:24 am |
| Hello All,
I want to know that how can i see member property in pivot table.
I can set member property for any dimension but I dont know, how to see that
property value in excel while using pivot table for that cube.
Can we see that property in table, if yes, how.
Thanx
| |
| michael v 2005-09-27, 7:24 am |
| The version of excel / pivot table is as important as the server version...
However - you could try the excel add in (separate download on the microsoft
site) or the owc (you should already have that one) - in owc I believe you
can put member properties into the current pivot report or use "mouse over"
to see them.
In excel you perhaps need to code it.
"Sanju via webservertalk.com" <u14323@uwe> wrote in message
news:54fb172fd4e29@u
we...
> Hello All,
>
> I want to know that how can i see member property in pivot table.
>
> I can set member property for any dimension but I dont know, how to see
that
> property value in excel while using pivot table for that cube.
>
> Can we see that property in table, if yes, how.
>
> Thanx
| |
| Darren Gosbell 2005-09-28, 3:24 am |
| Excel does not provide an standard interface for viewing member
properties. You could try OWC (Office Web Components) or you can expose
them through calculated measures.
--
Regards
Darren Gosbell [MCSD]
< dgosbell_at_yahoo_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
|
|
|
|
|