Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: TheHungarian
- Order by date
-
The "case..when..then.." instruction in MDX ?
Yes : http://www.tek-tips.com/viewthread.cfm?qid=1046403&page=2- TheHungarian
- Post #3
- Forum: ODBC/OLAP
-
The case..when..then.. instruction in MDX ?
My problem : I must return only one measure (measures.a) in my columns set and the formula of this calculated measure depends on the current member of the rows set (actually, the current member of {set1}) : select {measures.a} on 0, {crossjoin({set1},{set2})} on 1 from MyCube The easiest way...- TheHungarian
- Post #5
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
The case..when..then.. instruction in MDX ?
Hi, I just cannot find the correct syntax... The idea is to replace several iif() by something like that : with member measures.test as 'case commercial.currentmember.level.ordinal when 1 then measures.quantity when 2 then measures.sales else measures.budget end' select...- TheHungarian
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
The "case..when..then.." instruction in MDX ?
Hi, I just cannot find the correct syntax... The idea is to replace several iif() by something like that : with member measures.test as 'case commercial.currentmember.level.ordinal when 1 then measures.quantity when 2 then measures.sales else measures.budget end' select...- TheHungarian
- Thread
- Replies: 2
- Forum: ODBC/OLAP
-
MDX syntax problem
I don't see why you chose to create such a calculated member but maybe you could try this : =iif(flow_type.currentmember=0,measures.quantity,null)- TheHungarian
- Post #2
- Forum: ODBC/OLAP
