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

[Christian85]

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)

[IzzyB]

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.

[Christian85]

Hi,

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

Chris