ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Check here to include your profile signature.
Check here to subscribe to this topic.

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.

ReportPortal