Post reply

Parameterised MDX

  • September 23, 2008 at 3:00 am

    #194039

    Hi,

    can anyone give some example scripts on Parameterised MDX query.

    Thanks

    Regards

    Viji

  • September 25, 2008 at 5:24 pm

    #877392

    One way

    Pass the whole MDX as a string, embedding the parameters

    ="SELECT NON EMPTY { [Measures].[Land Area Controlled] } ON COLUMNS, NON EMPTY CROSSJOIN ( {" & Join(Parameters!Developer.Value,",") &"}, {DESCENDANTS( [Location].[Country].[" + Parameters!Country.Value + "], [Location].[Market])}) ON ROWS FROM [QMSLand] WHERE ( [Time].[Quarter].[" + Parameters!Quarter.Value + "])"

    Another way

    Set up a parameterised query in the MDX query builder and take a look at the MDX it produces 🙂

    Kind Regards, Will

  • September 26, 2008 at 1:12 am

    #877459

    Thanks,

    I'll try it.

    Regards

    Viji

Viewing 3 posts - 1 through 2 (of 2 total)

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