Search results for query: *

Hi Does anybody have the ability to run reports over the audit database so they can view cube usage by user and date? I've had a trawl on the web and I only found something for PowerPlay in 8.4. This is no good to me as we are Analysis Studio 8.3 users! Is it just a case of upping our logging...

Hi We have a bunch of scheduled Report Studio reports that run daily. Last week we had to restore the Content Store because somebody (not me!) took the development data sources over to production during a content export/import. Ever since then these scheduled report have been failing. However...

Hi I'm hoping somebody will be able to help me with a complex report I am writing in Report Studio (well, it's complex to me!). I have a list report which starts with product code followed by a number of measures e.g. revenue, margin, quantity, ASP. The source of this data is a relational...

Hi I am wondering what the best method of producing iqds is. With Cognos 7 we obviously just used Impromptu to create IQDs. When we migrated to Cognos 8 we continued to use Impromptu to modify existing iqds. Now I am creating new cubes, but I think it would be a bit backwards to continue to...

Hi I have a very simple SSIS Package which truncates a SQL table and downloads a file from the AS400...that's it! However, compared with our DTS package this is very slow (approx. twice as long). I have managed to narrow it down to the number of columns that are downloaded from the file, 87...

Hi I'm still using Impromptu at the moment so some of you may have to think back a bit. I have a calculated column in my column e.g. Sales/Total Sales) *100 so that I get a percentage. I then have a prompt for this result so I can select a range e.g. from 1 to 5 % However when I check my...

Hi I have a report which I want in Excel with the formatting that I have in Impromptu (i.e. groupings). This report has just over 34,000 rows but when I export to Excel it spreads itself over 3 sheets with only 16,384 rows on each sheet. Anybody know why it doesn't put it all into the one...

Hi I have a user who has created a subset of a number of categories in a dimension. After a cube rebuild some of these categories are removed from the subset even though they are still in the dimension. Some categories are still there but his report is not correct because of the missing ones...

Hi We have just upgraded our Cognos environment to 7.3 but we are having a problem with one of our cubes. I have done a search on this forum and I see JGirl had exactly the same problem as we have thread401-1006406. Can anyone help out with this one at all? Thanks

Hi We have a database which is rarely used now but taking a lot of disk space (19Gb). I have truncated a lot of tables and ran the Shrink Database option (right click on database) but db is still 19GB. When I go into the properties for the Data File the Space Allocated (MB) says 19494. When...

I have used the following code which somebody kindly posted on this forum a while back. This works perfectly for me but is there a way of not having to hardcode username and password (see cn.open line below)? For security reasons I do not think I will be able to put this code live with a...

Hi I am trying to pull through greek characters in a SQL table. The source is a file in an iseries and I am using ODBC to connect. When I am in DTS, I preview the file and it comes out with incorrectly. However, I am able to import the data into an Excel file and when I preview this in DTS...

Hi Wondered if anybody could help. My SQL skills are not exactly advanced so any help would be appreciated. We have our transactional systems on the iseries and we bring all the data we need for reporting into SQL Server. Soon we will be bringing Russia and Greece onto the system and one of...

Hello Has anyone got dynamic column headers (for list report) to work in ReportNet? The report I am working on has the first 3 columns as the 3 periods for the previous quarter and I want these labelled with the period names autmomatically. Similarly with the next 3 periods, these are the...

Hello When we export to PDF in PP Web (7.3 MR1) all we get is a white screen. If in Adobe Reader I deselect the option to open PDF in browser (so opens a session of adobe reader) the pdf displays fine in the application. Although this is fine as a work around it is not ideal. I can only...

Hello We have recently upgraded our environment upto 7.3 but have since had a problem with Upfront. When our cubes build and publish (using scripts) in the morning the Modified date is changing on cubes but not for any of their related reports. This only happens with reports created before...

I'm just a write up of what extra features our users will get with 7.3 based on the pdf's on the Cognos website. I am just reading about this Dimension Viewer toolbar and adding categories to rows/columns/nesting but I can't work out whether this is similar to reporter mode in the client. Do...

Following the posts on how to export lists from Access Manager into a text file. Does anyone know how to export the content of a folder from access manager rather than the root userclass which is what the example on the cognos website does? I find that the users are repeated if I export from...

Has anybody ever tried using a reporting tool (such as Cognos) over Project Central? I have been asked to investigate our current manual (copy and pasting data from Projects (.mpp's) month end reporting using the data within Project Central. I know that it is a SQL Database and I have the...

I am having a play in Impromptu 7.1 having gotten to know 6.1 very well. When I put in a prompt into a report as a type-in date the default puts in todays date in the format YYYY-MM-DD and when the prompt comes up when running the report it also comes up as YYYY-MM-DD. In 6.1 even though the...