Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

reuse MDX queries in different reports Expand / Collapse
Author
Message
Posted Monday, August 4, 2014 2:31 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 7:47 AM
Points: 130, Visits: 470
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
Post #1599397
Posted Tuesday, August 5, 2014 1:15 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:34 AM
Points: 12,953, Visits: 10,722
I guess shared datasets are the logical thing to do.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1599495
Posted Tuesday, August 5, 2014 1:31 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 7:47 AM
Points: 130, Visits: 470
Would shared data sets be possible for reports in different solutions?

Thank you,
Vena
Post #1599903
Posted Tuesday, August 5, 2014 10:48 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:20 PM
Points: 2,994, Visits: 2,591
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



Post #1600034
Posted Wednesday, August 6, 2014 12:21 AM This worked for the OP Answer marked as solution


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:34 AM
Points: 12,953, Visits: 10,722
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1600057
Posted Thursday, August 7, 2014 9:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 7:47 AM
Points: 130, Visits: 470
yeah, that makes sense. I think I will go down that route. Thank you very much all :)
Post #1600729
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse