Recent Posts

Pages: [1] 2 3 ... 10
1
(assuming all this is relational)

My approach to build all this would be a single crosstab. Basically, you'd have three queries, corresponding to what you grouped as "Crosstab", "Summarized Crosstab Metrics", and "Metrics not contained in crosstab". These would share some common dimensions (otherwise, you wouldn't be able to line them up in XL either), across which you could join the data into a single query, from which you could feed the crosstab.
2
I am trying to set up automated reporting for several jobs.  I am not finding the Scheduling Icon anywhere.  Is this a permission that needs to be enabled for me and if so, where would I enable it?

Hi,

Yes, there is a capability that grants Scheduling, and it sounds like you don't have this assigned. You can either be added to a group or role that does have it assigned, or you can be granted the capability directly. You will need an Administrator to do this for you, though. They need to go into the Administration Console > Security tab > Capabilities, page down to see the Scheduling capability and use the Set Properties option to add your user or group to the capability (on the Permissions tab, you need Execute and Traverse permissions granted)

Cheers!

MF.
3
Upgrading to Cognos Analytics / Jquery in non-interactive mode
« Last post by esar on 13 Dec 2017 04:11:29 pm »
Hi Experts.

We are upgrading to C11 and i have some reports with jquery scripts that doesnt seem to work fine in interactive mode. Most of the scripts were working when i moved the code to modules. But some are causing issues. So i decided to leave this report in non-interactive mode. But i am not able to to use any jquery code in non-interactive mode. Is there a specific way of linking jquery.js or in the way $ is used?

Thanks in advance.

4
Hi all, I have a requirement to create page sets based upon a Data Item value. Each page will have 2 crosstabs with 2 different queries. My question is: What are best practices for creating Page Sets that will create individual pages for each value of the desired Page Set field?

In a nutshell, I have a report that creates two crosstabs for high and lower percentile performers for a last-12-months rate. It works like this:
Query = all_percentiles

| Location   ID | Region    | Metric Rate | Percentile |
|---------------|-----------|-------------|------------|
| Location 1    | Midwest   | 1.4%        | 0.1        |
| Location 2    | Midwest   | 1.5%        | 0.2        |
| …             |           |             |            |
| Location 8    | Midwest   | 4.3%        | 0.8        |
| Location 9    | Midwest   | 4.4%        | 0.9        |
| Location 10   | Midwest   | 4.5%        | 1          |
|               |           |             |            |
| Location 20   | Northeast | 2.1%        | 0.5        |
| Location 21   | Northeast | 2.2%        | 0.1        |
| Location 22   | Northeast | 2.3%        | 0.15       |
| Location 23   | Northeast | 2.4%        | 0.2        |
| …             |           |             |            |
| Location 37   | Northeast | 5.1%        | 0.8        |
| Location 38   | Northeast | 5.1%        | 0.85       |
| Location 39   | Northeast | 5.1%        | 0.9        |
| Location 40   | Northeast | 5.1%        | 0.95       |
| Location 41   | Northeast | 5.1%        | 1          |


Query = <20_percentile
> Query reference of all_percentiles, with a filter of [Percentile] < .2

| Location   ID | Region    | Metric Rate | Percentile |
|---------------|-----------|-------------|------------|
| Location 1    | Midwest   | 1.4%        | 0.1        |
| Location 2    | Midwest   | 1.5%        | 0.2        |
| Location 20   | Northeast | 2.1%        | 0.5        |
| Location 21   | Northeast | 2.2%        | 0.1        |
| Location 22   | Northeast | 2.3%        | 0.15       |
| Location 23   | Northeast | 2.4%        | 0.2        |


Query = >80_percentile
> Same method as <20_percentile, dif't filter.

| Location   ID | Region    | Metric Rate | Percentile |
|---------------|-----------|-------------|------------|
| Location 8    | Midwest   | 4.3%        | 0.8        |
| Location 9    | Midwest   | 4.4%        | 0.9        |
| Location 10   | Midwest   | 4.5%        | 1          |
| Location 37   | Northeast | 5.1%        | 0.8        |
| Location 38   | Northeast | 5.1%        | 0.85       |
| Location 39   | Northeast | 5.1%        | 0.9        |
| Location 40   | Northeast | 5.1%        | 0.95       |
| Location 41   | Northeast | 5.1%        | 1          |


Crosstabs are populated with data from additional queries that find the historical monthly data for the 'cohorts' of <20 and >80 Locations.

So: what are best practices when creating Page Sets to display the crosstabs from two different queries? I'm most curious about extensibility, in case new requirements include the addition of data from other queries.

5
BigChris, yes, I can get all of the data onto one page, but my question is more about WHAT types of containers (Crosstab, List) in which the data should be configured, and HOW they should be configured. Thanks
6
Cognos Administration / Cognos 10.2.2 service restarting everyday
« Last post by nagoole on 13 Dec 2017 11:26:51 am »
Hi Team,

My new client cognos env (Distributed) daily basis (4AM) the cognos service restarting to refresh the performance and clean up the dmp/core files.

2 App
2 CM
2 WEB

I have approached that daily basis not required and weekly maintenance is enough to control the system performance.

This is new client and they will look for clear proper justification on this changes (My understanding whenever restart happens admin should check system function all are working as expected but here they are not following.

My expectation from you do we have any valid restart process recommended by IBM ?Or please share your thought on this  cognos. 
7
Report Studio / Re: PDF Printing Issue
« Last post by maxchuie on 13 Dec 2017 10:32:58 am »
Richard,
I am having this same issue did you find a solution?
8
First things first, are you able to get all of the data onto the same page in your report? Once you've done that it should be possible to manipulate it so that the rows line up...
9
Report Studio / Manage External data - not working. Can't validate data
« Last post by olgrim on 13 Dec 2017 10:04:52 am »
Hello COGNOS pros. I am using COGNOS 10.2.1 ver.
I am trying to use external Excel data in some of my COGNOS reports. Our administrator and I stumbled on this COGNOS issue: I set-up a small excel file 1000 rows, 4 columns. I created a data source.

Everything seems works up to the point when I try to view data of the query that uses external data or I try to, say, just to validate this query, or use this query in reports.  COGNOS is trying to execute, read data and runs forever, without end.  I have to terminate and "Cancel". Data (excel file) is saved in a regular company shared folder. I have a permission to use external data with up to 30k lines, no problem here.

Can somebody please help to resolve this problem?
Please see attachement in pictures in MS Word showing the problem.

thank you
10
I am trying to set up automated reporting for several jobs.  I am not finding the Scheduling Icon anywhere.  Is this a permission that needs to be enabled for me and if so, where would I enable it? 
Pages: [1] 2 3 ... 10

       
Twittear