Security Control Problem

[kennyyeungkw]

I have a report which act like a dashboard . The data source is a cube
The cube have apply the data level security by customer view

The report contain 4 chart, 3 charts have right to see it , 1 chart using measure "cost" which some of the user did not contain right to see it .

Problem is if those user open the report, It display the yellow error bar, and can't see anything.Althought he have right to see the first 3 charts .

Management suggest just to take away that chart if no right to see .Is there any way to do it in cognos ?

Also .In Mult-page , if i add the folder that contain report they have no right to see (report may contain measure did not have right),The report tab are still display . Is there a way either to hide tab or display some meaningful message instead of display the yellow error bar when user click the page