none
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 

    Thanks
    Sen.

    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.

     regards,
    Ram
    • 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?

    Thanks

    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