Search found 2 matches

by wns@rav.no
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 ...
by wns@rav.no
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...