Search results for query: *

Hi drlex. We have no suppression in use neither do we use forecasting. The report is the same against a Backup and a rebuilt version of the cube. I think we are going to have to put this to corruption. What do you think?

Hi drlex, thanks for the reply. I forgot to mention that this is with the client version. I know that the cube is OK as when I drag new rows and columns I do get values (but only where a new row and column meet). It's just that the rest of the report has all turned to NA for no reason. There...

If week number is not available to add to your source data, another way is to create a lookup table in Excel with 2 columns. One with the week start date and another with week number. The week start date column must be named as your date column and then the description can be added as label as...

Could you explain what you mean by SQL Reporting. We use SQL Server but use Impromptu (via ODBC connection) as the front-end and the saving as IQD to provide datasources for the models.

When updating a report with calculations the report suddenly turns all values to NA. Auto Calculation is set on and there is no reason to show NA's. if we add a new row and column, their specific values show OK but only for their row/column intersect. If we do an explain it shows like this...

Hi I have some DTS Packages that I have scheduled. What I would like to be able to do is see the progress of the packages as they are running. Like when you run the package in DTS Design mode, I would like to see the row counts as they update. Anyone got any ideas how I can do this please? Sean

Thanks for that DoubleD. I have heard (very little) of this company before. Do you know what the cost of their product is? What sort of detail does it include?

How do people feel about a program that will document Transformer Models. Aimed primarily at Transformer Models using IQD's as queries. It will output to HTML and an Access database. It will extract information from IQD's. It will automatically compare IQD's to the IMR to ensure they are...

I have a number of DTS packages that I have scheduled and so I have a list of Jobs. Within each Job there is a step that contains the DTSRun command to run the DTS package. My problem is that the DTSRun command is encrypted (/~Z etc...) and I want to move the jobs and DTS packages from SQL...

Thanks James. Will check them out later.

Hi I have a similar problem facing me. Did you find a good solution for this? Thanks ukflix.

Hi I have one server with version 7 that contains databases, views, sp's, DTS packages etc... and a seperate server running SQL server 2000 that is a new install. I need to move all the stuff from 7 to 2000. What is the easiest way to do this please? thanks.

Has anyone come across a bug in Powerplay version 6.61 onwards? After upgrading from 6.5 to 6.61+ my users PC's started to crash quite frequently. After much testing I noticed that the memory usage was rising very quickly until the PC crashed. Doing the same exercise with 6.5 worked perfect...

My queries run fine in Impromptu but when I try to build a cube I get "an arithmetic exception was detected...Error in assignment". Anyone seen this before?

Waspy, Do you have any more info about the Undo Bug please? ie. How do you know it exists? How do you prove the bug? Is it still present in version 7 (I think it is)? We still have some users on version 6.5 as this version works well and cannot upgrade them due to the way they work with...

Why do you say set the undo steps to 0? Do you suffer from the same bug too where resources are eaten away?

When a fairly complex report is created and saved with Powerplay 6.61. When the user tries to open it again it crashes and we get a memory could not be read error also the report is coorupted and cannot be opened by any other person. This is not the most complex report in the world and if it is...

Does anyone know where I can get an ODBC driver for DbaseII (*.db2 files)? Thanks in advance.