Report with National Average

[cognos05]

Hi ,

I am not sure this completely related to reporting .

I have reports built on cognos cube which is based on cognos transformer .


The security is at rep level where the rep sees only their data .

DImension is hierarchical and has regions-agency -reps

Say suppose i want to build a report with rep sales compared to its agency or regional sales , how can i create it , because the transformer securtiy will restrict reps access to rep level .


So if I  need to use any national average or other numbers is it even posssible .

Thanks,

[MFGF]

Hi ,

I am not sure this completely related to reporting .

I have reports built on cognos cube which is based on cognos transformer .


The security is at rep level where the rep sees only their data .

DImension is hierarchical and has regions-agency -reps

Say suppose i want to build a report with rep sales compared to its agency or regional sales , how can i create it , because the transformer securtiy will restrict reps access to rep level .


So if I  need to use any national average or other numbers is it even posssible .

Thanks,

Hi,

The cube needs to be designed to support this. If the security currently restricts viewing of data to an individual rep, you'd need to review that security and allow measures to be aggregated even though the categories are not visible (ie use Cloak).

Cheers!

MF.