TM1 Forum

Thanks for the reply lotsaram and apologies, I'm not sure what i was thinking yesterday but i only presented part of the problem. Please allow me to have another go :) I am trying to build a dynamic subset over the product dimension, i've used MDX before to do this and can even do it without the rec...

hi Guys, Very sorry to necro an old thread but it is the closest one i've found that is close to my question. I've been trying to wrap my head around it all day and cannot work it out. { FILTER( {TM1FILTERBYLEVEL({TM1SUBSETALL( [product] )}, 0 )}, [Merch3].( [Version].[Actual] , [Warehouse].[Group T...

vigneshg86 wrote:I should also add that you are a master of MDX

Cheers

haha, no , not really but thank you for the kind words. It was great to work this out as it helped me with the issue i was having.

All the best

Hi vineshg86,

Try this:
Cheers,
James

My apologies, I was basing the code of what i had done and was thinking you could dissect a solution from that.

Two questions;

1. Are all your company cost centres four letters and upper case?
2. Do your cost centres have an "E" at other points eg. ALPE, AEPL etc

Cheers,
James

Sorry it is { FILTER( { FILTER( {TM1FILTERBYLEVEL( { TM1SUBSETALL( [cost centre] ) }, 0 ) }, [cost centre].[company] = "EAPL" ) }, INSTR( 1, [cost centre].[company], "E*" ) < 1) } it returns only the cost centre element which has the company attribute value of EAPL Try this { FI...

Sorry mate, I still couldn't figure out how to do that. Cheers I think I have it bud: { FILTER( { FILTER( {TM1FILTERBYLEVEL( { TM1SUBSETALL( [dimension] ) }, 0 ) }, [dimension].[Attribute] = "AttribValue" ) }, INSTR( 1, [dimension].[Attribute], "AttribValue" ) < 1) } I noticed i...

Thanks for that Tomok.. My problem is actually trying to wilcard an attribute, the way you said is helpful if i want to wildcard based on the principal element name. I am trying to get all the elements for which one of the attribute starts with 301. Do you think it is doable? Thanks again Not to ne...