Re: Bug? -- Same MDX returns different result sets

From: BBH (BBH_at_discussions.microsoft.com)
Date: 02/26/05 

Date: Fri, 25 Feb 2005 20:47:02 -0800

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:

> 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@online.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@discussions.microsoft.com> wrote in message
> news:760C193E-507B-4F70-A0DB-8481E47248CE@microsoft.com...
> > 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.
>
>
>

Relevant Pages

  • Re: Bug? -- Same MDX returns different result sets
    ... The domain account that the SQL service is running under must allow access ... server ... > I have a MDX query which includes a very simple calculated member. ...
    (microsoft.public.sqlserver.olap)
  • RE: Execution Location Problem
    ... you won't be able to force execution location to the server, ... The only option you have is to use a different client I'm afraid. ... and calculated member fronts. ... > I have a cube with circumstances that would benefit from 100% server side ...
    (microsoft.public.sqlserver.olap)
  • Re: Cannot access recovery console
    ... We were having problems with an MSSQL DB on that server. ... stop/start of the SQL service appeared to fix the problem (i.e. ... volumes, and it did find both the logical C and D drives, as expected: ...
    (microsoft.public.win2000.general)
  • RE: Msg 15404: Could not obtain information about user
    ... even after rebooting the server and forcing a connect via TCP both ... Removing the sql service user from Domain ... ServerA is still showing the presence of the SPN entry. ...
    (microsoft.public.sqlserver.security)
  • Non empty for calculated members
    ... I have a cube with a calculated member The calculation for the calculated member "MyMembers" is a simple addition: ... In the MDX select statment I use the "non empty" expression on both columns and rows. ... I run SQL Server 2000 Enterprise edition with Analysis Server on windows 2000 server, Service Pack 3a is installed for sql server and analysis server. ...
    (microsoft.public.sqlserver.datawarehouse)
Loading