I have created a Named Set called "LatestDay" in FoodMart2000. I want to
create a Calculated Member that references LatestDay, like this:

sum(qtd( Sales.LatestDay )).Item(0)

Using the Calculated Member Builder, the above formula does not work (with
or without brackets). Neither does referring to just "LatestDay".

I get the error, "Cannot find dimension member ("Sales.LatestDay") - in a
name-binding function."

What am I missing here?

That formula was supposed to be:

sum(qtd( Sales.LatestDay.Item(0) ) )

Same problem applies.

"SteveK" <none (AT) none (DOT) com> wrote

This sample Foodmart Sales query seems to work:

'Tail(NonEmptyCrossJoin([Time].[Month].Members))'
Member [Measures].[QTDSales] as
'Sum(QTD(LatestMonth.Item(0)),[Measures].[Unit Sales])'
Select
{[Measures].[QTDSales]} on columns
from Sales

- Deepak

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Deepak, were you able to enter that directly into the value expression
in Calculated Member Builder? I get the following error:

Unable to update the calculated member.
Formule error - syntax error - token is not valid: "With ^Set^
[LatestMonth] as
'Tail(NonEmptyCrossJoin([Time].[Month].Members))'
Member [Measures].[QTDSales] as
'Sum(QTD(LatestMonth.Item(0)),[Measures].[Unit Sales])'
Select
{[Measures].[QTDSales]} on columns
from Sales

Deepak Puri <deepak_puri (AT) progressive (DOT) com> wrote