Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
prashantpatil
Starting Member
5 Posts |
 Posted - 2012-07-25 : 02:48:26
|
| Hi all,I am trying to create calculated member [Proj Count - Var] which will count all projects having [variance %] < 0. And then browsing it with Project hierarchy.Problem :[Proj Count - Var] gives same results for all [Businees units] which are 1 level up than project in project hierarchy.the MDX I tried is,with member [proj Count - Var] as count( Filter([Project].[project],[Measures].[ITD Variance GP %] < 0)) select {[proj Count - Var],[Measures].[ITD Variance GP %]} on 0,[Project].[-Operating Group-].[Business Unit].members on 1 from finance;and if i use excludeempty in count than it gives #error for each business units,with member [proj Count - Var] as count( Filter([Project].[project].members,[Measures].[ITD Variance GP %] < 0),excludeempty) select {[proj Count - Var],[Measures].[ITD Variance GP %]} on 0,[Project].[-Operating Group-].[Business unit].members on 1 from finance;Please let me know if you have any idea about what I am missing.Prashantpatil |
|
|
prashantpatil
Starting Member
5 Posts |
Posted - 2012-08-07 : 07:17:15
|
| I got the issue, I need to add "existing" keyword. |
 |
|
|
|
|
|
MDX - Count func giving #error