Recent Posts

Pages: [1] 2 3 ... 10
1
Transformer / Cube build time
« Last post by cognos05 on Today at 01:42:57 pm »
Hi ,

Iam using the below script to buil cognos ransformer cubes.

cd "C:\Program Files (x86)\ibm\cognos\c11\bin"
cogtr.exe -n2 -c -g -s -m"E:\Cognos Cubes\DWH Agency Sales Cube\Model\DWH Agency Sales Daily.mdl"

I am rebuilding the cubes in two similar servers with same data and one serer completes cube buil in 20 mins and other takes 35 minutes.

Is there any specific command I can use the cube build process to say build parallely if there is more than 1 cube building on the same server at similar time.
2
This query will locate schedules.  You could modify this to look for documentContent objects.  I don't have any documentContent objects, so I can't test.  Looking from a top-down perspective, you may need to go through one of the CMREF* tables to make the final connection to the documentContent.

(except that I can't paste SQL or upload attachments)

Try this:  https://raw.githubusercontent.com/dougpulse/Cognos/master/ContentStore/LocateSchedules.sql
3
Yes it does seem to be something that is somehow scheduled, but I don't know how to figure out where this is scheduled so that I can modify it.  And, I don't know what a burst is.  This just started showing up last September 2020.  Between 2013 and September 2020, this 50.xx record was not created.  It would be great if someone could tell me where to look, so that I can stop this thing from being generated.
4
Reporting / Vizualisation in the PDF Output does not display full page
« Last post by mrh on 15 Jun 2021 06:55:02 pm »
Hi,

I designed a report with 3 panels, 1 panel for stacked clustered combination and other 2 panels with crosstab.  When i run the report displays all 3 panels.  But there is a requirement to schedule pdf output, on the pdf output vizualisation does not occupy it's space.  It is partially filling the panel.

Any idea on how to fix this problem?

Thanks,
MRH
5
I don't know what you mean by documentContent -- the CMCLASSES value or the SDK object -- but I would hope they mean the same thing.

I found https://www.ibm.com/docs/en/cognos-analytics/11.0.0?topic=classes-documentcontent (but none for 10.2.2).  It looks like it's bunch of data (recipients, first page of the report, images needed by the report, etc.) related to a burst.  So I'd guess it's being produced by a schedule somewhere in your system.

I don't see anything with CMCLASSES.NAME = 'documentContent' in my Content Store, so I can't be sure.  Plus I don't do much bursting.
6
We are running Cognos 10.2.2.  We keep running out of space in our content store.  Our content store records and db size consumption are continuously increasing from scheduled report jobs (or something).  We have cleanup jobs that remove stored reports older than 14 days and we don't allow the user to save more that two historical records (we have a cleanup job that takes care of that.).  In our analysis, we noticed that a report object is created in the  CMOBJECTS table that is a documentContent every hour at a size of 49.XX MB.  This continues to accumulate and these records are never deleted.  This takes up a lot of space.  Additionally, these records did not start occurring until Sep 2020.  In previous years, these records were not produced.  These records are not produced in our Test environment.  So, here are my questions:

What purpose do these records serve? This seems to be (from my research) properties of the report. I don't know how (or if) this is used in the portal by the user.
How do I stop (or can I) this from being saved to the db?
How do I safely delete these records from the table (or can I)?
7
I am trying to setup a new namespace in Cognos Analytics 11.1.7 to allow users to login using our OAUTH setup.  I have tried both ADFS and Generic, but I cannot get past the namespace test because it throws the error "Failed to retrieve discovery document".  I can pull up a browser on that server and get to the discovery document just fine, a good looking JSON file.  But the Cognos app acts like the file doesn't exist, or it is being blocked, or something.  The logs are of no use, just repeating the same error,

Has anyone else run into this?

Thanks!
8
Report Studio / Re: Extract Minimum and Maximum Dates by Group
« Last post by MFGF on 15 Jun 2021 08:07:39 am »
Hello,

In my report i applied Group by on Segment, Job and Sub Job Number.

I want to extract max and min date for each Segment/job/sub by their group.

For example in the below sample data I want to get the min date as May 3rd and Max Date as May 21st for Sub 01 and May 13th -June 4th for Sub 09

Can you please help us with a formula to extract max and min dates.


Job No      Sub   SegmentDesc   Week   Min                   Max                  Duration   Date Worked   Start Date           End Date
                           
ACMV00   01    Supervision   Monday   May 3, 2021   May 21, 2021    18.00    May 3, 2021   May 3, 2021   May 3, 2021
ACMV00   01    Supervision   Friday                                                    May 21, 2021   May 21, 2021   May 21, 2021

ACMV00   09    Supervision   Thursday   May 13, 2021   Jun 4, 2021    22.00    May 13, 2021   May 13, 2021   May 13, 2021
ACMV00   09    Supervision   Friday                                                    Jun 4, 2021   Jun 4, 2021   Jun 4, 2021

Thanks in advance
Raju

Hi,

Which item specifically do you need to find the max and min values for? You appear to have three date items - will they always be the same?

Assuming it's Date Worked, and also assuming you need to take account of both the Job No and the Sub items for the maximum, you can write expressions in query calculations. Max value would be

maximum([Date Worked] for [Job No],)

Min value would be the same but using minimum() instead of maximum()

Cheers!

MF.

9
Report Studio / Re: How to resolve UDA-SQL-0219 The function "date_trunc" error
« Last post by MFGF on 15 Jun 2021 07:51:49 am »
Hi All,

My report data has parent-child structure.

The parent data is for insurance premium and its child records are for endorsement reasons. Their relation is 1:m.

I have tried to aggregate the parent level premium with condition that doesn't have the dendorsement reason 'COVID-19'.

Let me show the example.

Parent records
--------------------------------------------------------
Ins_No.  |   Premium   |   Quoted Date(YYYY-MM)
--------------------------------------------------------
  P1        |   1,500       |   2021-04
  P2        |   1,000       |   2021-05
  P3        |     500        |   2021-05
===============================

Child Reocrd
---------------------------------------------------------------
Ins_No.  |   Reason Code  |   Reason
---------------------------------------------------------------
  P1       |   R1                 |  Change to Expiry Date
  P1       |   R2                 |  Change to Policy Clauses
  P2       |   R1                 |  Change to Expiry Date
  P3       |   R3                 |  COVID-19
===================================

Should have the result report
--------------------------------------------------------------------------------
Ins_No.  |   Premium   |   Quoted Date(YYYY-MM)    |   Reason Count
--------------------------------------------------------------------------------
  P1        |  1,500        |  2021-04                           |   2
  P2        |  1,000        |  2021-05                           |   1
--------------------------------------------------------------------------------
                 2,500
=============================================


I developed a query for child records for using 'Join' from Toolbox;
Child Reocrd without 'COVID-19' reason
---------------------------------------------------------------
Ins_No.  |   Reason Count(using total functionality)
---------------------------------------------------------------
  P1       |   2
  P2       |   1
===================================

And I added 'Join' functionality. But UDA-SQL-0219 "date_trunc" error occured.

How can I resolve this?

Shoul I change the way to result? or Is there any way to escape from UDA-SQL-0219 "date_trunc" error?

Please help me.

Hi,

What are the data types of the items in each query? You show an item called "Quoted Date" in your post, but it doesn't looks like a complete date? Is this just the way you are formatting it, and it really is a date, or is it a string item?

Are you using any functions or expressions in your report - particularly for the Quoted Date item?

What is the exact detailed error message you see?

Cheers!

MF.
10
Report Studio / Extract Minimum and Maximum Dates by Group
« Last post by rajua99 on 14 Jun 2021 04:56:36 pm »
Hello,

In my report i applied Group by on Segment, Job and Sub Job Number.

I want to extract max and min date for each Segment/job/sub by their group.

For example in the below sample data I want to get the min date as May 3rd and Max Date as May 21st for Sub 01 and May 13th -June 4th for Sub 09

Can you please help us with a formula to extract max and min dates.


Job No      Sub   SegmentDesc   Week   Min                   Max                  Duration   Date Worked   Start Date           End Date
                           
ACMV00   01    Supervision   Monday   May 3, 2021   May 21, 2021    18.00    May 3, 2021   May 3, 2021   May 3, 2021
ACMV00   01    Supervision   Friday                                                    May 21, 2021   May 21, 2021   May 21, 2021

ACMV00   09    Supervision   Thursday   May 13, 2021   Jun 4, 2021    22.00    May 13, 2021   May 13, 2021   May 13, 2021
ACMV00   09    Supervision   Friday                                                    Jun 4, 2021   Jun 4, 2021   Jun 4, 2021

Thanks in advance
Raju

Pages: [1] 2 3 ... 10