The problem:

When I try to execute a mdx with quotation mark inside, I get an error!

Why?
I know that (') is from mdx language.
Will I have to erase this characters from my databases?
I don't think it's good.

In my javascript code(asp):
var cst = new ActiveXObject("ADOMD.Cellset");
....
cst.Source = strSource + " CELL PROPERTIES FORMATTED_VALUE, BACK_COLOR,
FORE_COLOR";
cst.open();


strSource = " 'with ...'
Select {[Programa].[Sigla].[Todos os Programas].[Ajudar 'A INDUSTRIA],
[Programa].[Sigla].[Todos os Programas].[APOIO A PROJ SOCIAL],[Programa].
[Sigla].[Todos os Programas].[APOIO ENSINO SUPERIO]}
on rows,{[Measures].[Libera??es]} ON COLUMNS FROM [dwe_cubo_pird] CELL
PROPERTIES FORMATTED_VALUE, BACK_COLOR, FORE_COLOR"


The error occur when I execute cst.open()!
Microsoft? OLE DB Provider for Analysis Services error '80040e14'
Syntax error, expecting SELECT, near: 'A INDUSTRIA],[Programa].[Sigla].
[Todos...

--
Message posted via http://www.sqlmonster.com

You need to double up quotation marks within quotes:

Select {[Programa].[Sigla].[Todos os Programas].[Ajudar ''A INDUSTRIA],
[Programa].[Sigla].[Todos os Programas].[APOIO A PROJ
SOCIAL],[Programa].
[Sigla].[Todos os Programas].[APOIO ENSINO SUPERIO]}
on rows,{[Measures].[Libera??es]} ON COLUMNS FROM [dwe_cubo_pird] CELL
PROPERTIES FORMATTED_VALUE, BACK_COLOR, FORE_COLOR"

Here's an earlier thread that discusses this:

http://groups-beta.google.com/group/...rver.olap/msg/
5b1f83a30f0203eb
From: "George Spofford"
Date: Sat, 1 Jun 2002 07:33:16 -0700

Subject: MDX Error with Current Year's

One of those silly things: double it up inside.

With member [measures].[abc] as
'count(descendants([category].*[all Category].[current
year''s].[actuals],,leaves))'

HTH

--
George Spofford
Microsoft MVP
Chief Architect / OLAP Solution Provider
DSS Lab
http://www.dsslab.com
geo... (AT) dsslab (DOT) com
ISVs & IT organizations: Find out how DSS Lab can speed
your development!



- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

There is another error!

Microsoft® OLE DB Provider for Analysis Services error '80040e14'

Formula error - cannot find dimension member ("[Programa].[Sigla].[Todos os
Programas].[APOIO ''A INDUSTRIA]") - in a name-binding function

/Server_1.asp, line 520


"Deepak Puri" wrote:

Maybe you used double-quote characters (Ascii 34), instead of 2
single-quote characters (Ascii 39) - that's the only way I could create
the error message you got?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I didn't use double-quote characters (Ascii 34). I duplicate the ' in the
string, but it didn't work. I have to repair this error fast. It's crucial
for my application to repair this problem.

I used:
STRING_mdx.replace(/\'/mig,"''");

ERROR
<p>Microsoft® OLE DB Provider for Analysis Services</font> <font
face="Arial" size=2>error '80040e14'</font>
<p>
<font face="Arial" size=2>Formula error - cannot find dimension member
("[Programa].[CódSigla].[Todos os Programas].[010001 - APOIO ''A INDUSTRIA]")
- in a name-binding function</font>
<p>
<font face="Arial" size=2>/Server_1.asp</font><font face="Arial" size=2>,
line 520</font>


I'm waiting for a solution.

"Deepak Puri" wrote:

Is there any escape character in MDX Syntax?

"Andrew Vinich - Brazil" wrote:

I think your problem is the fact you wrap the WITH keyword with single
quotes ('). There really shouldn't be a problem with using single
quotes in names of members, unless you use them in calculation value
declarations, in which case you have to use double single quotes ('').

Instead of:

strSource = " 'with ...'
Select {[Programa].[Sigla].[Todos os Programas].[Ajudar 'A INDUSTRIA],
[Programa..."

try:

strSource = " with ... ' <your calculation value here> '" + "Select
{[Programa].[Sigla].[Todos os Programas].[Ajudar 'A INDUSTRIA],
[Programa..."

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Sorry...The correctly code is:

with member [Programa].[CódSigla].[Todos os Programas].[Sub Total] AS
'Aggregate({[Programa].[CódSigla].[Todos os Programas].[000000 - SEM
PROGRAMA],[Programa].[CódSigla].[Todos os Programas].[010001 - APOIO 'A
INDUSTRIA],[Programa].[CódSigla].[Todos os Programas].[011010 -
INS.BAS.-MINERACAO],[...]
})' SELECT {[Programa].[CódSigla].[Todos os Programas].[000000 - SEM
PROGRAMA],[Programa].[CódSigla].[Todos os Programas].[010001 - APOIO 'A
INDUSTRIA],[Programa].[CódSigla].[Todos os Programas...ON COLUMNS FROM [cubo]
CELL PROPERTIES FORMATTED_VALUE, BACK_COLOR, FORE_COLOR

"Elad I" wrote:

In the Excel this query works fine. I don't know how it works in Excel's
background to do this...I tryed to duplicate the single-quoted('), but it's
still wrong.

The error:
Microsoft® OLE DB Provider for Analysis Services error '80040e14'
Formula error - cannot find dimension member ("[Programa].[CódSigla].[Todos
os Programas].[010001 - APOIO ''A INDUSTRIA]") - in a name-binding function


"Elad I" wrote:

To confirm: you doubled the quote within quotes, like:

'Aggregate({[Programa].[CódSigla].[Todos os Programas].[000000 - SEM
PROGRAMA],[Programa].[CódSigla].[Todos os Programas].[010001 - APOIO
''A
INDUSTRIA],[Programa].[CódSigla].[Todos os Programas].[011010 -
INS.BAS.-MINERACAO],[...]
})' SELECT {[Programa].[CódSigla].[Todos os Programas].[000000 - SEM
PROGRAMA],[Programa].[CódSigla].[Todos os Programas].[010001 - APOIO 'A
INDUSTRIA],[Programa].[CódSigla].[Todos os Programas...ON COLUMNS FROM
[cubo]
CELL PROPERTIES FORMATTED_VALUE, BACK_COLOR, FORE_COLOR

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!