Recent Posts

Pages: [1] 2 3 ... 10
1
Report Studio / create percentage for crosstab
« Last post by ittimes on Today at 01:53:01 pm »
http://cognosandme.blogspot.ca/2010/08/creating-overall-percentage-summary.html


User Query - Creating Overall Percentage Summary Values in Reports
This requirement is in response to a user query:

Requirement: Display Dates, Sales, Percentage Sales along with summary total.

Solution:

Step 1: Create a crosstab report with Year, Month, Sales data items.

Step 2: Create a data item Total Sales - total(...[Sales] for report).

Step 3: Set the Aggregate and Rollup Aggregate functions to calculated.

Step 4: Create a data item Percentage - [Sales] / [Total Sales] and set aggregate and rollup to calculated. Drag this query item into the crosstab.



Here are a couple of other ways to format the above information:



2
Reporting / Re: Drill-through issue in PDF output
« Last post by lots_of_questions on Today at 12:50:40 pm »
Turns out that turning off the "Run with full interactivity" will allow the V11 drill-through report to open in a new window.  But it still closes the PDF in the background.  :o
3
Reporting / Drill-through issue in PDF output
« Last post by lots_of_questions on Today at 12:41:16 pm »
Hi all,

I am using IBM Cognos Analytics 11.0.7.   

Report 1 is a report that has been converted from V10.  When I run Report 1 as HTML the drill through works perfect. (ie. it opens in an new window and Report 1 stays open in the background)  When I run Report 1 as PDF... not so much.  The report opens fine and the drill through works.  But the report in the background closes and returns to the welcome page.

I tried to replicate this with a test report (Report 2) made in V11. When I run Report 2 as HTML the drill through works perfect. (ie. it opens in an new window and Report 2 stays open in the background)  When I run Report 2 as PDF the drill through works but it will not open in a new window.  I double and triple checked... the Open in new window is checked.

Has anyone else had issues with drill-through functionality inside a PDF output?
4
Dashboards / Re: Can you prevent users from editing a dashboard
« Last post by Kiran P on Today at 12:01:08 pm »
Hi

We did face this problem where in users with even read/execute access to dashboard capability are able to edit. The only way we could restrict is by role customization. We hid the edit button to prevent modifications.

Hope that helps.

Thanks
Kiran

Sent from my ZUK Z2132 using Tapatalk

5
Administration and Security / Cognos BA SSL Configuration
« Last post by kennedto on Today at 11:32:05 am »
I am using COGNOS BA 11.0.9.

I am looking at the instructions for configuring SSL for all components in the configuration manager.
It says this:

To configure SSL for all connections, enter the same URI for both the Internal dispatcher URI, External dispatcher URI, and Dispatcher URI for external applications properties. Enter https and a port number for SSL communication.

Out of the box, each of these have different URIs.   
External Dispatcher URI:  http://cognosanalytics.XXXX:9300/p2pd/servlet/dispatch
Internal Dispatcher URI: http://localhost:9300/p2pd/servlet/dispatch
Dispatcher URI for External Applications: http://cognosanalytics.XXXX:9300/bi/v1/disp

I am not sure what to put for the URI if they are all supposed to be the same.  Thoughts?
6
Administration and Security / Re: Allow External Data Permission
« Last post by whatever890 on Today at 10:31:36 am »
Do you have Allow External Data set on the package capabilities?  This setting is under the package properties.
7
I have a report for which the queries feeding crosstabs runs in about 1 minute, but the full report takes almost 7 hours to run.

The report design is:
Top 20%:
Crosstab 1 | Crosstab 2 | Crosstab3

Bottom 20%:
Crosstab 1 | Crosstab 2 | Crosstab3

There are maybe 20 rows per top/bottom section. There are page sets based upon the region of each location.

Why would a query that takes 1 minute to run take 7 hours to render to Excel? Are there ways I can improve the performance? This runtime is unacceptable for business users.

Thank you!
8
Dashboards / Re: List or cross tab in cognos 11 Analytics
« Last post by MFGF on Today at 07:37:15 am »
Hi,
I am currently using cognos 11 multi tab dashboard and want to show list or cross tab in second tab along with measure. Is it possible?

Hi,

Yes. Drag in either a crosstab or a table from the visualizations pane:



Cheers!

MF.
9
Dashboards / Re: Dashboard title in Cognos 11
« Last post by MFGF on Today at 07:36:34 am »
Hi,
Can anyone share his/her experience how we can add title in Dashboard in Cognos11?

Thanks,
Sunny

Hi,

Just drag in a text object from the Widgets pane:



Cheers!

MF.
10
Dashboards / List or cross tab in cognos 11 Analytics
« Last post by sunny bachan prasad on Today at 07:13:45 am »
Hi,
I am currently using cognos 11 multi tab dashboard and want to show list or cross tab in second tab along with measure. Is it possible?
 
Pages: [1] 2 3 ... 10

       
Twittear