reuse MDX queries in different reports

  • Hi ,

    We have different reports which have cascading parameters using MDX. Some Datasets used by parameters are in Oracle an others are in MDX. We use stored procedures for the parameters that get the data from oracle. Is there anything similar for reusing the MDX queries in parameters for different reports?

    If there is more than one ways of doing it, are there any pros and cons to it?

    Thank you,

    vena

  • I guess shared datasets are the logical thing to do.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Would shared data sets be possible for reports in different solutions?

    Thank you,

    Vena

  • Firstly - I haven't done this as yet but...

    They should be - in the project properties, you set the folder that you want to deploy shared datasets to. So, if all projects are using the same folder, then you at least have a chance of making this work

  • happycat59 (8/5/2014)


    Firstly - I haven't done this as yet but...

    They should be - in the project properties, you set the folder that you want to deploy shared datasets to. So, if all projects are using the same folder, then you at least have a chance of making this work

    Indeed. On the server it wouldn't make a difference. In Visual Studio however, you would have to add the shared datasets to every solution.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • yeah, that makes sense. I think I will go down that route. Thank you very much all 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

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