CALCULATION on the PPS data grid - PPS RRS feed

  • Question

  • Scenario :

    I have a PPS Analytic Grid
    Col 1
    Col 2
    Col 3
    Col 4

    Col 1 - has the dimenison
    Col 2 - this year profit
    Col 3 - last years profit

    Col 4 - i want to show the diff

    Can i write numerical calculations in Col 4 using a Analytical Grid 


    Wednesday, June 3, 2009 1:05 PM

All replies

  • Hi,

      You could try achieving this by creating a calculated member in the cube and reference this member in the report.

    • Proposed as answer by Ramakrishnan.lh Wednesday, June 3, 2009 5:04 PM
    • Unproposed as answer by Abhs Friday, June 19, 2009 5:56 PM
    Wednesday, June 3, 2009 1:40 PM
  • What if the Col 3 is dynamic - i mean it can be last year's profit - or can be last to last year and hence depending on the year the user selects in the filter

    How can i show the diff of the two years profit - in the 4th coloumn?


    Friday, June 19, 2009 5:57 PM
  • This can all be dynamic based on the selection the user makes.  Take a look at time intelligence features within the cube and you can also take a look at a project by Marco Russo - DateTool dimension: an alternative Time Intelligence implementation for how to setup what is known as a shell dimension and setup the SCOPE statements in the cube to perform this functionality.
    Dan English's BI Blog
    Please mark posts as answer or helpful when they are.
    Saturday, August 1, 2009 2:18 PM