Recent Posts

Pages: [1] 2 3 ... 10
I just selected the total option after I grouped (the sum). Indeed, it totals the amount as it would be for each line. I only need one amount for the whole MO and that amount to total in the overall footer. But I don't know how to do this.
Have you opened a support ticket with IBM?
Your totals are multiples of the values in the rows.

What expression are you using for the total?
Report Studio / Re: Filter query after Moving Average calculation
« Last post by cassinium on Today at 04:20:07 pm »
I tried that, but it doesn't work.  The moving average is still wrong.
I am getting an error while connecting to content store after Oracle 12C Upgrade.
Error: ORA-28040: No matching authentication protocol
Environment: Cognos 10.1.1
Oracle Version: 12C
OJDBC Drivers: Ojdbc6.jar
Please let me know if anyone of the guys faces same kind of issue.
Administration and Security / Using Command blocks in Cognos datasource
« Last post by NC81 on Today at 02:59:31 pm »
I am using Cognos JDBC datasource . Due to the complexity of the queries , I need to pass few database hints as part of the cognos query to the datasource.
Can anyone advise , how to pass STRAIGHT_JOIN from Cognos to the database using the command blocks.
I tried to set by opening a command block, but it did not help.
The query from Cognos should form something like this.
select STRAIGHT_JOIN c1, c2, c3 from t1,t2...


Pls Help!!

If someone can share their experience in Rolling Up the Previous Month's count of records to the Existing Month, I would greatly appreciate it.

I have a Crosstab and all I need to do is to include the previous counts as a part of the next month.

April Record Count needs to include March count based on some condition.

Thanks in advance for your time.
Hi Learnbi,

I have a similar requirement as yours, could you pls help me how to assign an excel to a value prompt with the Javascript.

Report Studio / Re: Retrieve Prior 12 Months as Rolling 12
« Last post by Cognos_Jan2017 on Today at 02:11:51 pm »
I was offline thru today.  The fully-qualified path corrected the problem.

I don't even remember the exact error message but knew I had messed-up somewhere ...
the somewhere being the need to utilize the Query "[Q_SolidWaste_9May]" as a prefix.

Again, the Cognoise Guys delivered great results.

THANKS again, Bob
Report Studio / Totals for an NONE aggregate function not showing right
« Last post by Amber12 on Today at 12:09:41 pm »
Hello. I'm very new to Cognos - Report studio and I still have lots to learn. For now I'm trying to convert some reports from Impromptu to Cognos Report Studio and my totals are not right. I have a field, Actual Values - Raw Materials that has None under Aggregate Function, in properties. I get the same numbers like in the old reports. But when I run the total, the numbers are not showing correct. I don't know what else to do.

Can anybody please help me?

Thank you   
Pages: [1] 2 3 ... 10