COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: wonko on 26 Jul 2015 01:03:16 AM

Title: Enabling 'Manage External Data' in Cognos Report Studio 10.2.1
Post by: wonko on 26 Jul 2015 01:03:16 AM
Hi,

I'm trying to enable 'Manage External Data' in Cognos Report Studio 10.2.1.

I've tried every option I can think of and scoured the net but no luck.

Has anyone done this on 10.2.1? (I have admin rights to the system.....)

I appreciate any help......

Thanks,
Wonko  :)
Title: Re: Enabling 'Manage External Data' in Cognos Report Studio 10.2.1
Post by: bdbits on 27 Jul 2015 03:15:59 PM
It's a capability under Report Studio, "Allow External Data". As I recall, that is the only thing you need to change.
Title: Re: Enabling 'Manage External Data' in Cognos Report Studio 10.2.1
Post by: MFGF on 27 Jul 2015 04:50:03 PM
You also need to make sure that the package you are using does not have the governor defining the number of external data files set to zero.

Cheers!

MF.


Sent from my iPhone using Tapatalk
Title: Re: Enabling 'Manage External Data' in Cognos Report Studio 10.2.1
Post by: wonko on 27 Jul 2015 05:10:47 PM
Thanks for the replies.  :)

I have full access to both Report Studio & Manage External Data.

But I'm not sure where to find the 'governor' that defines the number of external files?

MFGF, could you explain where that is?

Thanks!
Title: Re: Enabling 'Manage External Data' in Cognos Report Studio 10.2.1
Post by: bdbits on 28 Jul 2015 08:49:54 AM
Not to butt in on the muppet, but in case he's busy muppeting...

Open your package in FM, and go to menu item Project > Governors.

"Maximum personal data sources that can be merged with a model."

The default is 1. I am pretty sure this just means "1 external data source merged at a time", as opposed to only ever being able to merge 1 external data source forever.
Title: Re: Enabling 'Manage External Data' in Cognos Report Studio 10.2.1
Post by: Michael75 on 28 Jul 2015 08:59:23 AM
Should it be useful to the OP, there was a related discussion recently on the Report Studio board: http://www.cognoise.com/index.php/topic,28419.msg91336.html#msg91336 (http://www.cognoise.com/index.php/topic,28419.msg91336.html#msg91336)

in which the muppet came up trumps again.
Title: Re: Enabling 'Manage External Data' in Cognos Report Studio 10.2.1
Post by: wonko on 29 Jul 2015 04:55:27 PM
Thank you all for the replies, but we unfortunately don't have access to FM.....

.....so I think that's where my search ends.   :'(
Title: Re: Enabling 'Manage External Data' in Cognos Report Studio 10.2.1
Post by: BMbabu on 30 Jul 2015 07:59:55 AM
By default this capability is enable who are directory administrators or system administrators, they can work with any package.

But if we need to enable for role or group wise follow the below steps
Check the below User Capabilities :

Cognos Administration > Security > Capabilities
For Report Studio > Set Properties > Permissions
Example: Requested role granted Execute and Traverse
For Allow External Data on Report Studio > Allow External Data > Set Properties > Permissions
Example: Requested role granted Execute and Traverse
If these are already set, follow the steps below.

Steps to add package capability tab on properties, this should be enable every package.

As Administrator can do the below activities.

1.   Select the Set Properties icon on  package name
2.   Select the Capabilities tab
3.   Check the box named "Override the capabilities acquired from the parent entry with:
4.   Select role or groups
5.   Select the check box next to the user or the group and check the grant check box for Allow External Data along with Report Studio.

This should be helpful for you, sure.

Regards,
BMadhu