OLAP Problem

[Gennadiy.Skuha]

Had anybody ever this problem?

Creating an Analysis view with a Mondrian Connection.

When Enter an MDX Query and click "next",

appear message "The following is not a valid MDX Query: Internal error: Error while creating SQL dialect".

Thanks a lot for every helps.

[rhancke]

Gennadiy.Skuha,

 

Could you post your mdx query code ?

 

 

Gennadiy.Skuha wrote:

Had anybody ever this problem? Creating an Analysis view with a Mondrian Connection. When Enter an MDX Query and click "next", appear message "The following is not a valid MDX Query: Internal error: Error while creating SQL dialect". Thanks a lot for every helps.

[Gennadiy.Skuha]

This is the MDX query (a sample from "JasperServer-Pro-User-Guide.pdf"):

 

select {[Measures].[Total Sale Amount], [Measures].[Number of Sales], [Measures].[Avg Sale Amount], [Measures].[Avg Time To Close (Days)], [Measures].[Avg Close Probablility]} ON COLUMNS, NON EMPTY {([Account Categorization].[All Accounts], [Close Period].[All Periods])} ON ROWS from [salesAnalysis] where [sale State].[All Types].[Closed Won]

 

It is for SugarCRM DB.

[swood]

You have a problem with the Mondrian Connection definition. What connection are you using for the view?

 

 

Sherman

JasperSoft

[Gennadiy.Skuha]

Yes, I have the problem with Mondrian Connection.

JDBC Data Source settings:

Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

URL: jdbc:microsoft:sqlserver://127.0.0.0:1433;DatabaseName=pubs

[Gennadiy.Skuha]

I glad to tell you that I decided my problem.

My MSSQL 2000 was required to install SP3(or higher)

My OS is WINXP and it had problem with MSSQL TCP connection on the default port 1433. I meen that command "telnet 127.0.0.1 1433" must perform successfully.

More info about this problem you could find here: http://support.microsoft.com/kb/313100

Thanks to all. ;)