Great thanks. All working now and have removed the AR reference too.
I wll get there slowly!
Search found 3 matches
- Sun Jun 22, 2014 4:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX code to filter by level and attribute - HELP
- Replies: 4
- Views: 6233
- Sun Jun 22, 2014 4:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX code to filter by level and attribute - HELP
- Replies: 4
- Views: 6233
Re: MDX code to filter by level and attribute - HELP
Thank you for the detailed reply. I tried to record the expression which returned the correct subset but I need the form to update each time you log in but this seemed to return a static subset. I also tried your formula and get and error. Excel highlights the "yes" as being and error =TM1...
- Sun Jun 22, 2014 11:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX code to filter by level and attribute - HELP
- Replies: 4
- Views: 6233
MDX code to filter by level and attribute - HELP
Hi. I am new to MDX (been trying to write new MDX code for only a week) and am struggling to find an MDX code which will return the results of a dimension which has an attribute. I have a dimension called Customer, with a subset called All Parent Customers - Sales Reporting. I usually have to filter...