dbTalk Databases Forums  

Calculated dimensions not working in Excel2000 or OWC

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


Discuss Calculated dimensions not working in Excel2000 or OWC in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jim Rowe
 
Posts: n/a

Default Calculated dimensions not working in Excel2000 or OWC - 08-01-2003 , 04:23 PM






I have a normal Parent dimension, "Customers". I have
created a calculated
dimension called "Top 10 Customers"--Sum(TopCount
([Channel].[Customer
Id].Members, 10, [Measures].[Net Revenue]) )

I can't get it to work in either Excel or OWC:

->Excel 2000: when I add the dimenstion to the top, and
select the "Top 10
Customers" value, it crashes Excel with an application
error ("The
instruction at "0x308d03c8" referenced memory ...")

->OWC: when I add the dimension as a filter and expand it,
I see nothing,
just a blank box where you normally would check a
dimension.

Calcuated measures however seem to work just fine.

Any thoughts...?

Thanks in advance.
Jim

Quote:
-----Original Message-----
There is no message with ID specified in this newsgroup

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.