Hi,

I'm reading through the old posts here via groups.google.com. It seems that at
one time it was NOT possible to see calculated members in virtual cubes via
Excel's Pivot Table. Should one be able to seem them now? (As of SQL 2000 and
AS SP3a).

I've built a virtual cube; populated it with calculated members. Pull it into
an Excel Pivot Tbl and can't see the calculated members (within the dimension I
put them into).

thanx.

pat

Unfortunately, any calculated members outside the measures dimension will not
be visible through PTS, or the OWC. Via your own customization using ADOMD,
or ADOMD.NEt, or with other front ends (like Pro Clarity, Panorama, etc...),
those calculated members will be visible, no matter which dimension they're
in.

"Patrick Flaherty" wrote:

Ooh that's bad. I need to add a lot of Calculated Members and I feel quite
certain that I don't want to put them all in [measures].

I've been having various and sundry problems doing what I'm trying to do (make
an existing USD-only cube multi-currency). I _do_ have an April CTP
installation of SQL 2005. Maybe it's time to see if I can figure out how to
transfer my cube there. (I wanted to avoid this at the moment - too many
potential learning curves).

pat


In article <E2AE71AD-0901-4465-9B7E-E1DBA9F80F81 (AT) microsoft (DOT) com>,
=?Utf-8?B?U1FMIE1jT0xBUA==?= says...

Migrating my AS 2000 db to AS 2005.

Posted this to the private SQL 2005 newsgroups at MS. Might as well put it
here as well (I don't believe that constitutes cross-posting [since the other
one is buried]).

*********

The first part of the migration seemed to work quite
well. It collapsed a couple of dimensions into one which
seemed to me to probably be OK. But something that I
should investigate further later. In addition there was
an err message attached to a Parent-Child dimension.
Don't yet know what that means either ...

The next step after Validating is 'Migrating Databases'.
This flashes briefly (the progress bar) and then stops:

Cannot add a null item to a collection.

The icon is a 'Warning' icon (exclamation point). But the
Next button is greyed out.

Any ideas?

pat





In article <E2AE71AD-0901-4465-9B7E-E1DBA9F80F81 (AT) microsoft (DOT) com>,
=?Utf-8?B?U1FMIE1jT0xBUA==?= says...

At the same time that I'm pursuing these other avenues (e.g. AS 2005), I've done
a littel ADOMD in the past. Pointers to relevant (display Calculated Members to
be found in dimensions other than [measures]) ADOMD code?

thanx.

pat



In article <E2AE71AD-0901-4465-9B7E-E1DBA9F80F81 (AT) microsoft (DOT) com>,
=?Utf-8?B?U1FMIE1jT0xBUA==?= says...

More importantly, what version of Excel are using - this was a
well-known issue with Excel 2000? FYI: with Office 2003, I'm able to see
(non-measure) Calculated Members of a Virtual Cube, in both Excel and
OWC Pivot Tables.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

I'm using Excel 2003 SP1.

So where then does that leave me?

pat

In article <u68X6T2WFHA.612 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, Deepak Puri says...

That's strange, I'm using Excel 2003 as well, and can't see calculated
members that aren't in the measures dim either. I've never been able to see
calc members outside of the measures dim in any versions of Excel.

If there are some newer components that allow this to work (newer dll's,
versions of PTS, etc.) please let me know, I've had a lot of frustrated
clients with this limitation.

Thanks!

- Phil

"Deepak Puri" wrote:

Hope someone else can shed some light, since I can't reproduce this
problem - could it be a connection string option (assuming you're using
OLE DB for OLAP 8.0)?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Yes I'm using OLEDB for OLAP 8.0

Connection string option - hmm not inconceivable. I'll check it out.

From the following:

http://support.microsoft.com/default...;en-us;Q259587

it wasn't clear to me whether MS considered Pivot Tbl non-display of
non-[measures] Calculated Members to be a bug or feature. ('More Information'
makes it sound like it's almost part of the design).

Although the above document is referring to cubes in general. Virtual cubes (my
case) may another matter.

pat



In article <eI2csZ9WFHA.2768 (AT) tk2msftngp13 (DOT) phx.gbl>, Deepak Puri says...