Search results for query: *

Hi hmunk, Have a look at the ppadmtool. Discussed in the PDF manual for Powerplay Enterprise Server guide (page 81 I think). This tool allows you do various things such as change file names, publish documents, cubes etc.. all from the command line. This enables you to build a batch file...

Doesn't matter I fixed it.... Duh! For your info: select t.[order date], t.amount, d.discount, d.[effective date] from transactions t, discount d where t.customer = 'BILL' and t.customer = d.customer and t.[order date] >= d.[effective date] and d.[effective date] >= ( SELECT...

Hi there, I am hoping you can help me with a little puzzle I have here. I have two tables: 1. Transaction Table Order Date, Customer, Amount ======================================== 01/01/2003 BILL 10.00 02/01/2003 BILL 20.00 03/01/2003 BILL 30.00 2. Discount Table Customer, Effective...

I also had the same problem. If a field data-type is changed on a view/table that the impromptu report is running off you can sometimes get this message. The easiest way to fix it (depending on the number of tables) is to go into the catalog and verify each table/view... usually the one with...

As far as I know you can't tell Impromptu to close down after running a report when calling it from a batch file. The only way to do it would be to use a macro. You can tell transformer to run in batch mode - which is why it closes down after running - however as far as I am aware there is no...

Okay Ken - I've sent you a copy.

Hi there, dgillz - I've got the compiled UFL I wrote for Karen here in a little ZIP file, along with a little install script. I have e-mailed you a copy. As for everyone else - is there anywhere I can upload it to so everyone can have access to it? Or anyone with a web-site that will take it...

Hi, You don't want to pull your data into Transformer via Access, for exactly the reasons that you have said. What you need to do is: 1. Create an ODBC data source that can connect to the SQL Server. 2. In impromptu create a catalog which contains all the tables your required, all joins etc...

bsellick, I will certainly try that. It seems to be that the problem is occuring because I have multiple dimensions with customer information in - coming from one data source. For example some of the dimensions that my client has required are: Region Live or Withdrawn customer Customer...

Thanks for your help - I'll try to re-arrange a few dimensions and see if I can fix it.

Unfortunately the customer I am creating this cube for does not have impromptu on the desktop. Also they do need to see the customer level in the cube.

Hi there, I am hoping someone can help me as I am a little stuck here. I am trying to build a cube which has to include data for around a million customers. The problem is that there is no current classification in the database that I can break these customers down by. So when I add the...