Sorry; Typo:
It should be like this:
Sean gave me a solution on Part I. Well It seemed to work at first, but the
evaluating statement does not seem
to work complely
The statement:
SELECT {[Measures].[Unit Sales]} ON COLUMNS,
{Filter([Store].[Store Name].Members, VAL
(Store.currentmember.properties("Store Sqft")) >= 2000.1 )}
ON ROWS
FROM Sales
It seems as if it evaluates
'Store Sqft' >= 2000.1 to be equal to 'Store Sqft' >= 2001
and evaluates 'Store Sqft' > 2000.1 to be equal to 'Store Sqft' > 2001
Looks like it doesnot handle doubles very well.
My property is stored as a double in the cube, and this is really
handicapping my search in the database. I would like to have accurate
results... ( I am of course working on another cube, but sales is a good
sample)
Is this anything you guys know of?
/B?rge
Quote:> Sean gave me a solution on Part I. Well It seemed to work at first, but
the
> evaluating statement does not seem
> to work complely
> The statement:
> SELECT {[Measures].[Unit Sales]} ON COLUMNS,
> {Filter([Store].[Store Name].Members, VAL
> (Store.currentmember.properties("Store Sqft")) >= 2000.1 )}
> ON ROWS
> FROM Sales
> It seems as if it evaluates 'Store Sqft' >= 2000.1 to be equal to 'Store
> Sqft' >= 2000.1
> My property is stored as a double in the cube, and this is really
> handicapping my search in the database. I would like to have accurate
> results... ( I am of course working on another cube, but sales is a good
> sample)
> Is this anything you guys know of?
> /B?rge
by