OLAP MDX expression. IMMEDIATE HELP!!!!

[aksm4783]

Hi I have a question on Drillthrough function when I am building the cube.

I have a view named 'v_trans_003_06'
Column named 'tran' and it contains values (null, 1, 2, 5, 6)

I have a cube build on the v_trans_003_06 and the dimension name for this column is "Transaction Code"

My question is I would like the cube to show the data only for 'tran' column = 5 and 6.

I tried on the drillthrough option inside the cube edit menu, but I don't know how to setup the MDX expression for it.

what is the appropriate way to setup a drillthrough?

If you have a better solution. please let me know. But I don't want modify my view tho (only modify the cube).

Thank you very much for you help.

 

[Bygbobbo]

if you supply other info then I can make you a sample MDX query with criteria set.