List of Contributions

Alex Santamarta

Contact Details

My Content

1 to 20 of 50+ total
Posted By Alex Santamarta Mon December 13, 2021 02:42 AM
Found In Egroup: Cognos Analytics
\ view thread
Hello Chris, In version 11.1.5 these three dots are not available. ------------------------------ Alex Santamarta ------------------------------
Posted By Alex Santamarta Fri December 10, 2021 05:20 AM
Found In Egroup: Cognos Analytics
\ view thread
Hello Jens, Thanks for the suggestion. It seems in version 11.1.5 this "Copy to Clipboard" option is not available. Or I cannot see it. I click in the three dots but nothing happens. ------------------------------ Alex Santamarta ------------------------------
Posted By Alex Santamarta Thu December 09, 2021 09:57 AM
Found In Egroup: Cognos Analytics
\ view thread
Is there a way to get the Dataset specification in JSON as it is possible to do with Data Modules (Ctrl + / + q) and Dashboards (Ctrl + .)? ------------------------------ Alex Santamarta ------------------------------ #CognosAnalyticswithWatson
Posted By Alex Santamarta Thu November 25, 2021 11:59 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, I exported my personal folders to a package (ZIP file). Inside the ZIP file there are a number of files with the extension .xmlEncrypt. Is there a way to unencrypt these files apart from importing again the package into a Cognos Content Store? ------------------------------ Alex Santamarta ...
Posted By Alex Santamarta Tue November 23, 2021 03:59 AM
Found In Egroup: Cognos Analytics
\ view thread
We just migrated to Azure AD and everything seems to work OK, but now I can't create schedules. I get this message: Your credentials are required to complete this operation. If I try to renew credentials I get a prompt to introduce user and password, which doesn't makes sense because I'm already ...
Posted By Alex Santamarta Tue October 05, 2021 06:37 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Robert. Thanks for the tip and the great explantion !!! ------------------------------ Alex Santamarta ------------------------------
Posted By Alex Santamarta Tue October 05, 2021 06:35 PM
Found In Egroup: Cognos Analytics
\ view thread
Yes, I understand. But having to fill in my details every time I want to attend an event is annoying. I'm not doing it anymore. ------------------------------ Alex Santamarta ------------------------------
Posted By Alex Santamarta Mon October 04, 2021 05:21 AM
Found In Egroup: Cognos Analytics
\ view thread
I have a user which left the company a few months ago but she's still listed as licence owner. I tried to follow these steps to recover his licence: How to remove Used License when a user will no longer be accessing Cognos Analytics Ibm remove preview How to remove ...
Posted By Alex Santamarta Mon October 04, 2021 05:13 AM
Found In Egroup: Cognos Analytics
\ view thread
Why do you need to register everytime to view a workshop? I already have an IBM signon. ------------------------------ Alex Santamarta ------------------------------
Posted By Alex Santamarta Fri September 24, 2021 12:18 PM
Found In Egroup: Cognos Analytics
\ view thread
Hello, I would like to give my power users the possibility of getting metadata information about the Cognos users and their memberships and had the idea that maybe this could be done using the REST API as a datasource in Cognos. My first impression is that it is not possible, but this is the first ...
Posted By Alex Santamarta Fri September 24, 2021 12:00 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Paul, The package contains only a relational framework manager model. But the problem is not in the report, but in the validation in Framework Manager. Even though Framework Manager returns this error during the validation of the expression and the validation of the package: XQE-V5-0005 Identifier ...
Posted By Alex Santamarta Tue September 21, 2021 10:40 AM
Found In Egroup: Cognos Analytics
\ view thread
My experience is that if the expression inside the queryValue() macro returns more than one value (with or w/o filter), it will take only one of them. ------------------------------ Alex Santamarta ------------------------------
Posted By Alex Santamarta Tue September 21, 2021 10:35 AM
Found In Egroup: Cognos Analytics
\ view thread
I don't think the syntax is wrong. If I use it in a Cognos report instead of Framework Manager it works and I don't get any error. I put this queryValue() macro in a filter in a Query Subject and published the package (the package also gave me a validation error) and then made a report with the query ...
Posted By Alex Santamarta Tue September 14, 2021 01:11 PM
Found In Egroup: Cognos Analytics
\ view thread
Hello, using here Cognos Analytics 11.1.5 and Framework Manager 11.1 with a model with DQM. Anybody knows if the queryValue() macro is supported in Framework Manager. I'm trying to use it but I always get this error: XQE-V5-0005 Identifier not found I have tried with #sq(queryValue('[Namespace].[Query ...
Posted By Alex Santamarta Mon August 30, 2021 08:26 AM
Found In Egroup: Cognos Analytics
\ view thread
YES!!! Thanks! ------------------------------ Alex Santamarta ------------------------------
Posted By Alex Santamarta Sat August 28, 2021 04:11 AM
Found In Egroup: Cognos Analytics
\ view thread
You are right! It works with IE ------------------------------ Alex Santamarta ------------------------------
Posted By Alex Santamarta Fri August 27, 2021 09:46 AM
Found In Egroup: Cognos Analytics
\ view thread
I have created a Data Set of about 6 million rows out of a Data Module on a relational database of more than 100 million rows. Now I need to create a new Data Module to be able to create reports on this Data Set. But I want to have separate entities/dimensions in the Data Module, as the user expects ...
Posted By Alex Santamarta Fri August 27, 2021 09:35 AM
Found In Egroup: Cognos Analytics
\ view thread
It used to be possible to copy queries across Reports until version 10 with copy/paste. This is not possible in version 11. Also copy group of query items, ... How do you manage that? ------------------------------ Alex Santamarta ------------------------------ #CognosAnalyticswithWats ...
Posted By Alex Santamarta Fri August 27, 2021 09:24 AM
Found In Egroup: Cognos Analytics
\ view thread
It use to be possible (until version 10) to copy the cell value of a List Report to the clipboard. How to you manage to do this now with version 11? Exporting the report to Excel or PDF is a possible solution, but a bit annoying. ------------------------------ Alex Santamarta --------------- ...
Posted By Alex Santamarta Fri August 27, 2021 03:04 AM
Found In Egroup: Cognos Analytics
\ view thread
Hello, I can't get access to this functionality when working with Data Sets: Creating data sets In this page, it says "To view the column expression, click the More icon ···, and select Edit Query Expression". In my case I click on the ··· and nothing happens. ​​I'm currently using version ...