Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In the dimension I have a list of serial numbers with status <> 'Booked'. (Since I only want to see the serial numbers which have open records).
In the expression I need to count all previous records and the current record for this serialnumber list ... so I want to overrule the dimension partly to retrieve also the records for the count with status = 'Booked'.
I tried this with set analysis by setting {<Status = >} but this did not the trick.
Now I wonder if there is any way to overrule this Status which is used in the dimension??
I did also try it otherwise so all serialnumbers are in the dimension ... to retrieve the last ordernumber for the serialnumber, this works but now I also have all serialnumbers which I don't need to see (the ordernumber is empty for those) ... Could it be a solution to use the selection for the expressions to be null to filter out the serialnumbers in the dimension??
Hope someone can help me finding a clue ...
Anita
What I do now is to check if the expression of the last column is null, if so I make the expressions in all other columns to be null too ...
Don't think this is a good solution ... but can't find anything else ...
Someone got ideas??