tag:blogger.com,1999:blog-959725691997997014.post112034816319858957..comments2023-07-18T11:18:29.826+01:00Comments on Cognos Blogger: Dynamic Security in ReportNet & Cognos8Phil Thompsonhttp://www.blogger.com/profile/06916357179657682644noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-959725691997997014.post-60336623340519155682017-03-21T07:26:38.664+00:002017-03-21T07:26:38.664+00:00The security filter will become active once the pa...The security filter will become active once the package the query subject belongs to is published. At runtime when any users with the applicable user class uses a report based on the query subject the query results will be filtered using the filter definition.<br /><a href="http://topassociategs.com/" rel="nofollow">Outsourced investment research</a><br />zionhttps://www.blogger.com/profile/09024374762530426797noreply@blogger.comtag:blogger.com,1999:blog-959725691997997014.post-12510062742357683342016-07-01T15:06:49.495+01:002016-07-01T15:06:49.495+01:00Secure data sharing makes it possible for IT to pr...Secure data sharing makes it possible for IT to provide the anywhere, any-device data access and collaboration people need, while meeting the organization’s requirements for security, manageability, and compliance.<br /><a href="https://www.idealsvdr.com/" rel="nofollow">data room services</a>Anonymoushttps://www.blogger.com/profile/14036616259587055782noreply@blogger.comtag:blogger.com,1999:blog-959725691997997014.post-26037192434243760982013-01-12T12:50:49.398+00:002013-01-12T12:50:49.398+00:00Superb, brilliant weblog structure! I like your bl...Superb, brilliant weblog structure! I like your blog post Dynamic Security in ReportNet & Cognos8 and method of writing,<br /><br /><a href="http://www.ukdissertation.co.uk/" rel="nofollow">ukdissertation.co.uk</a><br />dissertationconsultanthttps://www.blogger.com/profile/07785686573422414588noreply@blogger.comtag:blogger.com,1999:blog-959725691997997014.post-71025481670353288622013-01-12T12:49:59.979+00:002013-01-12T12:49:59.979+00:00This comment has been removed by the author.dissertationconsultanthttps://www.blogger.com/profile/07785686573422414588noreply@blogger.comtag:blogger.com,1999:blog-959725691997997014.post-46595095685280400572009-11-11T17:28:47.696+00:002009-11-11T17:28:47.696+00:00Thanks for your help!
Andy.Thanks for your help!<br /><br />Andy.Unknownhttps://www.blogger.com/profile/18343815866833196748noreply@blogger.comtag:blogger.com,1999:blog-959725691997997014.post-30790389118735980242009-11-09T08:20:12.987+00:002009-11-09T08:20:12.987+00:00Sorry - SQL should read:
select
VIP
from table
g...Sorry - SQL should read:<br /><br />select<br />VIP <br />from table<br />group by vip<br />union<br />select <br />director <br />from table<br />group by director<br />union<br />select <br />dept <br />from table<br />group by deptPhil Thompsonhttps://www.blogger.com/profile/06916357179657682644noreply@blogger.comtag:blogger.com,1999:blog-959725691997997014.post-34958822056092794872009-11-09T08:16:49.971+00:002009-11-09T08:16:49.971+00:00Hi Andy,
to do this you need Report Studio to pro...Hi Andy,<br /><br />to do this you need Report Studio to produce a list in the same structure that you listed in your question (or by running a burst at each level). By the look of your list you have three columns in your source. You need these all in one column. You can do this by creating a union of the columns:<br />select<br /> VIP <br />from table<br />group by vip<br />union<br />select <br /> director <br />from table<br />group by director<br />union<br />select <br /> dept <br />from table<br />group by director<br /><br />The union can be done in the report using three queries, as a sql query or as a query subject in Framework Manager using a query set.<br /><br />best regards<br /><br />PhilPhil Thompsonhttps://www.blogger.com/profile/06916357179657682644noreply@blogger.comtag:blogger.com,1999:blog-959725691997997014.post-74990616724830114342009-11-07T21:52:16.855+00:002009-11-07T21:52:16.855+00:00Hi Phil
Great article.
Question:
I would like t...Hi Phil<br /><br />Great article.<br /><br />Question:<br /><br />I would like to burst based on a hierarchy. Example:<br /><br />VP 1<br /> Director 1<br /> Dept 1<br /> Dept 2<br /> Dept 3<br /> Director 2<br /> Dept 1<br /> Dept 2<br /> Dept 3<br />VP 2<br /> Director 1<br /> Dept 1<br /> Dept 2<br /> Dept 3<br /> Director 2<br /> Dept 1<br /> Dept 2<br /> Dept 3<br /><br />My cognos security rollup is identical to the hierarchy which is in a table.<br /><br />How would I setup the Busrt table to accomplish bursting considering this rollup structure?<br /><br />Thanks very much,<br />Andy.Unknownhttps://www.blogger.com/profile/18343815866833196748noreply@blogger.comtag:blogger.com,1999:blog-959725691997997014.post-11550455195140690502009-09-30T09:53:41.089+01:002009-09-30T09:53:41.089+01:00Hi Joeseph,
You appear to be trying to use the st...Hi Joeseph,<br /><br />You appear to be trying to use the static values 'GA' and 'STG Solution Stack Viewers' in the dynamic function CSVIdentity namelist. If these are valid user groups in the namespace you should set up a new query item (UserGroup) in your query subject that defines the user group:<br /><br />UserGroup:<br />IF (Metadata Layer].[Applications].[PIPELINE_GA] = 'GA' ) THEN ('GA') ELSE ('STG Solution Stack Trusted Viewers')<br /><br />Your filter would then be:<br />[UserGroup] in (#CSVIdentityNameList()# )<br /><br />I hope I have understood the problem you faced in a way that helps. <br /><br />best regards <br /><br />PhilPhil Thompsonhttps://www.blogger.com/profile/06916357179657682644noreply@blogger.comtag:blogger.com,1999:blog-959725691997997014.post-47466392143168318482009-09-29T22:40:50.166+01:002009-09-29T22:40:50.166+01:00hi Phil, we want to control row level access more ...hi Phil, we want to control row level access more dynamically using #CSVIdentifyNameList()# macro. I wrote a condition like this. <br /><br />IF ('STG Solution Stack Trusted Viewers' IN (#CSVIdentityNameList()# ) ) THEN ( [Metadata Layer].[Applications].[PIPELINE_GA] ) ELSE ( [Metadata Layer].[Applications].[PIPELINE_GA] = 'GA' ) <br /><br />but seems not to work.. after IF its showing a red underline. :-))Willy Billyhttps://www.blogger.com/profile/16014893702625637435noreply@blogger.comtag:blogger.com,1999:blog-959725691997997014.post-43830589771467847262008-09-03T14:32:00.000+01:002008-09-03T14:32:00.000+01:00Hi Shyjuk,the report performance will be slower bu...Hi Shyjuk,<BR/>the report performance will be slower but only because it will be waiting slightly longer for a reply from the db.(The db has to decide in the procedure which business view to run). If you are using Teradata I suspect you will hardly notice any difference at all.<BR/>PhilPhil Thompsonhttps://www.blogger.com/profile/06916357179657682644noreply@blogger.comtag:blogger.com,1999:blog-959725691997997014.post-54560530636865281532008-09-03T14:28:00.000+01:002008-09-03T14:28:00.000+01:00Phil, thanks a ton for that quick reply..Is this g...Phil, thanks a ton for that quick reply..Is this gonna take hit on the performance of the report ? If so what do you think would be the bottleneck ?Shyjukhttps://www.blogger.com/profile/10474548233124320568noreply@blogger.comtag:blogger.com,1999:blog-959725691997997014.post-54057193033611761082008-09-03T08:06:00.000+01:002008-09-03T08:06:00.000+01:00Hi Shyjuk, thanks for the question. It's a good on...Hi Shyjuk, thanks for the question. It's a good one and a problem I haven't encountered before. A user's userclass can be captured because it is an environment variable.<BR/>I would approach the problem in this way: Create a PL/SQL procedure which runs one of the business views depending on a parameter. This paramter should be fed to the PL/SQL by adding the procedure into Framework Manager. Once in Framework Manager you can specify that the parameter is populated by the user class environment variable. Remeber that all of the userclasses that the user has membership will be listed so you will need to handle this in your PL/SQL procedure. <BR/>best regards PhilPhil Thompsonhttps://www.blogger.com/profile/06916357179657682644noreply@blogger.comtag:blogger.com,1999:blog-959725691997997014.post-82018664470684989432008-09-03T04:02:00.000+01:002008-09-03T04:02:00.000+01:00We are planning to move from oracle to teradata an...We are planning to move from oracle to teradata and intend to implement the security based on userclass. The Teradata had business views(BV) for different userclass like sales, finance....Is it possible to capture the userid and have cognos choose to run the business views based on user class. like sales user class users..can have access to Sales_BV and when a finance user class user logon the business views to run should be Finance _BV...I would need your idea on this..and appreciate your helpShyjukhttps://www.blogger.com/profile/10474548233124320568noreply@blogger.com