Dynamic subset in TM1

[phathoang149]

Hello everyone
I want create dynamic subset.

I Have [Cube 1] and [Cube 2] the same image:


I Want create dynamic subset for [number] demention by expresstion window MDX
Purpose: when I select A in CUBE 2, CUBE 2 only dislay [number]: 1,2,4,6,8,10 as data from CUBE 1

When I select B in CUBE 2, CUBE 2 only dislay [number]: 3,5,7,9,10 as data from CUBE 1
Thanks

[phathoang149]

Help me! Please

[Wim Gielis]

Help me create dynamic subset.

Is this a command, or do you have a friendly question?

Help me! I'm really Worry.

You mean "worried" ?
And why? it is only TM1, it's not about life and death.

Did you pay attention to the forum rules? And to other general etiquette at online forums?
It's inappropriate to USE CAPITALIZED LETTERS. IT LOOKS LIKE YOU ARE SCREAMING, ISN'T IT ?
Why do you put "HELP ME" in the topic title? Do you think you will be better served?

By the way, most people enjoy their weekend, forum activity is quite low. Bumping is not needed.

In the meantime, what did you do to solve your own question?

[phathoang149]

Help me create dynamic subset.

Is this a command, or do you have a friendly question?

Help me! I'm really Worry.

You mean "worried" ?
And why? it is only TM1, it's not about life and death.

Did you pay attention to the forum rules? And to other general etiquette at online forums?
It's inappropriate to USE CAPITALIZED LETTERS. IT LOOKS LIKE YOU ARE SCREAMING, ISN'T IT ?
Why do you put "HELP ME" in the topic title? Do you think you will be better served?

By the way, most people enjoy their weekend, forum activity is quite low. Bumping is not needed.

In the meantime, what did you do to solve your own question?

Thanks your command,If you know my problem, please help me! Thanks so much!

[java_to_tm1]

Seems to me that static subsets should do the job?

Open subset editor, select the elements you want ( 1,2,4,6,8,10), remove other elements, and save the subset as A.
Rinse and repeat for subset B.

Why would you need "dynamic" subsets for this?

[phathoang149]

Seems to me that static subsets should do the job?

Open subset editor, select the elements you want ( 1,2,4,6,8,10), remove other elements, and save the subset as A.
Rinse and repeat for subset B.

Why would you need "dynamic" subsets for this?

Thanks your command.
- IF I use static subset, I can't autoupdate element when i insert element number in dimension. And can't filter number when I select A or B in cube 2.

But my problem is:
- I create 1 dynamic subset is name [Dynamic A] with MDX

- I create view in Cube 2 use subset [Dynamic A]
- When i select A, number dislay 1,2,4,6,8,10 as image

-But when i select B,number dislay 1,2,4,6,8 ,10 not 3,5,7,9. In cube 1 numer for type B is 3,5,7,9


can you help me only 1 dynamic subset i can filter A, B in cube 1 when I select A or B in cube 2. Thanks so much.

[lotsaram]

Have you tried using the CurrentMember property of the "Type" dimension? As long as the element name is an exact match to the cube cell value and not an alias then I see no reason why this shouldn't work.

[phathoang149]

Have you tried using the CurrentMember property of the "Type" dimension? As long as the element name is an exact match to the cube cell value and not an alias then I see no reason why this shouldn't work.

I don't understand your idea. You can help me MDX? Thanks you so much!

[BariAbdul]

Hi phathoang149 ,This is very good MDX resource/doc,Please go through it.

http://goo.gl/hN9j4R

Thanks

[phathoang149]

Hi phathoang149 ,This is very good MDX resource/doc,Please go through it.

http://goo.gl/hN9j4R

Thanks

I read it, but i can't solve my problem, help me?

[declanr]

Hi phathoang149 ,This is very good MDX resource/doc,Please go through it.

http://goo.gl/hN9j4R

Thanks

I read it, but i can't solve my problem, help me?

Your MDX query is almost dynamic in the way you want it but the "A" is hardcoded... so you need to make the A dynamic... Lotsaram has directed you to the currentmember function and BariAbdul has directed you to a comprehensive explanation of TM1 MDX. You have all the pieces you need, now you just need to slot them together - what have you tried since receiving these 2 pieces of information?

[tomok]

If Cube A was an attribute cube, instead of a regular cube, then it would be quite easy and your MDX would look something like:

Code: Select all

{FILTER( {TM1SUBSETALL( [Number] )}, [Number].[Type] = [Type].CurrentMember)}

You may have to play with the syntax but the concept should work.