Recent Posts

Pages: [1] 2 3 ... 10
1
Presently Cognos 11 only allows me to create pins and use them for myself. My client asked me to create pins and make these pins available to business users. By this way, such users will be able to drag the pinned objects to the dashboard from pin panel. Business users do not have knowledge with data warehouse or DMR and they could only use the pins as Widgets without need to configure that connection or select the data elements.

Any help would be greatly appreciated.

Jamie
3
Hi MF,

I am using Cognos 11.0.11, can we pass the Active Report Variable to a Report Studio Report.

I am using Year & Month as Data Drop down lists in the Active Report and I need to pass those year & month selection to the Report Studio Report using Drill through and filter the records.

Thanks!
Kiran
4
Administration and Security / Re: Cognos 11 Trigger Report through cmd
« Last post by zgeorge on Today at 08:10:20 am »
I've found this error in our log files if this help anyone.

CNC-DS-0001 The following Delivery Service general error occurred: DLS.CogConfigRestClient com.ibm.jsse2.util.h: PKIX path building failed: java.security.cert.CertPathBuilderException: PKIXCertPathBuilderImpl could not build a valid CertPath.; internal cause is:     java.security.cert.CertPathValidatorException: The certificate issued by CN=ABCD Root CA2 is not trusted; internal cause is:     java.security.cert.CertPathValidatorException: Certificate chaining error

Thanks for the help!
5
I also see the Insertable Objects tab when I create a new report. The problem is that I don't see the attached icon*

Hence, when users access an EXISTING report through the design/preview mode, they don't know how to see the Source/Tools sections
6
Reporting / Dimensional Reporting - Date Range in the prompt page
« Last post by bwalikar on Today at 02:40:07 am »
Hi all,

Need your help with following scenario in the cube based report :

Source : Cube
Requirement : User can select a Date Range in the prompt page ( From Date , To Date)
Report list should show data for
Column 1 = Selected Date Range
Column 2  = (From Date - 7 days) to (To Date - 7 days)
Column 3  = From Date last year - To Date last year.
Column 4 = % change between Column 1 and Column 3

I believe to show all these columns on a single list we need to have a single final query. Can you please on how this can be achieved using the dimensional functions.

Any help is highly appreciated !
7
Cognos Administration / Re: MS SQL OLE DB vs. MS SQL Native Client
« Last post by Mfg on 14 Feb 2019 11:02:12 pm »
Hello There,

Environments:
I have 2 environments. Audit DB has been configured. Type of DB
1. SQL Server
2. SQL Server

Audit data source:
1. MS SQL Server OLE DB
2. MS SQL Server 2008 Native Client

Audit Package:
1. Published in CQM
2. Published in CQM

Issue:
SQL Server function CharIndex
1. MS SQL Server OLE DB ( Working Fine )
2. MS SQL Server 2008 Native Client ( Throwing following error)

Expression Used:
SELECT SUBSTRING
(cogipf_package, CHARINDEX('''',cogipf_package) + 1,
CHARINDEX('''',cogipf_package, CHARINDEX('''',cogipf_package) + 1) - (CHARINDEX('''',cogipf_package) + 1) ) app_name
FROM cogipf_runreport COGIPF_RUNREPORT

Error:
RQP-DEF-0177
An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.UDA-SQL-0115 Inappropriate SQL request.UDA-SQL-0564 [Microsoft SQL Server Native Client 10.0]Invalid length parameter passed to the LEFT or SUBSTRING function.

Any suggestions :-[

thanks in advance.
8
This may be permissions or language related.

We have 11.1 R1 as well and do not have this issue. We are using EN and I am an admin on the system.

I have attached what I see when I first open up a report after I select the generic template.

Datasource tab / insertable objects tab is open already. Nothing hidden.
9
Administration and Security / Re: Cognos 11 Trigger Report through cmd
« Last post by zgeorge on 14 Feb 2019 11:34:53 am »
Thank you but I'm calling the same command, same trigger both times nothing changes.
10
Reporting / Source/Tools icons don't appear in page design/page preview
« Last post by Francus81 on 14 Feb 2019 10:39:33 am »
Hi, I recently upgraded CA to version 11.1 R1. I found an issue in reports.  When you are seeing the report in page design/preview mode, the icons of Source, Data Ítems and Tools are not visible at first view.

I discovered that there is a "hidden" icon below the Home icon. When you mouse over this "hidden" icon, a tag called "Insertable objects" appears. After clicking it, the icons of Source,Data Items and Tools finally are visible.

This is a problem for new users or those who seldom use the reports. Is it possible to edit that "hidden" area in order to show some icon? Does anyone has the same issue?

*I attached an image with the issue.

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

       
Twittear