I have a MDX query which includes a very simple calculated member. The query
returns correct number when I run it through the Sample MDX Application or
any other client applications. However, when I try to run the same query
using OPENQUERY statement (the Analysis Services is set up as linked server),
the calculated member returns null. Looks like the calculation for the
calculated member never got triggered. And ideas?

Thanks.

Security?
The domain account that the SQL service is running under must allow access
to the AS server (i.e. is it a domain account common between the RDBMS and
AS machines and does it have access to the cube? is there an Everyone role
in the cube?)

Can you see other measures? e.g. in the same cube? same database? same
server (i.e. can you see Foodmart?)

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"BBH" <BBH (AT) discussions (DOT) microsoft.com> wrote

It should not be a security issue. I was doing testing on a local machine
with SQL server and AS both installed. SQL service is running under local
administrator account which is also in the OLAP administrator group. The
OPENQUERY is embedded within a stored procedure running by system
administrator (windows authentication). Everything is tested on a local
machine, no net work is involved.

"Dave Wickert [MSFT]" wrote: