Recent Posts

Pages: [1] 2 3 ... 10
1
Administration and Security / Re: Dashboard Dataset Security
« Last post by Zimbo_African_1980 on Today at 03:48:24 pm »
This is awesome, thank you much.
2
Hi All,

I'm using Cognos 11.0.11.  When I try to launch the Help | Learning Center, the page is not found.

Same thing when I copy-paste the URL into a browser on a totally different network.

The URL is http://ibmtvdemo.edgesuite.net/software/analytics/learning-centers/cognos-analytics/index.html   

The 11.0.11 URL for Help | Documentation works though.  :)

Thank you.
3
Administration and Security / Re: Dashboard Dataset Security
« Last post by MFGF on Today at 02:20:22 pm »
Okay, thanks for clarifying.
Can you still let me know how you can apply the security on the Module?

Any links to document or video helps also.

thanks

A

With pleasure! Here's the link to the docs for that:

https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=sources-securing-data

Cheers!

MF.
4
Administration and Security / Re: Dashboard Dataset Security
« Last post by Zimbo_African_1980 on Today at 12:05:10 pm »
Okay, thanks for clarifying.
Can you still let me know how you can apply the security on the Module?

Any links to document or video helps also.

thanks

A
5
Administration and Security / Re: Dashboard Dataset Security
« Last post by MFGF on Today at 11:53:29 am »
Thanks for the detailed explanation, I need exactly the row based data filtering in this case. We have specific records that are only visible to senior leadership.
Do you know how I can implement this security in the data module?
I am assuming I would need another table with security groups right,

thanks again,

A

Hi,

Sorry, looks like I was mistaken. You only appear to be able to define data security if the data module source is a data server, or another source that includes data server tables. I assumed you could do it using a data set as the source, but it appears that isn't possible currently.

Sorry for the misinformation.

Cheers!

MF.
6
Administration and Security / Re: Dashboard Dataset Security
« Last post by Zimbo_African_1980 on Today at 11:20:12 am »
....You can't apply security filters etc directly to a data set, but you could create a data module that references the data set and start applying security within the data module. I'm not clear on what exact security you need to apply, but be aware that currently data modules allow you to define security filters (filtering rows of data based on group/user etc) but they don't support object security (granting/denying access to columns based on group/user etc)......

Thanks for the detailed explanation, I need exactly the row based data filtering in this case. We have specific records that are only visible to senior leadership.
Do you know how I can implement this security in the data module?
I am assuming I would need another table with security groups right,

thanks again,

A
7
Administration and Security / Re: Dashboard Dataset Security
« Last post by bus_pass_man on Today at 10:37:27 am »
Quote
, is it possible to implement security in the dataset

No.

Data sets are essentially a single table and be thought of as a big rectangle of data.  It takes the data which has been put into it by the data set creator and stores it into a new object.

The data set will have that data and metadata which was available to the creator and which he had added to the data set. 

Because it is a new object, it does not inherit the object and data security of the original FM package or data module at run time.

This means that data and metadata, which is available to some set of users but ought not be available to another set, can be exposed to unauthorized users.


8
Administration and Security / Re: Dashboard Dataset Security
« Last post by MFGF on Today at 10:13:58 am »
Hi all,
I have created a dataset that is based on a package with set security and rules. The package security limits access to certain data values that contain sensitive information.
However, it seems like those security settings don't apply to the Dataset.

Am I correct to assume that once you create dataset, it would require its own security setup?
If so, is it possible to implement security in the dataset, and how do I do that?

I appreciate any detail explanation or reference to any article on how this works.

Thanks guys,

A

Hi,

When you create a data set you are pulling the data in to a columnar data file stored in the content store, so the package security rules in place for the user who creates the data set from the package apply at that single point. You can't apply security filters etc directly to a data set, but you could create a data module that references the data set and start applying security within the data module. I'm not clear on what exact security you need to apply, but be aware that currently data modules allow you to define security filters (filtering rows of data based on group/user etc) but they don't support object security (granting/denying access to columns based on group/user etc).

Cheers!

MF.
9
Reporting / Re: report Schedule information in Content store
« Last post by jackson.eyton on Today at 10:02:45 am »
Can't remember where I sourced this information from, but found this in my "handy scripts" folder  :P. It provides a list of all scheduled reports and when they were last run. My recommendation would be to work through each table used to get an understanding of the available data.

Code: [Select]
select
cmobjnames.name as report,
dateadd(millisecond, nc_schedule_queue.run_date % 1000, dateadd(second, nc_schedule_queue.run_date / 1000, '19700101')) as next_run,
dateadd(millisecond, LAST_EXECUTION_AT % 1000, dateadd(second, LAST_EXECUTION_AT/ 1000, '19700101')) as last_run
from
    nc_schedule   
join
    r_taskschedule_schedule
    on r_taskschedule_schedule.fk_schedule_id = nc_schedule.pk_schedule_id
join
    nc_taskschedule
    on nc_taskschedule.pk_taskschedule_id = r_taskschedule_schedule.fk_taskschedule_id
join
    r_newsitems_ncobjects
    on r_newsitems_ncobjects.fk_ncid = nc_taskschedule.fk_task_id
join
    cmobjprops2
    on cmobjprops2.taskid = r_newsitems_ncobjects.nid
join
    cmobjprops26
    on cmobjprops2.cmid = cmobjprops26.cmid
join
    cmobjects a
    on a.cmid=cmobjprops26.cmid
join
    cmobjects b
    on a.pcmid=b.cmid
join
    cmobjnames
    on cmobjnames.cmid=b.cmid
join
    nc_schedule_queue
    on nc_schedule_queue.schedule_id=nc_taskschedule.pk_taskschedule_id

    order by 1


I am curious if this query is still valid, I am gettign an error regarding the NC_SCHEDULE% tables as not existing in the ContentStore database.
10
Administration and Security / Dashboard Dataset Security
« Last post by Zimbo_African_1980 on Today at 08:12:48 am »
Hi all,
I have created a dataset that is based on a package with set security and rules. The package security limits access to certain data values that contain sensitive information.
However, it seems like those security settings don't apply to the Dataset.

Am I correct to assume that once you create dataset, it would require its own security setup?
If so, is it possible to implement security in the dataset, and how do I do that?

I appreciate any detail explanation or reference to any article on how this works.

Thanks guys,

A
Pages: [1] 2 3 ... 10