TM1 Forum

Thanks Evgeny for your help too. I will try your expression soon.

James, Please stay in touch through this forum or email. my email address is (sgvignesh@hotmail.com)

Best of luck

Cheers

I should also add that you are a master of MDX

Cheers

OMG James!! You are simply a legend!!!

That works perfect. Thanks a lot again.

Cheers

Hi James, Company is an attribute of a cost center. There could be more than one company mapped to a cost center. but there is only one to one relationship for a CC. All my company attribute has got only four letters, below is the list of values i have for the company attriute at the moment FHFM LYP...

Hi jdeberardis,

It still returns only one element (same result). Any thoughts?

Cheers

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

Sorry mate, it doesn't work for me { FILTER( { FILTER( {TM1FILTERBYLEVEL( { TM1SUBSETALL( [cost centre] ) }, 0 ) }, [cost centre].[company] = "company" ) }, INSTR( 1, [cost centre].[company], "*E*" ) < 1) } i wanna list all cost centres which have company attribute starting with ...

Sorry mate, I still couldn't figure out how to do that.

Cheers

Thanks Paul. Much appreciated.

I will try this tomorrow with the users..

A couple of our TM1 users are having issues with sizing cube views in TM1 since last week. A view can only be either fully minimised or fully maximised and cannot size anything in-between. Do you know how to fix this issue? Any thoughts will be much appreciated? TM1 version : 9.5.2 Excel version : 2...

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

Hi All, I am trying to create a MDX to list all the elements in one of the dimension based on an attribute value starting with something (100). Basically a wildcard search {FILTER( {TM1SUBSETALL( [Task List FC] )}, [Task List FC].[Assembly] = "*301*")} Task List FC is the dimension Assembl...

Ofcourse, I totally agree with you mate...

Sure mate. I will stick to your suggestion using double FILTER as opposed to using AND.

thanks again my friend.

Yes. Thanks again.

You were too quick to post a reply mate. I just tried using the AND in the middle and I got the same result too. Anyway, a big thanks for all your time.

Cheers

Thanks EvgenyT. It works perfect. Much appreciated.

Cheers

Hi All, I am trying to write a MDX statement which should filter by a specific attribute first and then filter by a specific measure element for all values greater than zero. I am getting the syntax error when i did the following. As you all know, error information given by subset editor is not easi...

Can anyone help me on this one please?

Cheers

Guys, Any suggestion will be much appreciated?

Cheers

Hey All, I am experiencing a strange issue in contributor wherein I can't commit data (as a non-admin user anyway, still works fine for admin group users). When I take a ownership of the node which I got write access to in the Architect, it is coming up with the following error (please refer the scr...