List of Contributions

MELODY ALBERTI

Contact Details

My Content

1 to 20 of 29 total

RE: What would "perfect" Cognos Analytics?

Posted By MELODY ALBERTI Thu April 04, 2024 09:07 AM
Found In Egroup: Cognos Analytics \ view thread
I'd love for EventStudio to be updated. Right now it's in some type of older format and very slow and prone to issues with updating. Unless there is another way to schedule multiple reports to be sent in one email to multiple people(?) Please add trend lines and some other capabilities that only exist ...

RE: Trendline on Chart object not visible in Excel - any option/workaround?

Posted By MELODY ALBERTI Fri March 15, 2024 08:11 AM
Found In Egroup: Cognos Analytics \ view thread
Thanks Robert, I appreciate the info! ------------------------------ MELODY ALBERTI ------------------------------

RE: Trendline on Chart object not visible in Excel - any option/workaround?

Posted By MELODY ALBERTI Fri March 15, 2024 07:59 AM
Found In Egroup: Cognos Analytics \ view thread
Thanks Patrick! Yes, I was aware of that page, but I didn't see anything regarding trendlines. Also, I thought that page applies to v12 (or v11) and not the v8/v10 version that I believe the "Charts" object is based on. Let me know if I'm incorrect here, thanks. ------------------------------ MELODY ...

RE: Trendline on Chart object not visible in Excel - any option/workaround?

Posted By MELODY ALBERTI Fri March 15, 2024 07:55 AM
Found In Egroup: Cognos Analytics \ view thread
Thanks German! What is CAFE? Unfortunately, I don't have access to Cognos for MS Office. I will try your suggestion for calculating the trend and adding it as another line to the chart. ------------------------------ MELODY ALBERTI ------------------------------

Trendline on Chart object not visible in Excel - any option/workaround?

Posted By MELODY ALBERTI Thu March 14, 2024 04:34 PM
Found In Egroup: Cognos Analytics \ view thread
Hi everyone, I'm using Cognos v11.2.4 and working on a report that contains various charts. From what I've been able to gather after researching this, it looks like: Trendlines are only available if you use the legacy Charts object (not yet available in v11 visualizations), and You can only see ...

RE: Last Month (Filter)

Posted By MELODY ALBERTI Wed May 05, 2021 08:17 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, here's what I use (same as Rene): [my_date] between _first_of_month(_add_months(current_date,-1)) and _last_of_month(_add_months(current_date,-1)) Regards, Melody Alberti ------------------------------ MELODY ALBERTI ------------------------------

RE: EXCEL NOT WRAPPING LONG TITLES

Posted By MELODY ALBERTI Wed April 28, 2021 09:28 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, I believe you need these 2 settings configured in both the BatchReportService and ReportService services: RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL: True RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL: True Once these are done, you'll need to set the Size & overflow setting on each column that ...

RE: HTML report (with pie chart visualization) being sent as MHT file in Event Studio (Cognos v11.1.6)

Posted By MELODY ALBERTI Mon April 26, 2021 11:06 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Robert, disregard my previous message, I found it. :) Regards, Mel ------------------------------ MELODY ALBERTI ------------------------------

RE: HTML report (with pie chart visualization) being sent as MHT file in Event Studio (Cognos v11.1.6)

Posted By MELODY ALBERTI Mon April 26, 2021 10:59 AM
Found In Egroup: Cognos Analytics \ view thread
Thanks so much Robert!! When I inserted the chart into the report, I selected "Visualization" from the insertable objects: I don't see where I can change the chart engine on my report or insert a regular chart. Can you tell me where you see the dropdown that you sent the image of? Thanks and regards, ...

HTML report (with pie chart visualization) being sent as MHT file in Event Studio (Cognos v11.1.6)

Posted By MELODY ALBERTI Mon April 26, 2021 09:26 AM
Found In Egroup: Cognos Analytics \ view thread
Hi everyone, I created an Event Studio agent to send out some reports on a weekly basis. I am trying to send one of those reports in HTML format as it contains a visualization (pie chart). However, in the email that's generated, the file is an MHT file (not HTML) and when I open that in the browser, ...

RE: Formatting questions for pie chart in Cognos 11.1 R6 dashboard

