S
Siv
Hi!
I was faing one problem with Excel 2003 related to pivot table. But when I
use OWC there is no problem of that sort.
I am connecting to a OLAP Cube which is there in Analysis Server 2000
through Pivot Table service in Excel 2003. The cube to which I am connecting
has many calculated measures.I draged oneof the dimension to my ROW Field
Area. I drilled through that diemnsion. At some level I grouped some members
into one. When I did that,all the calculated measures hae become invisible.
Even after ungrouping,I was unable to see those measures.Only when I close
and open it again I am able ro see the data but with out those groups.
When I do that using OWC in Sharepoint,I am able to do.
Can anyone suggest a solution for this to do in Excel.
Thanks
Siv
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...c6a10c5&dg=microsoft.public.excel.crashesgpfs
I was faing one problem with Excel 2003 related to pivot table. But when I
use OWC there is no problem of that sort.
I am connecting to a OLAP Cube which is there in Analysis Server 2000
through Pivot Table service in Excel 2003. The cube to which I am connecting
has many calculated measures.I draged oneof the dimension to my ROW Field
Area. I drilled through that diemnsion. At some level I grouped some members
into one. When I did that,all the calculated measures hae become invisible.
Even after ungrouping,I was unable to see those measures.Only when I close
and open it again I am able ro see the data but with out those groups.
When I do that using OWC in Sharepoint,I am able to do.
Can anyone suggest a solution for this to do in Excel.
Thanks
Siv
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...c6a10c5&dg=microsoft.public.excel.crashesgpfs