Hello,
First timer here, was scouring the boards looking for the answer to my question but I'm not seeing anyone else with similar problems as me. I am a Cognos 8 user, writing and editing reports for the most part. My boss recently introduced me to the Go Office aspect of it where you can import parts of a report into excel. This could be very helpful to me, as I have a report I run many pages analyzing different departments cycle times. The data is then referenced on a few main tabs that summarize and compare the data over time against goals.
So the problem happens when I try to import content from my report. My report has I believe 14 pages, each has a simple list tied to a different query. When I go to import the data, for some reason, a number of my pages appear grayed out and un-checked. If I click twice, I can get a check mark there, but then when I finish, any of those grayed out pages do not have data imported, but those that show up in dark text with a checkmark, they import just fine.
I have read that trying to import report pages with prompts often doesn't work, but I dont have any prompts. My pages are all quite similar, and some of the smaller ones (not many columns in the list) are those that I cannot import. Can't find any reason anywhere for this to happen so if you have any input please give me it.
thanks in advance for any help
Wes
Quote from: WPM-CTMA on 30 Jan 2015 02:56:36 PM
Hello,
First timer here, was scouring the boards looking for the answer to my question but I'm not seeing anyone else with similar problems as me. I am a Cognos 8 user, writing and editing reports for the most part. My boss recently introduced me to the Go Office aspect of it where you can import parts of a report into excel. This could be very helpful to me, as I have a report I run many pages analyzing different departments cycle times. The data is then referenced on a few main tabs that summarize and compare the data over time against goals.
So the problem happens when I try to import content from my report. My report has I believe 14 pages, each has a simple list tied to a different query. When I go to import the data, for some reason, a number of my pages appear grayed out and un-checked. If I click twice, I can get a check mark there, but then when I finish, any of those grayed out pages do not have data imported, but those that show up in dark text with a checkmark, they import just fine.
I have read that trying to import report pages with prompts often doesn't work, but I dont have any prompts. My pages are all quite similar, and some of the smaller ones (not many columns in the list) are those that I cannot import. Can't find any reason anywhere for this to happen so if you have any input please give me it.
thanks in advance for any help
Wes
Hmmm - interesting. In theory any reporting object (list/crosstab/chart/map etc) tied to a query should be recognised as an object that is available for import. Is there anything common to the pages that are greyed out - eg are the objects embedded in tables or blocks perhaps? I can't honestly say I've seen this issue before. Does the version of Cognos for MS Office you are using match the version of Cognos BI installed on your server?
MF.
Felt I should chime in, problem was solved, basically some of my lists were named "list1" "list7", etc. and others were not. I could use the lists that were named but not those that weren't.
I have no idea how they got named, since I don't believe I named any, let alone some and not others, but basically you need to name the list for it to be used in Go Office, weird rule
Quote from: WPM-CTMA on 06 Feb 2015 10:17:26 AM
Felt I should chime in, problem was solved, basically some of my lists were named "list1" "list7", etc. and others were not. I could use the lists that were named but not those that weren't.
I have no idea how they got named, since I don't believe I named any, let alone some and not others, but basically you need to name the list for it to be used in Go Office, weird rule
I thought objects like lists were automatically named when using a standard template to create a report? I suspect either someone removed the names, or else you have a customised template somewhere that contains an un-named list object? But yes - objects need a name to be used in GO Office (and in Cognos Workspace in Cognos 10).
Thanks for the update.
Cheers!
MF.