dbTalk Databases Forums  

Error on calculated measure

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


Discuss Error on calculated measure in the microsoft.public.sqlserver.olap forum.



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

Default Error on calculated measure - 12-21-2004 , 08:53 AM






Hi,

I have a some measures in a cube. I've created a calculated measure which
does something with one of these maeasure. When i use the MDX sample
application to create a query based on this cube, to show this calculated
measures i get to see errors in this field (1.#INF). But when i show the
orginal field it shows up correctly. Does anybody knows why it behaves like
this?

Thnx,,
Stanley

Reply With Quote
  #2  
Old   
Stanley
 
Posts: n/a

Default RE: Error on calculated measure - 12-21-2004 , 09:13 AM






Problem solved. I've used a with member clause and a where clause in mu
statement. I switched these with each other and strangely (but glad though )
it now works.

"Stanley" wrote:

Quote:
Hi,

I have a some measures in a cube. I've created a calculated measure which
does something with one of these maeasure. When i use the MDX sample
application to create a query based on this cube, to show this calculated
measures i get to see errors in this field (1.#INF). But when i show the
orginal field it shows up correctly. Does anybody knows why it behaves like
this?

Thnx,,
Stanley

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.