Posted By MELODY ALBERTI Tue April 13, 2021 02:28 PM
Found In Egroup: Cognos Analytics \ view thread
Thanks SO much Robert! Looks like that "Item label format" setting was added in R7 as it's missing from my view in R6: I will definitely get the IBM support ticket created for the bug between the I.E. and Chrome browsers. I may create a 2nd support ticket to ask about changing the formatting of the ...

Formatting questions for pie chart in Cognos 11.1 R6 dashboard

Posted By MELODY ALBERTI Tue April 13, 2021 09:18 AM
Found In Egroup: Cognos Analytics \ view thread
Hi everyone, I have some questions around formatting a pie chart in a dashboard I created that looks like this: 1. Instead of showing the legend, I'd like to show the segment/series name above each of the percentage values. Is there a way to do that? 2. How can I change the formatting of the percentage ...

Few questions about pie chart in dashboard (Cognos 11.1 R6)

Posted By MELODY ALBERTI Thu April 01, 2021 02:57 PM
Found In Egroup: Cognos Analytics \ view thread
​Hi everyone, I have this pie chart I created in a dashboard: I have a few questions about formatting that for the live of me I'm not able to figure out or find any answers for online: 1. Instead of showing the legend, I'd like to show the segment/series names above the data percentage numbers. How ...

RE: How to set the name of each tab in Excel (report with multiple report references)

Posted By MELODY ALBERTI Thu March 04, 2021 01:31 PM
Found In Egroup: Cognos Analytics \ view thread
Thanks so much Thomas! I will definitely ask our IT team to implement these settings in our test environment to see if they help. Each of the 3 reports that are being referenced in my example do not have any groups in them. Regards, Mel Alberti ------------------------------ MELODY ALBERTI ---- ...

How to set the name of each tab in Excel (report with multiple report references)

Posted By MELODY ALBERTI Thu March 04, 2021 11:13 AM
Found In Egroup: Cognos Analytics \ view thread
Hi everyone, I've tried to figure this out myself but am not able to. I have a report in Cognos v11.1 R6 that has 3 report references (3 pages each pointing to a different report): When I run this report in Excel format, I see 3 tabs, one for each report reference. However, the names of the tabs ...

RE: how to incorporate "not exists" into query/filter in Cognos Analytics 11.1.6

Posted By MELODY ALBERTI Tue July 28, 2020 09:55 AM
Found In Egroup: Cognos Analytics \ view thread
Thanks Nigel! ------------------------------ MELODY ALBERTI ------------------------------

RE: how to incorporate "not exists" into query/filter in Cognos Analytics 11.1.6

Posted By MELODY ALBERTI Wed July 22, 2020 04:51 PM
Found In Egroup: Cognos Analytics \ view thread
Never mind everyone, I figured it out: not (criteria1 like '%xyz%') or criteria1 is null ------------------------------ MELODY ALBERTI ------------------------------

how to incorporate "not exists" into query/filter in Cognos Analytics 11.1.6

Posted By MELODY ALBERTI Wed July 22, 2020 02:12 PM
Found In Egroup: Cognos Analytics \ view thread
Hi everyone, I have a SQL Server query where I'm generating some counts of records. In that query, I'm using "not exists" in the where clause to exclude records that match specific criteria. In Cognos Analytics, I tried using the "not exists" statement but got an error when running the report. I then ...

Any way to enable word-wrap in Excel output or somehow control column widths? (11.1 R6)

Posted By MELODY ALBERTI Thu June 25, 2020 08:13 AM
Found In Egroup: Cognos Analytics \ view thread
Hi everyone, I've done a lot of Googling and searching in this forum, but I'm not able to find out how to change how Cognos exports to Excel format (not Excel Data). It seems that however long the longest data is in each column, that's how long the column will be in the Excel export. I've tried sizing ...

RE: How to calculate week of a month (instead of year)

Posted By MELODY ALBERTI Tue June 09, 2020 12:36 PM
Found In Egroup: Cognos Analytics \ view thread
Thanks Henk! That is very helpful. Here's what I came up with (if it doesn't work right, I'll look at using your formula): _week_of_year ([Created Date]) - _week_of_year ( _first_of_month ([Created Date])) + 1 ------------------------------ MELODY ALBERTI ------------------------------