Wednesday 15 July 2015

MDX Replace Range With Filter -


Seeing the following answer I wanted to change the border with a filter.

MDX: With member [remedy]

  is. [Kuluj] as zodiac ({[Date]. [Yakm]. [200 9 501]: [date]. [Yqm] & amp; ... [20090907]}, [remedy] [used]) on columns] All] .MEMBERS} on rows, {[remedy] [total used]}, {[color] [color [... [Cube]  

I'm trying to change the date range with a filter like this:

  with member [remedy]. [TotalUsed] as Yoga ([Date]. [Yakm], [Date]. [Yakm] and lieutenant [Date]. [Yakm]. [[2009090]), [Measures]. [Used]) Select {[Tips]. [All] on lines [[cube] .MEMBERS}  

What is the conditional statement to compare prices?

A filter statement needs a SET and then filter An expression for You can leave this right inside your SUM function. The expression part of the filter can be almost anything, but it has to prove true / false for each cell in the SET.

- Filter (Set, Experiment)

It does not know how difficult your data is, but your statement will probably end like the following, your timer For those filing lines with 'Younus' less than 50, and then summarize them as an example. Members with [Measure] [TotalUsed] Yoga (Filter ([Date] [YQM] .members, [Measures] [unused] & gt;

`

 From [cube] to [cube] to  
from [all] .MEMBERS} [RUB]

No comments:

Post a Comment