Recent Posts

Pages: [1] 2 3 ... 10
1
Reporting / Re: Adding team to product based on product name
« Last post by CognosPaul on 23 Feb 2020 08:12:24 pm »
The calculation should not be done in the query at all. That was what I meant when I said page level. Report expressions are processed as the query output is drawn onto the page.

In my crosstab, click on the cell with the calculation and look at the "Source Type". Notice that it is set to "Report expression". When you double click on the row below the report expression editor will open.

In your report, you need to do the same thing. Change the source type to report expression, and add the case statement there. 
2
Reporting / Re: Adding team to product based on product name
« Last post by cognos05 on 22 Feb 2020 08:22:24 pm »
How do i put the report expression at page level.

I have my report with 5 cross tabs and each cross tab has seperate queries,

Now I wanted to add this caption check only to 3 rd crosstab which has a query linked to name T24Query.

In your case there was only 1 query. Putting report expression at page level means, Is it setting that query to Page query .

Right now page query is empty in your report and also in my report.
3
Data Modules / Function to retrieve the modified date of an uploaded file?
« Last post by hdnrs on 22 Feb 2020 02:40:23 pm »
Hello, I’m new here and wanted to check, is there a Function to retrieve the modified date of an updated file? I would like to be able to add it as part of an overall data validation effort. Thanks
4
Administration Lite / Re: Reports getting stuck in Pending Status
« Last post by CognosAdmn on 21 Feb 2020 11:15:51 pm »
We've experienced the same issue after we migrated from Cognos 11.0.7 to 11.1.1, mostly during the first few days of the month.

Initially, we tried "nudging" the Batch Report Service as well, which only resolved the issue temporarily. After a few hours the reports started pending again. We involved IBM Support and they have suggested the following:
Have a separate Notification Store DB.
Increased the "Maximum number of processes for the batch report service during peak period".
Increase "Maximum memory for Websphere Liberty Profile in MB"

Additionally, we noticed the reports and jobs in pending state were triggered after one or more reports or jobs were running for a long time. Improving report run times helped. Also, several jobs were running reports concurrently. Those have been asked to run sequentially.
After about three months of tweaking and testing, we've not encountered the issue during the last two months. (knock on wood)

I hope this helps.
5
Reporting / Re: Count the number of characters
« Last post by adam_mc on 21 Feb 2020 03:11:52 pm »
To use the Length function, I think you have to cast it to a varchar() first.

But, how about this instead so that you can leave it as a number.

case
when [Value] <= 9999 then 'I_Code'
when [Value] <= 999999 then 'MemberID'
when [Value] <= 999999999999 then 'ContactID'
end

This assumes that you only have 4, 6, and 12 digit values.

Hope this helps,
Adam.
6
Reporting / Count the number of characters
« Last post by peewan on 21 Feb 2020 02:40:54 pm »
Hi,
i have a field:
[Value] contains multiple value in it.
If 4 digits long, will be I_Code.
If 6 digits long will be MemberID.
If 12 digits long will be Contact ID.

So I want to count the length of [Value], then use "case...when" to get what i want.

The problems is when I use Length ([Value]), characters_length ([Value]) and it did not work, give me error -9.

Please help. Thanks!

7
Reporting / Re: Pulling in previous weeks data
« Last post by seb24c on 21 Feb 2020 10:39:50 am »
I would test the individual date calculations first--that is, pull out the _add_days() bits into individual data items to see what they're outputting. Running your date calculations today (Fri, 2/21) gives range 2/14-20 (Fri-Thu) for the first expression, and range 2/9-16 (Sun-Sun) for the second, neither of which is what you want.

Do you have the next_day() function available? I think that would be the simplest way to get the appropriate Sat/Fri dates, but it's Oracle so you might not have it (Vendor Specific Functions/Oracle).
8
good that its working.

just curious you did say that your prompt is multi select check box prompt right?
how about if you selected more than one value? does it still work right?

or did you changed your prompt to single select?
9
Report Studio / Re: MTD Last Year
« Last post by dollipi on 21 Feb 2020 05:39:58 am »
Great THX!
10
Report Studio / Re: MTD Last Year
« Last post by BigChris on 21 Feb 2020 05:19:08 am »
[DATE] between _first_of_month(_add_years(current_date,-1)) and _add_years(current_date,-1)
Pages: [1] 2 3 ... 10

       
Twittear