Search found 2 matches
- Wed Jun 27, 2018 9:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Is it possible to choose between subsets with IIF-statement in a MDX-subset?
- Replies: 5
- Views: 4548
Re: Is it possible to choose between subsets with IIF-statement in a MDX-subset?
Thanks! The MDX-query is correct now. But it doesn't differ between the members of the Business-dimension. It takes one subset and applies it to all members of the dimension. If I set [AT_Business].CurrentMember.Name = "Wholesaler" it uses the "Wholesales"-subset for all members ...
- Tue Jun 26, 2018 7:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Is it possible to choose between subsets with IIF-statement in a MDX-subset?
- Replies: 5
- Views: 4548
Is it possible to choose between subsets with IIF-statement in a MDX-subset?
Hi! I'm trying to create a dynamic subset using MDX where I want to use different subsets based on elements in another dimension. I have to dimensions: Business - with two elements; store and wholesale Comparison - with five elements; actual, budget, factor, adjustment and adjusted budget. And I wan...