Hi All,
I have a problem with the prompts and filters.I have a hierarchy,country-region-city etc and we set preferences for the head of each level in narrowcast to get the personalized report.For a country head, I have to display all the regions(one level below country) in a country and metrics on template and should have the country element in the filter.If it is a region head, then I should have region element in filter and cities(one level below region) of a region in the template.The report should be a general one and the filter elements and the template changes depending on the head of the level in hierarchy.Can anyone give me some suggestions on this. Thank you all.
mstms
I have a problem with the prompts and filters.I have a hierarchy,country-region-city etc and we set preferences for the head of each level in narrowcast to get the personalized report.For a country head, I have to display all the regions(one level below country) in a country and metrics on template and should have the country element in the filter.If it is a region head, then I should have region element in filter and cities(one level below region) of a region in the template.The report should be a general one and the filter elements and the template changes depending on the head of the level in hierarchy.Can anyone give me some suggestions on this. Thank you all.
mstms