Recent Posts

Pages: [1] 2 3 ... 10
1
Reporting / Re: Extra header
« Last post by NiceCube on Today at 02:39:45 am »
Hi Manias - I've just tried that, with the same result; cell A1 contains a '1'.  The default blank report has no header thus, sadly, it's not that.
2
Report Studio / Fiscal Date difference Calculation
« Last post by Thanay on 23 Apr 2017 07:40:53 am »
Hi Techies,

I have a requirement to calculate the difference for fiscal dates. means, i have a list report. it contains all dates with the measures. so i need to find the difference of the fiscal dates as below

date              measure         fiscal_percentage
---------------------------------------------------------------
12-07-14        1500           
26-07-14        5000           
11-07-15        500              1000 (first date - third date)
25-07-15        3000            2000 (second date - fourth date)


Please suggest me.

Thanks in advance

       
3
Report Studio / Re: Need to find the minimum date measure in list report
« Last post by Thanay on 23 Apr 2017 07:27:26 am »
Thanks MFGF,

It must work, But in my scenario, it is summing up wrongly. So, i used different way to achieve this using running_difference and running_total functions.

Thanks for the reply
4
hi MF:

    My cognos is 10.1.1 version, it didn't have jdbc select item.
5
Reporting / joined query
« Last post by phillipk on 22 Apr 2017 04:16:58 pm »
I have several joined queries in an existing report in cognos 11.  I cannot see the source data items when I click on the joined query.  I can with a union query, but not the regular join.
6
Cognos Administration / User Deactivation
« Last post by parvesh.rishi on 22 Apr 2017 01:33:40 am »
Dear All,
I have a monthly task of deactivating multiple users from Cognos 10.2.2 portal which I have to do manually one by one.
It is a time taking and boring process.
Hence I want to automate this task by taking help of Cognos Content Store.
I have seen tables that contain some information concerning users, groups,roles, etc.. and those tables are:
CMOBJPROPS1
CMOBJPROPS33
Now I am deleting entries from these tables but that does not affect the user on the portal.
Please suggest what could be the possible solution for this problem.
Thank you!!
7
IF1 is supposed to add support for Excel 2016, and it does work but only for brand new spreadsheets.  When opening spreadsheets that have existing links to reports/queries, they do not appear in the plugin.  This is a serious problem for us as we'd have to relink many existing spreadsheets.

Wondering if anyone else has encountered this problem.
9
Hello Gurus,
Does anyone know if this is a known issue in Cognos 10.2.2 or if there is a work-around?  Here's the requirement:

The Inventory Report generates a 2-4 page report for each of the Product Categories, page breaking for each Product Category.  The business would like to print the PDF output on double-sided paper, but we would need to force a blank page for a report that was only 3 pages long so that the back side of page 3 is blank and NOT the first page of the next Product Category report.

They currently run the report for 1 Product Category at a time so that it can be printed double-sided without impacting the next Product Category report.  Bursting would also be tedious as they would have to go and print each one individually.

I've read several forum postings that it appear the Render Variable for PDF output doesn't work with the PageNumber() function.  I can display the same Variable expression on the 'blank page' but it seems the variable isn't holding the value. 
I've tried using a Boolean Variable:  mod (PageNumber () , 2 )   
As well as a String Variable: If ( mod (PageNumber () , 2 ) = 0 ) then ('Y') else ('N')

The 'blank page' renders whether the calculation for the variable returns 1 or 0 (or 'Y'/'N').  Any thoughts? 


10
Report Studio / Re: Trim function or truncate variable length of string
« Last post by ry1633 on 21 Apr 2017 10:36:55 am »
just for future reference,  my DBA did this in Oracle, and I tried it in Cognos as an alternative.  I didn't think that Cognos supported any of the Oracle REGEXP functions, but apparently this does work also in Cognos.

REGEXP_SUBSTR ([Data Item] , '[^;]*')

Is this any better than using the Case statement; or is it just a different way of accomplishing the same thing?
Pages: [1] 2 3 ... 10

           
Twittear