Recent Posts

Pages: [1] 2 3 ... 10
1
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
2
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.
3
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%
4
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.
5
Reporting / Re: freezing column headings is shrinking crosstab
« Last post by anandcognos on 20 Jul 2018 02:50:04 pm »
please help.
6
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
8
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.
9
Framework Manager / Re: Way to automate editing multiple query items?
« Last post by LostInTime on 20 Jul 2018 09:41:22 am »
Wow I am dumb.

I thought you couldn't edit the model via text editor because I tried visual studio code and it wouldn't load the entire document, only to like line 135...

Tried notepad++ and it works wonder, and just figured it out and wrote a small script. Going to test it out now and see if it works, thanks for the heads up guys :)
10
JDBC (and ODBC) metadata methods can return metadata for objects (i.e tables) even if the user performing the API call does not have the ability to query the table.

In some cases, a vendor may internally filter their metadata responses to only return those the use has access to, but that is not a requirement of the specification.

Pages: [1] 2 3 ... 10

       
Twittear