AS2005: non empty behavior but for particular position only?

Hi,

does it possible to setup the non empty behavior option of a calculated
member regarding specific positions in the cube?

I have a formula like:
measures.NYSales = (measures.sales, country.city.NY)
(in reality my formula is more complex, but the idea is the same)

so the result is empty when I'm not on the NY city.
but my Excel users will see empty (null value) cells for other cities.
and the non empty option in the select statement don't hide these cities
because they are not empty.

select non empty country.city.members on 1,
measures.NYSales on 0
from sales

display all cities not only NY.

so, how can I setup a non empty behavior option for the specific sales AND
NY position only and not based on the sales measure only???
remember, my users use Excel, so there is no ad-hoc MDX query, only the
pivottable...

thanks.

Jerome.


.

Relevant Pages

  • Re: Error -6002
    ... > Setup has experienced an error. ... > - empty your temporary folder ... > - check your internet connection ...
    (microsoft.public.windowsxp.basics)
  • RE: Columns into 2 way tables
    ... the ctrl + alt + enter) but the cells remain empty. ... Are there any lists or ... The Output needs to be a table with 3 columns: Low, ... the corresponding name in a descending order of sales. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Pages 2: make a chart from a table?
    ... Martin S Taylor wrote: ... empty, I want it to ignore it. ... eg. if January's sales are 100 and March's are 200, but there's no data entered for February, I'd like a nice straight line joining the 100 to the 200, cutting the February axis at 150 but with no little blob on the line to imply that the 150 came from actual data. ...
    (uk.comp.sys.mac)
  • Re: Harley-Davidson continues to misfire, will cut 1,000 more jobs
    ... Sales and revenue are down sharply, and the pipeline is empty enough to cut another 1000 of their employees. ...
    (rec.motorcycles)
  • Re: sed /awk problem
    ... > if setup is now then empty then remove it ... > THEN if sys is also now empty remove that too ... but if not then perl is ok too. ...
    (alt.linux)