Recent Posts

Pages: [1] 2 3 ... 10
Report Studio / Re: Transpose Query Data
« Last post by blaubner on Today at 10:51:40 am »
ID and Major sit in a table, so that would mean it's relational data right?

Are you suggesting I build a cross tab on a report page? How would I get the report page into my list of queries under Query Explorer so I could left join more data onto the cross tab?

Reporting / Re: Custom Control to set a prompt
« Last post by CognosPaul on Today at 10:35:50 am »
I've come across some cases where using setValues or addValues sets the prompt correctly, but it doesn't catch it. I believe it's a bug that is due to be fixed at some point. Which version are you using?

In the meantime you can probably get around it by triggering the onChange event on the element. I *think* you can get the element by using oControl.element. Then do oControl.element.onChange().
Good Afternoon
I have a bursted report (using report studio 10.2.1) which has been working well for many months, it is bursted on the department name and has around usually produces around 120 reports to approx. 250 recipients, meaning some people getting more than 1 copy.

My question is, there any way to include the Department name on the email subject line, so that the recipients know which report is for which department without having to open the message.

I thought about reports views but that would be too maintenance heavy. I know you can have dynamic subject lines in event studio but will that work with a bursted report?

Does anyone have any experience with this kind of problem?

Many thanks in advance for any help provided

Report Studio / Re: Calender Report Creation. Please help
« Last post by New_Guy on Today at 10:16:35 am »
If you are talking about a prompt that prompts a user to select a date, then you can use a date prompt and use that parameter in a filter for the query which brings in all the events for that selected date. If this is not what you want, let us know the requirement a bit more clearly.
Good luck
New guy
Report Studio / Re: Rolling Last 12 Months in Report Studio.
« Last post by hespora on Today at 10:07:00 am »
Wonderful, glad I could help! :)
you can use ParamDisplayValue('parameter') and by default it will be displayed with comma's.
Good luck
New guy
Cognos Administration / Connection to AWS Redshift (from Cognos 10.2.2)
« Last post by JamesR on Today at 09:43:18 am »
Hi All,

Does anyone have any experience in creating a connection to AWS Redshift? I've followed the below, but can't get the JDBC drivers to work...

When I go to test the connection I keep getting an error. When I try the 4.2 version driver I get "XQE-GEN-0002 An unexpected exception occurred: JVMCFRE003 bad major version; class=com/amazon/redshift/jdbc42/Driver, offset=6"

I believe this is something to do with the jar compiled in a newer version of java?

If I try version 4.1 (as in the video) or older, I get "XQE-GEN-0002 An unexpected exception occurred: Failed to load Driver class. This error may be caused by all-in-one JAR packing. Please try again with the lean package: D:\Program%20Files\IBM\cognos\c10_64\webapps\p2pd\WEB-INF\lib\RedshiftJDBC41.1.2.8.jar (The system cannot find the path specified)"

The files are definitely located in the right place, so I'm puzzled as to what the issue could be with version 4.1.

Any pointers greatly appreciated!



The only way to achieve this is by having 2 crosstabs and settting up the required rows per page in the properties and rendering them based on the report output variable.
Good luck
New guy
Cognos Administration / Issues with audit data base
« Last post by karthik12345 on Today at 09:17:36 am »
I am facing issue with audit data base, we have a cognos job which will create more than 6000 reports through busting, ones the job complete we will get a mail with job details  job start time and end time.we are getting this job details through audit data base.
if i run the job first time , i am getting the correct job details from audit data base,then if i run any other job, cognos is not putting the entry in audit database, to rectify this i have to restart the server.but again if i run the job with more reports i am facing same issue with audit database. please help me to rectify this issue.

Thanks in advance!!

Report Studio / Re: Transpose Query Data
« Last post by bdbits on Today at 09:00:36 am »
You've not said whether your data source is relational or dimensional, but this looks like a basic crosstab to me.

Have you perused the Report Studio user guide (same as help)? It is actually pretty good as a tutorial / introduction on Cognos essentials.
Pages: [1] 2 3 ... 10