Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ctrout1 on 16 Feb 2015 04:56:30 PM

Title: Crosstab returning #!Security in cells
Post by: ctrout1 on 16 Feb 2015 04:56:30 PM
Greetings,

Has anyone had a crosstab return the characters "#!Security" (screen shot attached)?  I am using a PowerCube as my data source and there is Transformer apexing applied to the cube.  However, I have the same apexing applied to other cubes and they function without issue.  Any insight would be greatly appreciated.

Thanks

Title: Re: Crosstab returning #!Security in cells
Post by: bdbits on 17 Feb 2015 09:57:39 AM
That is almost certainly the result of a custom view (e.g. an apex) preventing access to the data. Custom views are always applied all the time. So even if another dimension outside the specific report query also has an apex, that will filter what the user is able to see.

So you might need to (temporarily) remove all the custom views - easy way is to just not include them in the cube properties. If you remove them, does it work as expected?
Title: Re: Crosstab returning #!Security in cells
Post by: ctrout1 on 17 Feb 2015 01:09:56 PM
bdbits,

Thanks, it is definitely related to the custom view.  If the custom views are removed I'm OK.  But I have to have the custom views.  What is strange is that we have 3 other cubes with (what I thought) were identical custom views and they work fine.  So I must have something slightly different with this one cube.  It also seems related to the aggregation (see attached for updated screen shot from Analysis Studio...individual values are fine but aggregate is issue).

Appreciate the feedback.
Title: Re: Crosstab returning #!Security in cells
Post by: bdbits on 17 Feb 2015 05:30:34 PM
Oh I totally understand needing the views, removal was just a troubleshooting step. I guess for me, custom views not working has usually come down to:
* custom view not set properly
* incorrect permissions on the custom view
* forgetting to add the custom view to the cube in the PowerCubes window

If you look at the custom views in the categories window and it appears to be right and shows the categories being filtered, and the custom view is included in the PowerCubes window 'underneath' your cube, I think it would almost have to be permissions to the views. As for the aggregates, sounds like you probably already know that is mostly affected by the type of view (apex, summary, etc). There is also a measures pane in the lower left of the categories window. I am guessing you already know and have looked at these items, but mentioned them just in case.

Sadly, there is no easy way to troubleshoot these issues.
Title: Re: Crosstab returning #!Security in cells
Post by: ctrout1 on 17 Feb 2015 06:22:22 PM
Appreciate your time, I'll keep looking.

Thanks, Cam
Text only | Text with Images