Using a chart from one report in another.

[PJL81]

Hi,

We have multiple packages (Data marts) and i wish to use a chart i created in one package in a report that looks at a different package. Is this possible?

Thanks PJL81

[RKMI]

Hi,

Yes, you can make a template of the chart and then move it to another report jus name the queries the same and don't add any data items/ conditional formatting to the chart object. Once you move the object to the needed report with associated package you can then update the query name/ add data items/ conditional formatting. Hope this helps.

Thanks,
RK

[PJL81]

Thanks RK.

Actually though what i wanted to do was use data from one package in the chart but place it in a report using data from another. For example the main report is finance but the chart will be from an employee data mart.

[RKMI]

Oh for this you need to change how you publish the FM package. If model finance in one model and employee related in another model you need to merge into a common package which will contain both and then point your report to the package which enclosed both.

Note: This is assuming that they come from two different FM models. If it's from the same FM model then you task is a bit easier and just make a package to both finance and employee data set into one.

This solution can get really complex if you have more than one data soruce/ if the tables are similar on different schema. I'm jsut mentioning this since I have faced this in the past where we had financials on a SQL server and then had Orcale for the DW for POS Data consolidation and we needed to report between the two different database and show the results in one report.

Thanks,
RK

[MFGF]

Does it specifically have to be a single report? It would be far easier to create a Workspace and simply drag the chart and the second report in to the workspace next to it.

Just a thought.

MF.

[RKMI]

Yes, I totally agree with MF. That's a easier route, if its only used in like few reports which are simple ( No master detailed relation/ page break reports) create a workspace different objects from more one report into one report irrespective of packages but, its 15+ reports and you want reusablity then you will be better off with the FM approach.

Drawback on using workspace is you can't do with ease create your own queries/ join them, ie. ( show the financial mertics for you sales team employee vs it staff). This can be done ease when they are in one package create a mater detailed relationship.

Thanks,
RK

[PJL81]

Great Thanks guys. I ended up going with a merged package in FM. works fine.