If you are unable to create a new account, please email support@bspsoftware.com

Recent Posts

Pages: [1] 2 3 ... 10
1
Report Studio / Report Studio Change UTC Time Zone in Filename
« Last post by pmason44 on 29 Sep 2023 12:07:06 pm »
I have an issue where the timestamp that's appended to a saved file report name is in the UTC timezone. I'm specifically referring to files (versions of reports) saved in the report studio. Everything else displayed in report studio has the correct time zone - e.g. created and modified times on reports, scheduled times. Wondering if this value is coming from the cognos database? Does anyone know how to change the time zone? We are running IBM Cognos Analytics version 11.0.12. Please let me know of any other information needed.
2
Administration and Security / How to Export the list of Cognos Users and when they were granted the Licenses
« Last post by Kiran Kandavalli on 27 Sep 2023 10:04:38 am »
Team,

I am looking to export the list of Cognos Users and when they were granted the Licenses. Is there any way that we can do this in Cognos Administration?

Thanks!
Kiran
3
Administration and Security / RSVP.EXCEL.NUMBEREDSHEETNAMES not working in Cognos 11.1.6
« Last post by Kavya on 26 Sep 2023 11:58:49 pm »
Hi,

I have updated RSVP.EXCEL.NUMBEREDSHEETNAMES setting to FALSE for Report Service, Batch Report Service and Report Data Service. We have three dispatchers. I have added this setting on all three servers.
This same setting is working in Cognos 10.2.1. But, not in 11.1.6

I did restart services after making this settings change. But, no luck. What else am I missing ? Did anyone see this issue ?
4
General Discussion & Gossip / MOVED: Dynamic sorting
« Last post by MFGF on 26 Sep 2023 11:38:42 am »
This topic has been moved to Report Studio.

https://www.cognoise.com/index.php?topic=37950.0
5
Dashboards / Re: Anyway to reuse a visualization authored in Dashboard as input to build aReport?
« Last post by MFGF on 26 Sep 2023 11:37:38 am »
Quote from: FerdH4 on 22 Sep 2023 07:43:12 am
For example, if a Dashboard Author successfully built one fab v11.2 visualization, is there any way for them to reuse that same object to build a Cognos Report without rebuilding the Report from scratch?

If you mean the entire dashboard layout and contents, then no - dashboards and reports have different internal structures (JSON vs XML). There's also an added complication that dashboards can be based directly on an uploaded file, whereas reports cannot - the file needs to be modelled in a Data Module to be able to use it in a report. However, as long as the dashboard is based on something a report can use as a data source (data module or package), you can copy and paste the visualizations from a dashboard to a report (you can multi-select them in the dashboard and paste them all in one go). To copy, use <ctrl>c and to paste, use <ctrl>v. You don't get the layout, though - you will end up with all the visualizations stacked next to each other. It would be great to be able to take an entire dashboard including the layout and save it as the start point for a report, but as of right now, it's not something the product permits.

Cheers!

MF.
6
Reporting / Calendar Dimension (Weekly) excel spreadsheet
« Last post by Neo310 on 26 Sep 2023 07:46:47 am »
I need to create a report that breaks data down by WEEKS.  My date dimension only has months.  I don't want to manually create week calculations.  Instead, i want to create a data module linked to an excel spreadsheet that has the date dimension (year, month, week).  Does anyone have an excel file that has this information in it already? 

Thank you
7
Administration and Security / Re: Disable / Hide ability to browse "Directory" when scheduling reports
« Last post by cognostechie on 25 Sep 2023 12:38:39 pm »
Quote from: gohabsgo on 22 Sep 2023 01:32:58 pm
Solved my own problem!

Figure I'll leave this here in case others hit it.

https://www.ibm.com/support/pages/how-restrict-users-when-selecting-email-recipients

Thanks for sharing !
8
Administration and Security / Re: Disable / Hide ability to browse "Directory" when scheduling reports
« Last post by dougp on 25 Sep 2023 11:09:36 am »
That's an eye opener.  A little disturbing, actually.  Early on in my Cognos experience I heard that "Cognos is all about security."  So I figured that would be a default setting that can't be overridden.  But I never tested it.
9
Administration and Security / Re: Disable / Hide ability to browse "Directory" when scheduling reports
« Last post by gohabsgo on 22 Sep 2023 01:32:58 pm »
Solved my own problem!

Figure I'll leave this here in case others hit it.

https://www.ibm.com/support/pages/how-restrict-users-when-selecting-email-recipients
10
Administration and Security / Disable / Hide ability to browse "Directory" when scheduling reports
« Last post by gohabsgo on 22 Sep 2023 11:15:25 am »
Hi Folks,
We would like to either disable or hide the ability to browse the "Directory Namespace" when selecting recipients for scheduled reports.

I've tried removing traverse/read access to the namespace object, but then they can't login.  We have multiple user communities in the namespace and dont want them being able to see the user list.

Restricting them to just entering the email of recipients manually is where we want to be.

Thanks in advance,
-Dan
Pages: [1] 2 3 ... 10
BSP Software Articles
Populating Framework Manager Descriptions from SQL Server Extended Properties
Performance Monitoring in MetaManager™

BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite ExitCertified - Cognos Training