sql server - Report Action Condition Appears to intermittently Evaluate False -

i have ssas 2012 cube, has report action. action should conditionally available, based on user being required select specific scenario.

the action works fine, problem i'm having condition have defined action works most of time.

while browsing cube in excel, if add activity (a measure) values, , put scenario across columns, long right click activity cell (excluding grand total), action available expected. couple columns of example data appear:

            2010 actuals    2011 actuals activity    -13,812,430     11,938,733 

while browsing cube, if, in addition above configuration, put account hierarchy on rows, , expand lowest level, action not available cells, while available others. couple columns of example data appear:

row labels  2010 actuals    2011 actuals 123 - abc   -1,889          41,251 456 - def   -562,243       -2,053,282 789 - ghi   -25,000        -12,454 

since action condition requires specific scenario selected (2010 actuals, 2011 actuals, ect), expect right clicking on of measure values in example data have action available. action available 5 of 6 cells, not available 456 - def 2011 actuals. what cause this?

the condition mdx in action is:

[scenario].[sa - scenario].currentmember <> [scenario].[sa - scenario].[all]

while running sql profiler, if right click cell behaves correctly, , click 'show details', mdx gets sent is:

    drillthrough maxrows      1000 select [somename]      ([measures].[activity]     ,[account].[a1 - level 1].[level 1].&[balance sheet].&[assets].&[current assets].&[cash].&[cash in bank].&[456 - def]     ,[scenario].[sa - scenario].[scenario].&[79]) 

if click cell not have action available, mdx sent is:

    drillthrough maxrows      1000 select [somename]      ([measures].[activity]     ,[account].[a1 - level 1].[level 1].&[balance sheet].&[assets].&[current assets].&[cash].&[cash in bank].&[456 - def]     ,[scenario].[sa - scenario].[scenario].&[80]) 

the difference between mdx sent cells appears scenario value, believe correct, since we're selecting same member account, different scenario. in 1 case, condition appears evaluate true, while in second case appears evaluate false, since action not available.

admittedly, i'm not mdx. however, since most of time action available, believe expression valid , works, otherwise, action should never available. (this case when put in bogus condition).

as sanity check, if set mdx condition true, action available 1 expect. if switch out account dimension, , drill lowest level, cannot reproduce this. appears related somehow members, scenarios, under lowest account level.

i've looked @ how account dimension set up, compared other dimensions, , don't see jumps out @ me being different structure wise.

what else cause behavior have not yet looked into?

your expression evaluate measure current scenario , grand total , compare 2 numbers:

[scenario].[sa - scenario].currentmember <> [scenario].[sa - scenario].[all] 

try following:

not ([scenario].[sa - scenario].currentmember [scenario].[sa - scenario].[all])