Recent Posts

Pages: [1] 2 3 ... 10
1
Thanks for your response Paul!

I am looking for Non-Interactive mode.


2
Reporting / Re: How to autosubmit Cognos Date prompt using JavaScript
« Last post by CognosPaul on 22 Jul 2018 10:35:37 pm »
Are you looking for interactive or non-interactive mode?
3
Reporting / How to autosubmit Cognos Date prompt using JavaScript
« Last post by Kiran Kandavalli on 21 Jul 2018 12:39:48 pm »
Team,

I have a requirement to autosubmit the Cognos Date prompt without using Prompt Buttons.

if anyone has the code, can you please provide it to me.

Thanks!
Kiran
4
Reporting / Re: freezing column headings is shrinking crosstab
« Last post by anandcognos on 20 Jul 2018 05:55:45 pm »
Thanks. I put crosstab inside table of 1 column 1 row and set width of crosstab as 100% , but still it
was shrinked. I tried by putting height of crosstab also as 100% , did not work. My crosstab is inside
block and height of block is 15 cms and option selected as 'show scrollbar only when necessary'. 'Number of rows' property of crosstab is set as 20000, so that all rows cime at one go. So, why crosstab is shrinked and show only 2 rows, when user right click column and select freeze column headings. I will appreciate any help. Thanks.
5
Reporting / Re: freezing column headings is shrinking crosstab
« Last post by sdf on 20 Jul 2018 03:41:12 pm »
I had a similar issue before, just not that sure we are having the same.
We may need more details on your current situation. Screenshot perhaps??

Anyway, what I did before was place a crosstab in a container (table) then set the crosstab's width to 100%
6
Reporting / Re: Column not aggregating correctly, need help please
« Last post by sdf on 20 Jul 2018 03:36:41 pm »
I am guessing your Revenue item is a calculation. And what you want is to just total all the values of the revenue (total the rows)?

How are you calculating the revenue?
How are you aggregating?

Well you can try some of the basic to check. Select your Revenue column and in the properties look for Solve Order, Change it to 2.

make sure you are using the correct aggregate function and property.
Try to set as calculated then total or automatic.
7
Reporting / Re: freezing column headings is shrinking crosstab
« Last post by anandcognos on 20 Jul 2018 02:50:04 pm »
please help.
8
Reporting / Column not aggregating correctly, need help please
« Last post by bz_boy on 20 Jul 2018 02:00:13 pm »
Hello all. I am having trouble getting a "Revenue" column to aggregate correctly. For this particular column, the value for this particular client should have a revenue of $200. When I run the report, the value for revenue for this client is astronomically high with a revenue of $39,500.

I have tried multiple trial and errors but still can't get it to work correctly. Can someone please offer a suggestion of how I can get this to work correctly? When I run the query in SQL Server the value shows correct, however in Cognos 11 Business Analytics the value is incorrect.


What else could I try?

Thank you in advance
10
Reporting / freezing column headings is shrinking crosstab
« Last post by anandcognos on 20 Jul 2018 10:48:40 am »
Dear all,

When I try to freeze column heading of crosstab, by right clicking it, crosstab shrinks and shows only column headings and one row. We are on cognos analytics 11 and same problem occurs in 10.2 also. Any help is much appreciated. Thanks.
Pages: [1] 2 3 ... 10

       
Twittear