Page 1 of 1

create report filters that are cascading

Posted: Fri Sep 04, 2020 10:30 am
by samiamsz
can someone help me
I have to create a subset using an mdx
i have to write a TI process that creates subsets for each level
I am new to this so sorry for the basic question
Basically i have three drop downs, 1 is a category director, 1 is category, and the last is category use.
I have to create a dynamic subset where when i select an element from the category director(the root elements) the next drop down, category, must only contain elements thatre the children and when i choose something from category the next drop down category_use must only contain the drop down of the above
please pm me as well if you csan help me write the ti process pleaaase

Re: create report filters that are cascading

Posted: Fri Sep 04, 2020 11:28 am
by Steve Rowe
Hi Samiamsz, Please do not create multiple posts for the same issue, I have deleted your other posts.

How far have you got with implementing your solution and have you read the FAQ for requesting help?

I'd suggest that you attempt a solution yourself and ask specific questions on issues you encounter, it's unlikely anyone will give you the full solution to your problem.

As well as TM1s help on the various functions suggest you review the "MDX Primer for TM1"

Re: create report filters that are cascading

Posted: Fri Sep 04, 2020 11:55 am
by samiamsz
I appreciate the response,
I am pretty new to this so i apologize for the ignorance
however, I did make progress with it and i think i was able to complete what i wanted

Re: create report filters that are cascading

Posted: Fri Sep 04, 2020 2:00 pm
by lotsaram
samiamsz wrote: Fri Sep 04, 2020 11:55 am I appreciate the response,
I am pretty new to this so i apologize for the ignorance
however, I did make progress with it and i think i was able to complete what i wanted
You may be new to Planning Analytics and this forum but not spraying the same question on multiple threads is just basic netiquette and common sense. If you want people to help you don't annoy them, follow the rules, be polite, explain what steps you already did to solve the issue, etc.
Good luck.