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 Thanks for the response. I ran the query and no records were returned. I take it that is a good thing?

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...

In my case I have different queries for current and previous year. Current Year is the prompt value. Previous Year = Current Year - 1. These are set in the filters. Therefore periods from prior years won't be included. Cheers

I had to do a similar exercise for my report. I can't use the date functions because our financial periods can spread over 2 different months. It's probably not the best way but it kinda works! The prompted period number is what I call [current month]. For [Previous Month] I do this: IF...

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 did try changing the data type in the output columns but I keep getting a message (for security reasons I have renamed the source file to 'FILE' in the message below) - Error at Download SOURCEFILE to Product_Temp [SOURCEFILE [1]]: The data type of output columns on the component...

Thanks for the posts. I've done a new test with a new data flow using the ADO.NET ODBC provider and this ran a lot faster (took half the time). Not sure why it didn't work in my first round of testing. The only thing is that I have to put a data conversion between the source and destination...

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...

I get this every now and again on 7.1. To get around it I just open the report from within Impromptu itself.

Take a look at line 3 of the IQD that is used in Transformer. This will give you the name of the database that it is trying to connect to. Check that this matches the database name in the signon box in Transformer. Or try creating this system dsn in ODBC Admin using the name on line 3 of the...

I take it you have set up the System DSN connection in your ODBC Data Sources?

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...

Go into Configuration Manager, select PowerPlay and then apply settings (no need to change any settings). Then try opening an .mdc again.

Are you using Impromptu or cognos 8?

drlex, thanks for the info. fortunately the user has changed their requirements (which normally annoys me!) so the number of rows has reduced significantly. Good job really as I don't think csv would have given the correct figures as all the groupings and summaries would have been lost. Nav

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...

Do you run a macro to do this extract or does the scheduler run the report itself? If it's a macro can you not include objImpApp.Quit at the end? Or you could use the Windows Kill command to kill the Impadmin.exe process?

As I wrote my last post Cognos came back to me with an answer (although looks like a tech note which we cannot access through their KB!) I should have realised this really but because some of the categories saved in the subset are not unique, a random category code will be generated for...