11

Frequently Asked Questions

{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Does Jupyter Notebooks work with virtual server as well? or only physical server?

Answer: Jupyter Notebooks work equally well on a VM as it does on a physical machine.

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
my understanding, 11.1.5 made Jupyter Notebook available on windows, however windows 10 only

Yes, that is correct.  I’m currently working on that installation on a Windows 10 PC to understand both the install process and the stability of the...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Is python the only language supported in the Cognos version of Jupyter Notebook?­
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
How reliable and stable would Windows 10 be when hosting Jupyter Server for the Cognos Environment?

Unfortunately the new Windows 10 version of Jupyter is just too new for me to have a definitive answer for how stable it could be. I have installed...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Are You Able to Install Jupyter Notebooks on a Windows Server?

Answer:

You can install Jupyter Notebooks on Windows 10, not on any of the Windows server architectures.  That might be useful for testing or a...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
­I guess it would have to understand what upside down meant as an orientation. ­

Answer: ­Right, the current implementation does not work on semantic knowledge of those types of relationships.  It is applying a convolutional...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
What about "on the fly" or if it would have to be programmed earlier/ahead of time.­

Answer: As with most machine learning tools, you would need to provide "labeled" images that identified the object as "non-defect" to retrain the...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Through machine learning, can the example iPhone/Lego program become able to understand that the green Lego is merely upside down (a different orientation) vs being defective? ­

Answer: Yes, it could.  In this case, it was just used as a simple way to simulate a defect. ­

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Are you using Planning Analytics Workspace with Planning Analytics?

Answer: PAW is very popular, and many of our clients leverage PAW with Planning Analytics

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Can you explain the difference between 11.1.5 icons, and 11.1.6? Carbon asthenic was mentioned and I would like a bit more information, if possible.

Answer: The difference in the icons is best illustrated with a screenshot.

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
­Can Data Modules be used in Event Studio in 11.1.5 or 11.1.6?

Answer: ­Per the documentation - it still integrates only with packages at this time. ­

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
­Can I use an external data source such as Excel and refresh it automatically using a report, instead of a dashboard? If so, what would be the best way to accomplish that? ­

Answer: ­You can actually use Jupyter Notebooks functionality to update an Excel spreadsheet as an automated source.  As of now though, you manually...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Is there ­any way see reports email recipients­?

Answer: It is possible to sweep the Content/Audit Stores to determine email recipients, even if they do not click back into Cognos. ­

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Would you elaborate more in how the Data Module is a replacement of the Framework Manager

Answer: Both tools organize your data assets for use in creating Reports and Dashboards.  So, in that way, their 2 tools for the same thing.  Both...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
­is security of data modules/data sets any better in 11.1.6 with support for parameter maps perhaps? ­

Answer: ­You can use macros in the security definition, but not parameter maps at this time.

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Are you able to use a data set directly in the report tool? ­

Answer: ­No, but you can include them in a Data Module and create a report using that Data Module. ­

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
­How big a dataset can be? Any size limit? ­

Answer: ­The size is limited.  In 11.1.5 and 6, IBM states that the limit is 7M rows.  In previous releases that was more like 2M rows. ­

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
­Aren't the visualizations of Tableau still way more powerful than Cognos? ­

Answer: ­Depends on who you ask.  They both have things the other cannot do.  With the introduction of the ability to import visualizations into...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Can we use active directory, in data module part of security? ­

Answer: You can - in much the same way as you do in framework manager.  BUT... only if the table(s) you are securing come from a Data Server.  You...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
­Okay, so Data Module is a replacement or alternative to something like Transformer? ­

Answer: ­More a replacement for Framework Manager.

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Are datasets/modules created strictly from excel docs or can we connect to Teradata and import our source semantic tables? ­

Answer: Datasets can be created from any Package or Data Module (so from any data source that Cognos supports).­ Teradata is definitely supported for...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Is there an easy way to organize the data in traditional structure - Database, business, presentation? ­

Answer: It can be done using folder, and then hide/show what’s needed.­

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Can data sets/modules be applied to a cross tab? If so, and the set/module is a list, can it still be applied to a cross tab? ­

Answer: ­The joins are from table to table from either the backend database or the custom tables created in Data Module. Crosstab is a reporting...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Can data sets be used in data modules directly?­

Answer: Yes indeed.  to my knowledge that's been true since 11.0.x

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Where are data modules saved, in content store database or server? Can it be modified to save on server? ­

Answer: Data Modules are stored in the Content Store. ­ They're created using the Cognos browser GUI and stored in the content store.  They are not...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Is the dataset refreshing the entire data queried every time or is it incremental changes¬?

Answer: ­It's a full refresh - there's no notion of an incremental load in a data set.­

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
How do I move or point these Docker containers  into the IBM environment ­

Answer: The only way I know of would be to upload your notebooks from the other environment into Cognos (use the Upload Files feature).  Otherwise at...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
­I want to use some of this Data Science containers for users to interact through the IBM Analytics platform? ­

Answer: You can leverage the output of Jupyter Notebooks in Dashboards and Reports.  So if you consider Jupyter Notebook outputs the result of...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
What authentication is passed to Jupyter Notebooks from Cognos? Is it the user in Cognos or is it using the Cognos service account? ­

Answer: ­The Cognos session for the user interacting with notebooks is passed to the Jupyter server.  You do not actually authenticate to the Jupyter...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
How do you integrate Docker Containers into the IBM platform? ­

Answer: All docker management and integration is handled at Cognos Notebook server level and happen at the backend.­

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
­Is it possible to incorporate plotly dash into Jupyter Notebooks within Cognos?  To make the visualizations reactive.

Answer: Yes, at the backend its basically same Jupyter Notebook as Anaconda, the way you install external packages in that Notebook, you do the same...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Is the scheduling of the data load only available in this version of Cognos?

Answer: This feature has been available since 11.1.2.    the scheduling of the data load is by virtue of the python program in the notebook... so it...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
What is the import library name for the CADataConnector? Do I need to pip install it or is part of the Anaconda package? ­
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Is the JupyterHub Orchestration sort of a Container Hub, or equivalent to? Is the Orchestration related to a clustering environment? How can load Containers say from Docker into this JupterHub?­

Answer: ­Neither - it is a method that is baked into the kernel­

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
What is a docker?

Answer: Docker is a set of platform as a service products that uses OS-level virtualization to deliver software in packages called containers. ­

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
­is Jupyter Notebooks available in caoc­?

Answer: Unfortunately, not at this time.­

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
­Is Notebook server still supported on Windows 10 ONLY? ­

Answer: The Jupyter Notebook server is only supported on Win10, or on Linux.

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
­Does Jupyter Notebooks work with CA 11.1.X on Windows?­

Answer: Yes, indeed it does.  You can install the Jupyter Notebooks server on Linux or Windows... it does not matter where you install CA (same...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
For the new data table in reports, does the expand/collapse option only work for dqm style models, or any type of data source and allow us to choose what to hide/expand? ­

Answer: ­I have used both relational and olap data in the Data Table.  Both support expand/collapse.  When you create groups in the Data Table you...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Are Data Tables equivalent to the old Active Reports? Does a Data Table report work in disconnected mode? ­

Answer: ­They're not quite the same - Active Reports can be used offline.  Data tables require that you be running connected and in HTML format. ­

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
When you update the no value in a cell do you do it one time for all the cells that are the same value or do you have to update each cell that has that value for what you want to represent?

Answer: You define this at a measure level. So, for each measure column.­

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Is there a way to change the '(no value)' content to an empty column if using strings or just a plain 0 if using numbers?

Answer: Yes, the number format for Crosstab has a property now that can be set to the value you want to display for missing or null values­.

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Is Query, Analysis, Event Studio and Cognos Workspace supported in 11 R6?

Answer: Yes, those studios continue to be supported in 11.1.6.

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Can we able to install Jupyter Notebooks on Windows Server? Gateway server is in Apache and App server is in Windows server.

Answer: You can install Jupyter Notebooks on Windows 10, not on any of the Windows server architectures.  That might be useful for testing or a...

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Can you write data to a file(table) on the iSeries or create a new file(table) with data using Jupyter notebooks using Python?
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Is Window available in 11.1.5?

Yes – with version 11.1.5 IBM released a Windows 10 Version of the Jupyter Notebook server.

Read More
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Can Jupyter server share the same server as Congos?­
{{item.accordion_expand_icon}}
{{item.accordion_collapse_icon}}
Can you import Notebook graphs and visualization into a Cognos Dash?­

Yes, you can.  When you’ve enabled the Notebook feature in your environment you will get a new tool in the Dashboard library that will allow you to...

Read More


cta image

Powerful Business Intelligence

LPA's BI Environment Health Check service offering provides a customized post-implementation review and assessment of your Cognos BI applications and environment.

Schedule My Health Check