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

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 SQLMonster.com" <u14323@uwe> wrote

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_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell