Frequently Asked Questions


­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 refresh the external file using Update functionality.  Either a report or a dashboard will read what was most recently updated­. I will add that you would include the uploaded file(s) in a Data Module to make them available to include on a report.  A Dashboard can use uploaded files without needing to create a Data Module.

Topics: Cognos Analytics

Check Out All Our Resources in Analytics Central


How AI Infused Analytics are Transforming Business

LPA Software Solutions November 19, 2020

In 2020, we’ve learned how quickly things can change. Businesses have had to evolve, adapt, and reimagine operations in multiple ways. Analytics have become an essential tool to navigate uncharted wat...


Planning Analytics Resiliency Assessment

LPA Software Solutions October 21, 2020

We know how tough 2020 has been for your business because we've also experience great change in our industry. That's why we've created a resiliency assessment unique to your organization's current sta...


Four Ways IBM Watson is Changing the Insurance Industry

LPA Software Solutions October 6, 2020

The insurance industry has always been competitive and fast changing.  IBM Watson can help: Decreases customer churn Reduces the estimated $80 billion fraudulent claims happening right now in the US M...


Prevent Client Attrition by Leveraging IBM Watson in the Insurance Industry

LPA Software Solutions November 11, 2020

Predictive analytics can help insurance industry players to streamline claims processing, customer service, and product development and meet every other disruption with confidence and poise.   Downloa...