Home Forums Reporting Services Reporting Services 2008/R2 Administration Recuperantion des données pour certains dimensions RE: Recuperantion des données pour certains dimensions

  • November 4, 2016 at 11:54 am

    #1910683

    Luis Cazares (11/4/2016)

    Jeff Moden (11/3/2016)

    Luis Cazares (11/3/2016)

    I believe that you understood correctly, except for the part that the OP needs to get the MDX query instead of T-SQL.

    I know it's possible but my skills on MDX are just enough to understand it, but not create new code.

    Perhaps the op can translate SQL to MDX. 😉

    I'm not sure if it's that easy. It also depends on how the time dimension is built. There's an option for previous member which can be used if the dimension has year as part of the hierarchy.

    I was expressing a bit of irony. 😉

    --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)