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:)
Report Portal
ROLAP report - error - P.ColumnDataType
Posted - 02/12/2009 : 06:38:34
