Post reply

Dynamic caolumn Calculations

  • November 26, 2008 at 10:42 am

    #383472

    Hi All

    I need a calculation on dynamic columns, like In layout its one , prodcut, column(measure), when i went to preview there are the prodcut, 5 measure columns.

    How to do the calculation on col 4 and col 5 of measure values...

    Thanks in Advance

    SR

  • November 26, 2008 at 11:04 am

    #903938

    Could you please explain a bit more what you're trying to do? I don't understand the question.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 26, 2008 at 12:00 pm

    #903965

    Hi

    Matrix layout my report: year / ### calculated field

    prodcut sales rev

    preview: Year (2008) calculated filed

    q1 q2 q3 q4 ###

    jackets 12 14 13 15 ### (q4-q3)

    Like this is my report ...here i need is when i select year and no.of qtr (parameter) then

    i need to calculte last two qtr's difference, whatever the last and last but quarters...

    Thanks 3 ur reply

  • November 26, 2008 at 12:07 pm

    #903972

    What does the query for the report look like? Can you do the calculation there?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 26, 2008 at 12:17 pm

    #903979

    My SSRS report on OLAP cube...

    how can we calculate the last 2 qtrs fiffrence dynamically, wheather in OLAP cube / Data tab or somewhere else..pls let me know

    Thanks

    Gail

  • November 26, 2008 at 9:29 pm

    #904130

    http://qa.sqlservercentral.com/articles/T-SQL/63681/

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • November 27, 2008 at 11:50 am

    #904449

    Hi Jeff

    I got your point..here is my MDX query

    select

    [Measures].[Total Days Cash on Hand] ON ROWS,

    LastPeriods

    (5,[Time].[Fiscal].[Fiscal Year].&[2009].&[2]) ON COLUMNS

    FROM

    MyCube

    bu using this i got the result for last five quarters..then i need to create a calculated memeber on the values of last 5th and 4th qtrs...how to do this..

  • November 27, 2008 at 9:43 pm

    #904547

    I've never used MDX queries... that's why I pointed out a traditional cross-tab.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply