List of Contributions

Jenifer Broughton

Contact Details

My Content

1 to 20 of 50+ total

Cognos 11.1.7 Crosstab drill thru on measure where field is not being used in crosstab

Posted By Jenifer Broughton Fri July 28, 2023 06:22 AM
Found In Egroup: Cognos Analytics \ view thread
Is it possible to drill thru from a crosstab calculated measure based on a field not on the crosstab report? Thanks, Jen ------------------------------ Jenifer Broughton ------------------------------

RE: Cognos 11.1.7

Posted By Jenifer Broughton Wed July 26, 2023 02:12 PM
Found In Egroup: Cognos Analytics \ view thread
@Marc Reed I am very grateful for your quick assist on this! The calculation you gave me is now providing the correct numbers in the right quarters. I can't thank you enough for the quick and correct response!!!! Thank you Thank you Thank you!! Jen ------------------------------ ...

RE: Cognos 11.1.7

Posted By Jenifer Broughton Wed July 26, 2023 01:09 PM
Found In Egroup: Cognos Analytics \ view thread
Thank you!! I have been in meeting after meeting today. Thanks for the extra info. I will digging into this more shortly. You have been wonderful! ------------------------------ Jenifer Broughton ------------------------------

RE: Cognos 11.1.7

Posted By Jenifer Broughton Wed July 26, 2023 10:28 AM
Found In Egroup: Cognos Analytics \ view thread
@Marc Reed Thanks for the quick reply.. Let me create a list and see if the new calc works there. ------------------------------ Jenifer Broughton ------------------------------

RE: Cognos 11.1.7

Posted By Jenifer Broughton Wed July 26, 2023 10:18 AM
Found In Egroup: Cognos Analytics \ view thread
@Marc Reed Hi Mark. It's calculating, but the numbers are not right. ------------------------------ Jenifer Broughton ------------------------------

RE: Cognos 11.1.7

Posted By Jenifer Broughton Wed July 26, 2023 09:31 AM
Found In Egroup: Cognos Analytics \ view thread
@Marc Reed Thank you. Let me try this!!! Back to you soon! ------------------------------ Jenifer Broughton ------------------------------

RE: Cognos 11.1.7

Posted By Jenifer Broughton Wed July 26, 2023 07:31 AM
Found In Egroup: Cognos Analytics \ view thread
@Marc Reed Hi Mark, Thanks for the reply. Maybe I am not following. I need the line2 that totals 532 for that total of 532 to appear on line3. And the line 3 total to appear on line 4 etc.. ------------------------------ Jenifer Broughton ------------------------------

RE: Cognos 11.1.7

Posted By Jenifer Broughton Wed July 26, 2023 07:29 AM
Found In Egroup: Cognos Analytics \ view thread
@Logan Whitaker Thanks for this info. I have used the lag in the past and was hoping to be able to use here. I cannot. Like you mention, I am not able to. This final query has 3 unions in the backend. None of which are sql. Unfort, I only have until friday to complete this report. I'm racking my brain ...

Cognos 11.1.7

Posted By Jenifer Broughton Tue July 25, 2023 07:44 PM
Found In Egroup: Cognos Analytics \ view thread
I have a complex crosstab where now I need a row above to calculate and provide a numeric value to the next row. I am unsure how to accomplish this easily. This crosstab has case statements for the date buckets. It is using a relational model. Any ideas would be helpful. ------- ...

Are there any videos that are specific to navigating the in Cognos 11.2 vs 11.1.7?

Posted By Jenifer Broughton Tue July 25, 2023 08:49 AM
Found In Egroup: Cognos Analytics \ view thread
We have many users that, even though we provided a user document, are still having issues navigating the new environment. We upgraded from 11.1.7 to 11.2.4. I was hoping to find just a high level overview? Thanks, Jenifer ------------------------------ Jenifer Broughton ------ ...

Drill Thru from crosstab to a Union query based on calculated Fiscal Period

Posted By Jenifer Broughton Mon April 17, 2023 04:53 PM
Found In Egroup: Cognos Analytics \ view thread
Version Cognos 11.1.5 Does anyone have advice on creating a drill thru from a crosstab to a separate query using a "Fiscal Period" calculation? The Union has one query for open work orders and one for work orders that due in prior quarter but completed in the next fiscal quarter. I had to manually ...

RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

Posted By Jenifer Broughton Fri March 10, 2023 01:08 PM
Found In Egroup: Cognos Analytics \ view thread
@HENK CAZEMIER Thanks Henk! I do not have access to the database to create a new table or view. I did try everything I could think of in Cognos but with no luck. I'll reach out to our db and have them do some testing. Thank you so much for your quick response! ------------------------------ ...

RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

Posted By Jenifer Broughton Fri March 10, 2023 09:40 AM
Found In Egroup: Cognos Analytics \ view thread
@HENK CAZEMIER Hi Henk. Thanks for this info. I tried it and got a expected CHAR got LONG error message. ------------------------------ Jenifer Broughton ------------------------------

RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

Posted By Jenifer Broughton Thu March 09, 2023 11:24 AM
Found In Egroup: Cognos Analytics \ view thread
@HENK CAZEMIER Ok, I will request this be done on my end. Also, some added information. There is a field in the report (a comments field) that is being defined as a 'Rich text item'. This is the field causing the issue. Any work around to have I could apply in the report to fix the formatting other than ...

RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

Posted By Jenifer Broughton Thu March 09, 2023 11:19 AM
Found In Egroup: Cognos Analytics \ view thread
@Logan Whitaker it's version 11.1.5 ------------------------------ Jenifer Broughton ------------------------------

RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

Posted By Jenifer Broughton Thu March 09, 2023 10:47 AM
Found In Egroup: Cognos Analytics \ view thread
Additional information: RQP-DEF-0177 An error occurred while performing operation 'sqlROpen' status='-58'. UDA-SQL-0601 Cannot access blob data of previous rows, since the query contains blob column "rc19" that requires sequential access. ------------------------------ Jenifer Broughton ...

Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

Posted By Jenifer Broughton Thu March 09, 2023 09:45 AM
Found In Egroup: Cognos Analytics \ view thread
I have a report that runs. It has 2 pages. After paging down several pages which appear fine. There comes a point when I then page down and get the following error message. Anyone have any ideas? CCLAssertError:0:Fatal: CCL_ASSERT_NAMED(false, "Generic ident/value parse can only ...

RE: Cognos 11 How to copy report names from a folder

Posted By Jenifer Broughton Wed February 15, 2023 08:07 AM
Found In Egroup: Cognos Analytics \ view thread
I'm using 11.1.7 and wasn't able to get this to work. Thanks, Jen ------------------------------ Jenifer Broughton ------------------------------

Cognos 11 How to copy report names from a folder

Posted By Jenifer Broughton Tue February 14, 2023 03:56 PM
Found In Egroup: Cognos Analytics \ view thread
Does anyone know of an easy way for a user to copy the report names from a folder within Cognos? Thanks, Jen ------------------------------ Jenifer Broughton ------------------------------

Cognos 11.1.7 - Combine multiple rows into one

Posted By Jenifer Broughton Mon January 23, 2023 09:43 AM
Found In Egroup: Cognos Analytics \ view thread
I have done this in the past, but I just can't remember how exactly. I have 2 rows of data for one unique address. I remember using a running-count based on the unique field and then creating new fields based on the running count. I then used the min and max aggregation property for the fields depending ...