List of Contributions

Magnum BI 83

Contact Details

My Content

1 to 20 of 32 total
Posted By Magnum BI Tue October 26, 2021 01:41 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi all, I would liketo know: When i save and load a dataset where is saved the dataset? It is saved in the content store?only the specifications ( xml?json?) Like a normal report spec Or is it saved all togheter,containing not only the specifications but also the Data loaded (like an active report ...
Posted By Magnum BI Wed September 29, 2021 03:36 PM
Found In Egroup: Cognos Analytics
\ view thread
The following message has been sent to you in response to your discussion message. View inbox and reply to the message online Message From: TREVOR COMEAU Hi Magnum, This is entirely unsupported and could change with a UI update. I think this will remove the SQL option for all users. . ...
Posted By Magnum BI Wed September 29, 2021 03:32 PM
Found In Egroup: Cognos Analytics
\ view thread
Thank you Trevor for sharing this solution...but i need a more easy way.this would be a good features to have for a new cognos release. Robert, I am full of good ideas for cognos... follow me and support me;) ------------------------------ Magnum BI https://www.linkedin.com/in/magnum-bi-0297a2214 ...
Posted By Magnum BI Mon September 27, 2021 03:33 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi, Yes i don't want for security reasons that my users are able to see the sql of report and his queries. Is it handle this? ------------------------------ Magnum BI https://www.linkedin.com/in/magnum-bi-0297a2214 ------------------------------
Posted By Magnum BI Sat September 25, 2021 08:29 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, Is it possible to hide the Show Generated sql property? Thanks ------------------------------ Magnum BI https://www.linkedin.com/in/magnum-bi-0297a2214 ------------------------------ #CognosAnalyticswithWatson
Posted By Magnum BI Mon July 19, 2021 12:56 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Jens, thanks for this tip, i hope that ibm will renew and expand this part of reporting functions and make it more clear when they are available e.g. your tip i wasn't aware of this possibility with datamodule. I hope also that a new kinda of dimensional layer like DMR will be feasible also with ...
Posted By Magnum BI Sat July 17, 2021 11:09 AM
Found In Egroup: Cognos Analytics
\ view thread
HI community, please support and vote this idea. I would like to have all the powerful sql window functions available inside reporting like lead and lag. Actually as of today, there is only sum and rank i think as possibilities. A need that could save us from developing dmr models and going to use ...
Posted By Magnum BI Tue July 13, 2021 07:16 AM
Found In Egroup: Cognos Analytics
\ view thread
FM PACKAGE( ONLY RELATIONAL, DQM)...i can't see how to use LEAD and LAG. I would like that this useful windows functions could be called directly using cognos summary functions without using for example dmr or dimensional . ------------------------------ Magnum BI --------------------------- ...
Posted By Magnum BI Tue July 13, 2021 04:23 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, I am using cognos 11.1 with a relational model, is it possible to use Sql window function like LEAD,LAG... inside reporting without using sql objects with native or pass-thru sql sintax? Using running-total or rank present in the list of "Summaries", I see that cognos is using windows functions ...
Posted By Magnum BI Thu July 01, 2021 04:25 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi cognos experts, I have tried to read and understand a pdf on tips for improving performance of cognos 11.1.7.this guide is present on accelerator catalog. It talks about a "dataset service". What is the role of this service?is another name for refering to query service ? Or is the "compute service" ...
Posted By Magnum BI Thu June 24, 2021 05:16 PM
Found In Egroup: Cognos Analytics
\ view thread
hi everyone, I have an existing FM package and an uploaded excel file with two columns. (ID, GroupDescrip)in a data module without joins defined in it,only exposed to users. So i have made a report built using this data module and joined two queries ,one using items from package and one using excel ...
Posted By Magnum BI Sun June 20, 2021 11:07 AM
Found In Egroup: Cognos Analytics
\ view thread
Thanks again mr Dostal.I don't know about the flipper config folder. anyway for the content store solution, it needs a parameter to export and import also the configuration settings. https://www.ibm.com/support/pages/how-include-configuration-settings-when-doing-exportimport-cognos-analytics ...
Posted By Magnum BI Sat June 19, 2021 09:40 AM
Found In Egroup: Cognos Analytics
\ view thread
Hello everybody, still here because I don't have this information anywhere. The case is this: we have saved some advanced settings such as RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE in the dispatcher services and we have changed some parameters such as Maximum Number of Processes and Connections for report ...
Posted By Magnum BI Thu June 17, 2021 04:16 AM
Found In Egroup: Cognos Analytics
\ view thread
A big thank you! Mr. Van der Meer (Nederland surnames are very particulare,nice)... this is what i needed, i wasn't aware of it. Dank u ------------------------------ Magnum BI ------------------------------
Posted By Magnum BI Wed June 16, 2021 02:27 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi experts and cognos users, I am asking help for a request coming from my customer: Is it possibile to restrict email recipient using cognos configuration to have only permitted a particular domain e.g. blablabla@permittedDomain.com. Even if the user input directly a recipient the system will have ...
Posted By Magnum BI Thu May 13, 2021 07:37 AM
Found In Egroup: Cognos Analytics
\ view thread
Unfortunately, I have to agree with Marteen and Robert in the sense that I do not see a sudden change. I also followed the live stream from PM square and was disappointed. Ibm seems to be looking at another path towards a future with more AI and far away real needs. Our voice does not come loud or ...
Posted By Magnum BI Thu April 29, 2021 08:31 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Melody,you have been a great help ! Thanks ------------------------------ Magnum BI ------------------------------
Posted By Magnum BI Tue April 27, 2021 03:09 AM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson
Posted By Magnum BI Tue April 27, 2021 03:09 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi guys, Is there any way possible to have the EXCEL Format option to wrap the title of the columns especially those with headers more long than their content? I would like to have the same behaviour and estetic as in HTML but for Excel, no luck yet. i have attached the actual situation and the ...
Posted By Magnum BI Thu April 22, 2021 10:20 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi All, sifting through the ibm documentation I found this page where we talk about this object. https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=dimensionally-show-data-specific-time-periods I have never noticed this element in the reporting. How can it be used? It is similar to as_of_date ...