Recent Posts

Pages: [1] 2 3 ... 10
The problem is that on the same List, I have to bring in the data from the 3 months and the data for the 6 months. If I filter out one Query based on
the second Query, the 6 months data will not be correct if I'm only filtering out by 3 months.

Are you saying something different that I'm not understanding? The third tab under Query Calculation shows the Query1 and the data items.

I'm working on it since I think I understand but please elaborate if you could.

Thanks so much :) :)
Did you update the default.htm and index.html in the c10_64\webcontent directory to use the new mod?
Did you clear you browser cache, and bypass a proxy if that is set?

is your hardware so limited? Have you increased some settings in the Cognos Administration like JVM heat settings or in Cognos Configuration like Websphere memory? The defaults are rather low.

Are there more concurrent users on the system who then have performance issues or only you with this specific case?


I have to build the report using two Native SQL's.

1) First SQL - All the Columns are from DWPRD Tables

2) Second SQL - All the Columns are from SNDPRD Tables.

Here is the Performance issue

1) When I check the View Tabular Data for Individual Queries the results are shown in 10 Secs.

2) When I drag the queries into two Different Lists, the report is taking ages to RUN.

3) Ideally, I have to build the Report by Joining the queries and show it in one List.

Note: The Client doesn't want to build FM Model / Create a table by combing these two sources tables

Any help is much appreciated!


We actually have it configured to use mod2_2 but when I use the site I see it loading cognos.cgi in the browser network panel.  Does it make sense that this cgi file would still be in the network load panel?
Administration and Security / Re: URL Redirect from http to htpps
« Last post by Reinhard on 25 May 2018 05:28:18 pm »
Thanks! The URL rewrite rules are actually already in place for the /bi directory since they are necessary for the SSO part. Now the problem I have is to change these rules to what I need and thats where I am not successful:-(
Administration and Security / Re: URL Redirect from http to htpps
« Last post by dougp on 25 May 2018 04:59:09 pm »
My web guy did this successfully in a test environment a while back.  We didn't have the energy or requirement to move the change to production.

Control Panel
Turn Windows features on or off (produces the Add Roles and Features Wizard)
Next, Next, Next
Web Server
    Web Server
        Common HTTP Features
            HTTP Redirection
(Next, .....)

You'll also need the tool that is required for Cognos SSO.  (Application Request Routing)

Then you add a URL Rewrite (not a HTTP redirect) to perform the redirection.

Since we didn't move forward, I don't have the details (settings and regular expression strings for the rewrite) any more.
Framework Manager / Re: Data Modeling Q&A Community
« Last post by Reinhard on 25 May 2018 04:17:43 pm »

the developer works of IBM have some forum function where some IT support employess post in but I do rather use cognois because it is better structured and has more activity. Otherwise I have not met anythink like this.

Modeling is more art then craft which makes it more extensive to answer:-( Honestly, I have met consultants working for years with Cognos and still not being able to give better answers then just reciting the training materials.

Best get yourself some consultant who knows his stuff to answer your questions in a workshop for a day.

Reporting / Re: Invert y-axis order on a chart
« Last post by Reinhard on 25 May 2018 04:13:22 pm »

just add a query calculation, do the *-1 there and sort your measure by your new item. Chart and visualization can do that.

Reporting / Re: Event Studio does not even work at ALL in 11.0.11
« Last post by Reinhard on 25 May 2018 04:11:59 pm »
Mine (11.0.10) has some issues like that too!
Pages: [1] 2 3 ... 10