dbTalk Databases Forums  

Problem with writting MDX filtered only by Measures Value

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


Discuss Problem with writting MDX filtered only by Measures Value in the microsoft.public.sqlserver.olap forum.



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

Default Problem with writting MDX filtered only by Measures Value - 06-07-2006 , 09:46 AM






I have problem, I do not know how to write MDX, for specific question.
I must sum one of the Measures, but I must to do it by measure value

It is very easy to write in SQL
Select sum(income)
from Sales
where income>10

but I have problem to write it in MDX
I need to sum this by all dimensions (dim1... dim25), but only choose
that cells, where it's value (income) is greater then 10.

It wouldn't be a problem if I could build Calculated Measure like:
iif([Measures].[Ms]>-20000,10,0)
but it is a great problem to write it in MDX (or rather generate it,
when I do not know about all user filters.) My users can "building"
their MDX queries (without knowlage of it :P), but they can filtr only
by dimensions. How to filt by measures value?

Please help me

LS


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.