locked
Strange behaviour between Client side and server side components, PAS, and Proclarity RRS feed

  • Question

  • We've noticed strange behaviour with some of our MDX custom rollups since migrating from AS 2005 to AS 2008.

    The data grid looks like this in 2005 (client or server), and when run with PAS web pro/std or desktop client side with AS 2008

      Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9
    2007 1 4 5 7 9 10 12 22 23
    2008 4 6 8 10 10
    2009 3                

    when the script runs server side on 2008 we get the following result set.

      Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9
    2007 1 4 5 7 9 10 12 22 23
    2008 4 6 8 10 10 0 0 0 0
    2009 3 0 0 0 0 0 0 0 0

    I'm not sure why we're seeing this behaviour, and I'm unsure if this is a PAS/Desktop issue or an AS issue.

    The server specs are windows 2003 64bit for the AS box (64bit windows both 2005 and 2008) with the latest service packs applied.  The PAS box is a windows 2003 32bit, and both PAS and desktop are version 6.3.2217.188.

    TIA
    Jason
    Thursday, July 30, 2009 10:54 AM

All replies

  • Hi Jason,

    It looks like one of the two grids is set to show 0 values where the other is hiding them (default).  What you can try doing is go to the grid properties and see if custom formatting is set.  Do both views have their format set to custom wtih the 'Display Zero Values' box checked?

    Hth,
    Sean
    Microsoft ProClarity | This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, August 4, 2009 1:42 PM