Search results for query: *

I have just upgraded my Impromptu Admin software to V7.1 and have upgraded my catalog. Now when I try to upgrade and run a report I get the error ORA-00933: SQL command not properly ended. This also happens if I try to create a new very simple report over the catalog. Some other reports simply...

Great, that's done the trick! Minor thing is the month is defined as a no 1-12 rather than a string. Thanks for your help. Tiz

Thanks Lex, I get the theory. I've created my new time dimension with only months as a level. And I've told it to format the months as MMM rather than YYYY/MMM. But it still insists on giving me a category for each month for each year. Any ideas how I get it to group all Jans under one Jan? Tiz

Hi, I want to create a report in Powerplay which compares the sales values for each month in the current year with the corresponding month in the prior year. I am struggling! I want to produce something that looks roughly like this JAN FEB MAR APR etc curr year 10 20...

BRILLIANT! Yes I am using Oracle and changing the Cogdmor file seems to have fixed the problem. Thanks very much. Out of interest, what does this setting do?

I have just updated by catalog from Version 6 to version 7 MR2. A couple of my reports will no longer run. I have identified the problem as a calculated field. This calculated field determines the financial period relevent to a transaction (the catlog is over expense claims) so the calculation...