Recent Posts

Pages: [1] 2 3 ... 10
1
I am new to this system.  If I could skip the report writer I would.  I also have limited control over the SQL.  Maybe I could do some unions or joins, groupings, crosstabs, etc.

From the simple data sources adding to the reports, customer records get rendered this way.

Customer Key Phone Type Phone Number Other Columns, etc.
00000000001 HOME          555-555-5555
00000000001 WORK          555-555-5555
00000000001 CELL            555-555-5555
00000000002
00000000003 WORK          555-555-5555
00000000003 CELL            555-555-5555

Needs to get rendered this way. 

Customer Key WorkPhone      CellPhone        HomePhone    All other columns
00000000001 555-555-5555 555-555-5555 555-555-5555
00000000002
00000000003 555-555-5555 555-555-5555

This is a very specific output for integration.

Can someone help me, a newbie, out?
2
Reporting / Re: Custom Palette for Active Report
« Last post by Imre on 17 Nov 2019 08:28:47 am »
Any chance someone can confirm whether custom palette may be used in Active Reports in Cognos Analyitcs 11.1?
3
Reporting / Re: What tools / plugins are you all using for Deployments?
« Last post by DaBaker on 15 Nov 2019 03:06:14 pm »
Hello -

What version of Cognos are you using C10 or CA?   Also - Are you deploying the packages from one environment to another or the cpf files, when you say framework deployments?

It looks like you can log an issue or ask questions with your ICS provider here: https://www.bspsoftware.com/support/log-an-issue

Hopefully that helps you out. 
4
Reporting / Re: Cross Tab - is it possible ?
« Last post by lukasz921 on 15 Nov 2019 12:15:15 pm »
Thanks for reply. No I want add next row in crosstab but this row calculated before previous row
5
Reporting / Re: Search&Select prompt find exact match
« Last post by ThatKingslayer on 15 Nov 2019 09:32:36 am »
Look at your Search and Select box (viewing the report in HTML / not in design mode) and you should see options for how the search will work such as 'Starts with any of these keywords' or 'Contains all of these keywords'. That might help. I'd also check your query to see what the filter is set up is like.

One thing though is that you said you were not able to edit the query. Are you in REPORTING or DASHBOARDS? If you meant Dashboards then you might need to move this topic over there as the answers might differ.
6
Reporting / Re: Cross Tab - is it possible ?
« Last post by ThatKingslayer on 15 Nov 2019 09:28:52 am »
I am not entirely sure what you are asking as it looks like a word or two might be missing, however, if your question is whether or not it is possible to add Total or Summary lines to a crosstab on a report, the answer is 'Yes'.
7
Reporting / What tools / plugins are you all using for Deployments?
« Last post by ThatKingslayer on 15 Nov 2019 09:26:12 am »
This is aimed at those who have various environments for Cognos such as Development, Testing, and Production. I am curious what tools and/or plugins you are using to actually move your reports and frameworks from one environment to another? What are the pros and cons? Do those provide the ability to revert to a previous version of provide history?

The reason I am asking about this is because we use a third party tool called ICS and it is great, however, there are a lot of issues with it when it comes to framework deployments so I wanted to explore what some other people are doing.

Thanks!
8
Dashboards / List of Hyperlinks
« Last post by jasonmacpei on 15 Nov 2019 08:24:39 am »
Hi,
Can anyone tell me if you can insert a static hyper link to an external website in Dashboarding - v11.0.12?

If not, is this an option in later versions, like v11.1.4?

Thank you!

Jason.
9
Reporting / Re: Report Failing in an Event within an Event
« Last post by adam_mc on 15 Nov 2019 07:30:39 am »
Update - The plot thickens...

We now pulled Event B out of Event A and scheduled Event B to execute on its own.
However, now that it is scheduled, Event B fails at the same report with the same error message "RSV-DST-0019 This output format is not supported for an IBM Cognos Active Report".

Again, we are able to run the Event interactively successfully.

In fact what we are seeing is that potentially all our Events that are scheduled fail, but all run successfully interactively.
Is there anything different between scheduling events in 10.2.2 vs. 11.0.13.
I know Event Studio is a legacy tool now, but our expectation was that it would work in CA 11.0.13.

Any thoughts?
Thanks in advance,
Adam.
10
Administration and Security / Re: Cognos 11.1.3 Install
« Last post by littlet on 14 Nov 2019 05:46:01 pm »
I would prefer to do a new install.  I tried the over-the-top install from 11.1.2 to 11.1.3 and I have had many problems down the road with strange errors in the logs. In the past I have always done a new install but was told that the over-the-top was working fine.  I am not convinced.
Pages: [1] 2 3 ... 10

       
Twittear