List of Contributions

Amy Rivito

Contact Details

My Content

1 to 7 of 7 total
Posted By Amy Rivito Jun 22, 2020 12:32 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Rich! Ironically, this is something we need to do in Excellus as well and I've been able to set it up so that only Administrators have the option to attach the output. Here's how I did it Modify the install_location /templates/ps/portal/system.xml by adding this to the system param <param ...
Posted By Amy Rivito Dec 13, 2019 10:28 AM
Found In Egroup: Cognos Analytics
\ view thread
I think you can modify the ..\configuration\CQEConfig.xml file to include this in the QueryEngine section. <!-- Generation of comments in native sql and cognos sql.--> <!-- entry name="GenerateCommentInNativeSQL" value="1"--> <!-- ( default(off)=0, on=1) --> <!-- entry ...
Posted By Amy Rivito Jul 19, 2019 12:20 PM
Found In Egroup: Cognos Analytics
\ view thread
Ok, I think I resolved this issue....with 10.2.2, synonyms can be used as a regular reference. With 11, you need to explicitly indicate the schema it comes from. For example, in 10.2.2, the Schema value in FM is "EDW", which in the EDW schema in Oracle, our table is really a synonym to "EDWB". With ...
Posted By Amy Rivito Jul 19, 2019 10:27 AM
Found In Egroup: Cognos Analytics
\ view thread
​Hi Denny, Thank you for your reply. After converting to DQM and verifying with no errors, I'm still getting the same error in Dashboarding. ------------------------------ Amy Rivito ------------------------------
Posted By Amy Rivito Jul 16, 2019 12:06 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi all, When attempting to create a dashboard, I'm getting this error which I believe is related to shortcuts and aliases in our FM model The relation 'T_DATE_DIM' could not be found in the model. Reason: 'XQE-MSR-0023 'T_DATE_DIM' needs to be in the imported schema 'EDW' in the connection 'Enterprise ...
Posted By Amy Rivito Dec 7, 2018 9:01 AM
Found In Egroup: Cognos Analytics
\ view thread
​This won't help when the services are already down, but if you want to alert them ahead of time, you can create a dummy report and run in the background. Then set it to Send the report by email. Edit the email options, select the Everyone role or whatever role you want, enter your text in the email ...
Posted By Amy Rivito Oct 18, 2018 10:13 AM
Found In Egroup: Cognos Analytics
\ view thread
So when will it be available for download? ------------------------------ Amy Rivito ------------------------------