August 4, 2014 at 2:31 pm
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
August 5, 2014 at 1:15 am
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
August 5, 2014 at 1:31 pm
Would shared data sets be possible for reports in different solutions?
Thank you,
Vena
August 5, 2014 at 10:48 pm
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
August 6, 2014 at 12:21 am
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
August 7, 2014 at 9:56 am
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