Recent content by navshiv

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.