COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: mbomabe on 21 Feb 2014 05:15:02 AM

Title: Maps - Report Studio
Post by: mbomabe on 21 Feb 2014 05:15:02 AM
Hi, Anyone knows how to setup a Master-Detail relationship between a map and an another object, as a List. The master would be the map and the detail will be the detail. It works when I use a Active Report, using a deck, but I wanna use in the standard report.

  Best regards,

      marcelo
Title: Re: Maps - Report Studio
Post by: Raghuvir on 21 Feb 2014 06:16:24 AM
Hi,

if u want to bet redirected to a detailed report, u should use drill through definitions.

just try it once and check if u have the desired output.

Title: Re: Maps - Report Studio
Post by: MFGF on 21 Feb 2014 08:29:23 AM
Hi,

You can embed a map within a list, but not a list within a map. This means the list will always be the master and the map will be the detail.

Drilling through (as suggested) seems to be the solution you need here.

Regards,

MF.
Title: Re: Maps - Report Studio
Post by: mbomabe on 21 Feb 2014 10:49:43 AM
So, the objective of the report is when the user click in a state on the map, the list is filtered by this state. In active reports works, but in standard report ( no active report ) the master-detail option in list is not available. I know that in Active Reports works cause the map and the list are inside a Deck, but there isn't a Deck object in standard reports.
Title: Re: Maps - Report Studio
Post by: MFGF on 21 Feb 2014 11:27:37 AM
Hi,

You can't have a map as a master in a master/detail relationship. In your Active Report you are filtering a list based on the selection made from the map, but the map isn't a master query. To achieve similar functionality in a non-Active Report you will need to set up a drill-through definition from the map to pass the selected region value. Your drill-through target will be the same report, and your list will be filtered based on a region parameter. You can either hide the list using conditional rendering when the report is first run, or you can define a default value for the parameter which corresponds to all regions.

There are a few posts on here that discuss drilling through to the same report, if memory serves. Do a search and take a look at the recommendations. Come back to us if you get stuck.

Good luck!

MF.