Showing posts with label service. Show all posts
Showing posts with label service. Show all posts

Wednesday, March 28, 2012

Question related to Analysis Service Roles

Hi,

One of my users is supposed to have full access to all other dimesions except for one and thus I have defined a customized role on one of 4 dimensions that I have.

When I test the role (from the front-end), I am getting a strange message in my front-end :confused: and could it be that I also have to define a role for this user on all other dimensions? Should I define the role on the server or the client :confused: I am a bit confused and will appreciate your help.

Thanks.Are you testing the role from your machine or from the users machine? What happens when they log on to your machine? Can you post the error message that you are getting?|||Are you testing the role from your machine or from the users machine? What happens when they log on to your machine? Can you post the error message that you are getting?
Hi and thanks for the reply.

At the moment I am testing this from my own machine by logging in (from my machine) as the test user and then trying to use the cube. Could this be the reason? The front-end that I'm using is MSDA (Microsoft Data Analyzer) and the error message that I get is as follows:

Formula error - cannot bind: unknown member: "[Product].[_MAXIMAL_MIN_]"

Any clues please.sql

Monday, February 20, 2012

Question on an unuall issue in SQL reporting Service

There is a developer here running a report using SQL reporting services, It
is a fairly large report and it seems to run fine, But when he tries to
export it to a CSV or EXCEL, it runs for two minutes then brings up an
authentication window, After he inputs his credentials it runs approx another
two minutes then wants him to re-authenticate, after the third instance of
this it fails and will not export. However if he tries to export a smaller
file, it works Okay. One caviat, I recieve an Event ID:10016 around the same
time and it says something about The COM not having a required permission, is
this a factor in my issue?
--
Scott A Cummins
Sr. Systems Engineer
Equity Analytics
( A division of Merrill Lynch)
14614 N. Keirland Blvd
Scottsdale, AZ 85254
480-998-3515On Mar 9, 12:19 pm, Scott Cummins <scumm...@.equitymethods.com> wrote:
> There is a developer here running a report using SQL reporting services, It
> is a fairly large report and it seems to run fine, But when he tries to
> export it to a CSV or EXCEL, it runs for two minutes then brings up an
> authentication window, After he inputs his credentials it runs approx another
> two minutes then wants him to re-authenticate, after the third instance of
> this it fails and will not export. However if he tries to export a smaller
> file, it works Okay. One caviat, I recieve an Event ID:10016 around the same
> time and it says something about The COM not having a required permission, is
> this a factor in my issue?
> --
> Scott A Cummins
> Sr. Systems Engineer
> Equity Analytics
> ( A division of Merrill Lynch)
> 14614 N. Keirland Blvd
> Scottsdale, AZ 85254
> 480-998-3515
It sounds like it. Normally, once a datasource has been set up for a
report, there is no further authentication necessary. Also, I myself
have never seen this occur when exporting to any format w/Reporting
Services (and I don't utilize COM objects in the process).
Regards,
Enrique Martinez
Sr. SQL Server Developer