Print Page - Using Excel File as source for Data Module -> not possible to edit queries?

Title: Using Excel File as source for Data Module -> not possible to edit queries?
Post by: Christian85 on 22 Sep 2016 08:57:05 AM

Hi!

I imported an excel file (which went pretty smooth), created a data module with it and tried to use it in a report. As soon as I add this data module as a data source, I can't edit any Queries. I can see the existing ones, even add new ones, but can't change the content / filters whatsoever.

Is this a bug? Is this supposed to happen? Is there a workaround?

Any help is very much appreciated.

Thanks, Chris

FYI: Latest Cognos (11.0.0.3)

Title: Re: Using Excel File as source for Data Module -> not possible to edit queries?
Post by: IzzyB on 07 Oct 2016 08:35:09 AM

Unfortunately, yes this is the desired behavior. I worked around it by importing my Excel files into a database (SQL) and making an FM package from there.

Title: Re: Using Excel File as source for Data Module -> not possible to edit queries?
Post by: Christian85 on 10 Oct 2016 02:03:43 AM

Hi,

thanks for your reply! That was eventually the way I had to go too. Maybe something that will be added later on.

Chris

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Christian85 on 22 Sep 2016 08:57:05 AM