Recent Posts

Pages: [1] 2 3 ... 10
1
Reporting / Re: Cognos Analytics - JavaScript Submit Page
« Last post by loki0wn on Today at 07:19:13 pm »
So, I am probably dense, but doesn't ControlHost.finish() submit the page. I thought it just acted as a control prompt action, i.e. it doesn't automatically submit.

I'm probably doing something wrong though.
2
Reporting / Visualization "Older" Charts --> Pie
« Last post by Cognos_Jan2017 on Today at 04:10:42 pm »
Work fine when run as Excel.

When running them as HTML to a Pie Chart, at the base of the Chart, the names assigned
to "Default Measure" and "Categories" are displayed.  Is there a way to ensure those are
NOT displayed when run as HTML?  They are not displayed when run as Excel.

TIA, Bob
3
I think the problem resides in how this is modeled but I really don't see anything wrong with my model.  Perhaps I am thinking too much like a typical relational database design but this is my design.

Database Model Layer
---------------------------
Account(1..1 on Account ID)<------->(1..n on Account ID) Invoice (1..1 on Invoice ID)

Account has
-Account ID
-Account Balance

Invoice has
-Invoice ID
-Account ID
-Various data about invoice

My Business Layer exposes the following to the user
----------------------------------
Account
-Account ID
-Account Balance

Invoice
-Invoice ID
-Various data about invoice

I don't see anything wrong with my model.  I also don't see any good reason for Cognos to decide that a column with duplicate values needs to be "Auto Summarized", when is this a good idea?



4
Report Studio / Re: report studio
« Last post by Reinhard on Today at 01:31:18 pm »
Not sure it is spam, really, as it is at least referencing Cognos. Looks like maybe assistance trying to block a move to Tableau instead of Cognos. Which is more like comparing apples and oranges, as they meet different needs (in my opinion).

But more input from the OP is certainly needed.

Please specify. Tableau is on the rise and I would like to know what needs it serves better / differently.
5
If you want to get rid of fractions then use the function round().

Otherwise cast it to integer.
6
It matters how heavily formatted your report is and the output format (HTML, PDF, Excel, etc). The result set size can also affect rendering time, as Cognos has to do something with all of the data after it gets it. If it is a large number of rows this can take some time.
7
So my total balance is off by about $13. There are these tiny fractions of a cent I can't seem to get rid of. They don't exist in the Combined query output but they are showing in the ARindex one. I've tried defining the data item in the list as currency and maximizing the decimal to 2 places but still this data still exists in the output. Any advice? The reports I've been given as a comparison of data for verification are showing the balances in the Combined output, not the ARIndex one.

The screenshot is a comparison of one account of about 2000 Accounts. In the example you can see the ledger date is 2012 so this is an inactive account that should have been zero'd out.

tried round ([Combined].[CURRENT_ACTUAL], 2) with no luck.
8
Report Studio / Re: report studio
« Last post by bdbits on Today at 12:28:25 pm »
Not sure it is spam, really, as it is at least referencing Cognos. Looks like maybe assistance trying to block a move to Tableau instead of Cognos. Which is more like comparing apples and oranges, as they meet different needs (in my opinion).

But more input from the OP is certainly needed.
9
Here is a relevant IBM Technote with instructions for multiple versions of Cognos through 10.2.

http://www-01.ibm.com/support/docview.wss?uid=swg21344292
10
Thanks, I redid the join on ARIndex, and now doing a list report for all queries and then verifying the data. For some reason when summarizing the Current_Actual value in the export on ARIndex I get a slightly lesser number. Hoping it all works out, I think part of the problem was be trying to pull the tabular data without just checking the resulting data and may have cached some bad data.
Pages: [1] 2 3 ... 10

       
Twittear