| T O P I C R E V I E W |
| myszak |
Posted - 02/12/2009 : 06:38:34
Hi!
Unfortunately I have another problem with ROLAP report. I created the cube Pubs, I followed the instructions from tutorial so everything should be ok. But the error appears when I try to design the report. When I drop the dimension (or level) to the Columns Drop Area or when I try to set up the filters the following windows dialog appears:
Error parsing xml
head
title
…The column prefix ‘P’ does not match with a table name or alias used in a query,: SQL:SELECT c.FactTableName , … (etc)… p.Columnname, P.ColumnDataType, p.CacheData, ….etc...
It looks like there is a mistake (“ P.ColumnDataType” instead of “p.ColumnDataType”) but I don’t know where to find it.
Thanks for help:)
|
| 3 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 02/20/2009 : 14:27:00
Does your SQL Server database have case sensitive collation? If yes, here are the instructions on how to change it to case insensitive collation:
http://bytes.com/groups/ms-sql/80144-change-case-sensitivity-after-database-set-up
|
| admin |
Posted - 02/19/2009 : 20:21:46
myszak,
Please export your report to an XML file (right click on your report and choose Export) and email it to support@ReportPortal.com
|
| myszak |
Posted - 02/12/2009 : 06:40:58
By the way:
I have ReportPortal 3.0 and SQL 2000. |
Report Portal
