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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.