No, it's comments.  It's like Jane did a great job on being a team player....

Quote from: jsibley on 22 Oct 2024 12:46:16 PMI have 4 competencies that I've pulled from 4 different queries.  I did multiple joins and was able to get them be in one sing row after I used coalesce and used a 0...n for cardinality in both directions.  Now I'm at the point of trying to add them together into a single cell but I'm getting an error message I've never seen. 

RSV-VAL-0010 Failed to load the report specification.CCL_ASSERT(m_nodelImpl!=NULL);  The error I get is the same if I try adding all 4 together as it is when I only add 2. 

When you refer to adding them together, is that a mathematical addition (so you want to sum numbers) or are you trying to concatenate strings together? What are the data types of the items you are using in the calculation?

Cheers!

MF.

I have 4 competencies that I've pulled from 4 different queries.  I did multiple joins and was able to get them be in one sing row after I used coalesce and used a 0...n for cardinality in both directions.  Now I'm at the point of trying to add them together into a single cell but I'm getting an error message I've never seen. 

RSV-VAL-0010 Failed to load the report specification.CCL_ASSERT(m_nodelImpl!=NULL);  The error I get is the same if I try adding all 4 together as it is when I only add 2. 

Quote from: sirdaclan on 22 Oct 2024 07:54:09 AMHi,

I wasn't aware of the Section feature before. I just tested it, and it allows me to create separate lists for each year I need. However, the table I want should look like this:
Y-axis: Distribution of the variables (0-500, 500-1000, ...)
X-axis: Different categorizations (x, y, ...)

When I try to insert this cross table into the list, I always encounter an error. I'm relatively new to Cognos, so this might be an issue on my end, or perhaps cross tables don't work in this type of list.

Thanks for your help!

Ah, ok - crosstab rather than list. One option would be to create a list containing just the Year column, then drag a crosstab into the list as a new list column. You'll need the Year item in the query of your crosstab, then create a master/detail link between the crosstab and the list. Finally, section the list on Year.

Another option - if you want a separate crosstab on a different report page - is to create a crosstab, then use a Page Set based on Year to drive different yearly crosstabs on different pages. Again, you'll need Year in the query of the crosstab, and probably master/detail to the page set query.

Cheers!

MF.

Hi,

I wasn't aware of the Section feature before. I just tested it, and it allows me to create separate lists for each year I need. However, the table I want should look like this:
Y-axis: Distribution of the variables (0-500, 500-1000, ...)
X-axis: Different categorizations (x, y, ...)

When I try to insert this cross table into the list, I always encounter an error. I'm relatively new to Cognos, so this might be an issue on my end, or perhaps cross tables don't work in this type of list.

Thanks for your help!

Quote from: sirdaclan on 22 Oct 2024 06:09:57 AMHi all,

I want to create a report that displays individual tables for each year from 2014 to 2024. This means there should be 10 separate tables, each showing data for a specific year.

Is there an option to enter the years as parameters so that when I run the report, 10 tables are automatically displayed? Otherwise, I would need to copy the table 10 times and manually adjust the filters.

Thanks for your help!

Hi,

Have you looked at the "Section" feature for a list report? This allows you to take a single list and split it into different sections based on data item(s). Is this what you need?

Cheers!

MF.

Hi all,

I want to create a report that displays individual tables for each year from 2014 to 2024. This means there should be 10 separate tables, each showing data for a specific year.

Is there an option to enter the years as parameters so that when I run the report, 10 tables are automatically displayed? Otherwise, I would need to copy the table 10 times and manually adjust the filters.

Thanks for your help!

Quote from: ArnaudStephanHTH on 30 Sep 2019 06:55:05 AMI found a solution, although I'm sure there are better ways.

First I created a new data item to categorize the ranks : CASE WHEN [Rank] < 6 THEN [Rank] ELSE 999 END
Then I computed the total based on this new data item :total ([Quantity] for [Rank Inf 5])

I have the same use case, but this solution is not working properly on Cognos 12.0.3.

Totals of top X items vs Other are not computed correctly, probably because Rank is being determined not in the beginning, but in parallel with Total calculation.

Solve order property of data items does not help either.

We have recently began using Cognos with IIS and AD for authentication.  We have internal and external users.  For external, we're using a reverse proxy thru our hosting provider to lock down the traffic for external users.  I am currently using basic authentication in IIS.

Currently internal users are fine.  However, externals are having an issue.   After putting in credentials and logging in, it seems to be logging in, but then I just have a spinning circle and the page seems to be refreshing every few seconds but never goes into Cognos.  Has anyone experienced this?

First and foremost, thanks in advance for any recommendations and solutions.

Using COGNOS Analytics v11.2.4

Background, have a report with 3 pages, those being:
Summary
Items
Orders

Desire to schedule this report to email a list of recipients as:

Summary-This would be HTML in the email body
Items & Orders-These pages would be 2 separate sheets within Excel.

This executes without issue when rendering all 3 pages to Excel, however when attempting the desired output above, the email only contains hyperlinks.

Attempted to follow steps found here in an older post: https://www.cognoise.com/index.php?topic=34153.0

Within Page Properties:
Summary- Created boolean variable 'Render for HTML'
ReportOutput () = 'HTML'Set render variable to Render for HTML

Items and Orders Pages-Created boolean variable 'Render for Excel'
ReportOutput () = 'SpreadsheetML'Set render variable to Render for Excel

Created schedule with both HTML and Excel toggled on, along with send report by email. Confirmed message body is indeed clean, no spaces or empty characters found.

Report is delivered, however no Excel attachment or HTML in the body. Anyone have any suggestion or cannot identify what I may have missed. Appreciate any feedback.