I have a problem which i think must have an easy solution.

The issue is i have a dimension lets say Delievery status. What i want
to do is that if someone is browsing in a way that the Delivery Status
= Delivered then i get a sum of measures else i want to show current
values of that measure.

I hope i have been able to explain the problem.

Waiting for a solution

Harris Moin

How many members in Delivery Status dimension? How do they behave?

One approach is to create a custom member (versus calculated member) in the
Delivery Status dim. The formula is stored in the dimension table, something
like this:

SUM(Measures.Members, [Delivery Status].DefaultMember)

It could also be done as a calc member for that matter, depending...

public @ the domain below
www.tomchester.net


"Harris" <harris (AT) techlogix (DOT) com> wrote

Hello Tom,

I solved my problem in a calculated member with the help of iif
statements ... now am facing a new problem i hope you can answer to
that post of mine.
"Date Dimension Problem".

Thanx for your help.

Harris Moin